1. When you link a worksheet and a chart in a business
report as well as on a slide, which Microsoft Office
applications are integrated?
A. Word, Excel, PowerPoint
B. Excel, Access, Word
C. Word, Access, PowerPoint
D. Excel, PowerPoint, Publisher
2. Which one of the following operations will move you from cell
B7 to cell B8 of a worksheet?
A. Pressing the right arrow key
B. Clicking on the down scroll arrow
C. Pressing the Enter key
D. Pressing the Page Down key
3. To select the range of cells A2:D12 and then F2:J12,
first click and drag to select A2:D12. Next, hold down
the _______ key while you select F2:J12.
A. CTRL C. ALT
B. Shift D. Tab
4. Which one of the following statements accurately describes the AutoNumbers field
in Access?
A. Requires a mathematical calculation
B. Includes the currency symbol
C. Is automatically assigned as the primary key
D. Can be edited with values from another table
5. Which type of file integration is the best choice when you wish to simultaneously
update information in several Office files?
A. Embedding C. Merging
B. Linking D. File sharing
6. What function will you get if you click on the button displaying the “Ó” symbol?
A. Hyperlink C. Merge and Center
B. Average D. AutoSum
7. Which part of the PowerPoint screen can be used to record extra information about a
slide that can be used by the speaker during the presentation?
A. Task pane C. Outline pane
B. Notes pane D. Design pane
8. Track Changes proposed by reviewers in Word
A. are visible to each reviewer.
B. must be routed to all reviewers two times.
C. show all changes in outline format.
D. aren’t displayed until all presentations have been merged.
9. If you want to multiply the contents of each of the cells in column C by the tax rate
that appears in cell A24, use a/an
A. relative cell reference. C. filter.
B. absolute cell reference. D. 3-D cell reference.
10. If you want to use one of PowerPoint’s preset formats that includes specific fonts,
hues, and background, you can apply a/an
A. animation scheme. C. design theme.
B. color scheme. D. slide layout.
11. To enhance the movement of graphic objects and bulleted text lists in your slideshow,
you should use
A. layouts. C. transitions.
B. animation. D. wizards.
12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When
you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes
you’ve made. This means that the object has been
A. hyperlinked. C. linked.
B. embedded. D. collaborated.
13. When you point to the bottom right-hand corner of a selected cell containing a formula
until you see a crosshair and drag it three cell to the right, you’re using Excel’s
_______ feature.
A. AutoFormat C. Copy
B. Paste D. Merge and Center
14. Which one of the following is a correctly written Excel formula?
A. =B*C4/2 C. B7>F12=
B. SUM(A5:A22) D. =C4*$G$18
15. You want colors, fonts, and other effects to be carried through all documents you
create in Word, PowerPoint, Excel, Publisher, and Access; therefore, you need to
create a custom
A. theme. C. layout.
B. AutoFormat. D. template.
16. If you wanted to locate and work with a list of all employees who earned more than
$25 per hour this month as recorded in the payroll worksheet, which one of the
following Excel features should you use?
A. Sort C. Find
B. AutoFilter D. 3-D Cell Reference
17. A table of contents for a report can be generated automatically only if you’ve
formatted your headings using
A. page numbers. C. themes.
B. links. D. styles.
18. To save yourself time so that you don’t have to key in your memo heading each time
you begin a new memo, create a
A. signature. C. Quick Part.
B. distribution list. D. style.
19. When using mail merge, the part that contains variable information such as
names and addresses is called the
A. merge fields. C. merged document.
B. main document. D. data source.
20. Options for designing the way text and graphics are positioned on a single
PowerPoint slide are provided by the slide
A. views. C. background.
B. design theme. D. layout.
my answers
1d
2d
3b
4c
5a
6d
7b
8a
9c
10b
11a
12a
13b
14a
15d
16c
17a
18b
19a
20d
To answer these questions, you need to have a basic understanding of the Microsoft Office applications and their features. Here are the explanations for each question:
1. When you link a worksheet and a chart in a business report as well as on a slide, which Microsoft Office applications are integrated?
To answer this question, you need to know which applications can be used to create business reports and slides.
The correct answer is A. Word, Excel, PowerPoint. Word is used for creating reports, Excel is used for creating charts and worksheets, and PowerPoint is used for creating slides.
2. Which one of the following operations will move you from cell B7 to cell B8 of a worksheet?
To answer this question, you need to know how to navigate between cells in a worksheet.
The correct answer is D. Pressing the Page Down key. The Page Down key moves you down one page in the worksheet, which will take you from cell B7 to cell B8.
3. To select the range of cells A2:D12 and then F2:J12, first click and drag to select A2:D12. Next, hold down the _______ key while you select F2:J12.
To answer this question, you need to know how to select multiple ranges of cells in Excel.
The correct answer is B. Shift key. Holding down the Shift key while selecting a range allows you to add to the previously selected range. So, after selecting A2:D12, you can hold down the Shift key and select F2:J12 to include both ranges in the selection.
And so on, for each question, you can follow the same approach of understanding the concepts behind the question and applying your knowledge of the Microsoft Office applications to determine the correct answer.