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