. 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
my answers
1d No
2d No
3b No
4c I've never used Access so can't help you here.
5a No
6d
7b Yes
8a I think so.
9c I don't think so.
10b I think so.
11a I don't think so.
12a No; see your answer to #5.
13b No
14a No
15d I think so.
16c No
17a No; you don't put page numbers in the Headings.
18b No
19a No
20d Yes
Since I have never used Access, rarely use PowerPoint, and use Excel only basically, you should go back into your study materials and/or go into each program and use its Help file (press the F1 key).
1. The correct answer is A. Word, Excel, PowerPoint. To link a worksheet and a chart in a business report as well as on a slide, you need to have Microsoft Word, Excel, and PowerPoint integrated.
2. The correct answer is C. Pressing the Enter key. To move from cell B7 to cell B8 of a worksheet, you can simply press the Enter key on your keyboard.
3. The correct answer is B. Shift. To select the range of cells A2:D12 and then F2:J12, you can first click and drag to select A2:D12. Next, hold down the Shift key while you select F2:J12.
4. The correct answer is C. Is automatically assigned as the primary key. The AutoNumbers field in Access is automatically assigned as the primary key, which means it is a unique identifier for each record in the table.
5. The correct answer is B. Linking. When you wish to simultaneously update information in several Office files, the best choice is to use linking. This allows you to create a connection between files so that any changes made in one file are reflected in the others.
6. The correct answer is D. AutoSum. Clicking on the button displaying the "∑" symbol in Excel will activate the AutoSum function. This function automatically adds up the selected cells and displays the total.
7. The correct answer is B. Notes pane. The Notes pane in PowerPoint can be used to record extra information about a slide that can be used by the speaker during the presentation. It is not visible to the audience.
8. The correct answer is A. Are visible to each reviewer. Track Changes proposed by reviewers in Word are visible to each reviewer. This allows multiple reviewers to make edits and comments in the same document, with their changes clearly marked.
9. The correct answer is B. Absolute cell reference. To multiply the contents of each of the cells in column C by the tax rate that appears in cell A24, you would use an absolute cell reference for A24. This ensures that the reference to A24 does not change as you copy the formula to other cells.
10. The correct answer is C. Design theme. If you want to use one of PowerPoint's preset formats that includes specific fonts, hues, and background, you can apply a design theme. This will automatically apply the chosen formatting to your slides.
11. The correct answer is B. Animation. To enhance the movement of graphic objects and bulleted text lists in your slideshow, you should use animation. Animation allows you to add visual effects and transitions to your slides.
12. The correct answer is C. Linked. If you edit the pie chart in Excel and the changes are not reflected in the pie chart in PowerPoint, it means that the object has been linked. A linked object maintains a connection to its source file, and any changes made in the source file will be reflected in the linked object.
13. The correct answer is C. Copy. To drag a selected cell containing a formula three cells to the right in Excel, you would use the Copy feature. Select the cell, point to the bottom right-hand corner until you see a crosshair, and then drag it three cells to the right.
14. The correct answer is A. =B*C4/2. This is a correctly written Excel formula. It multiplies the values in cells B and C4, and then divides the result by 2.
15. The correct answer is A. Theme. If you want colors, fonts, and other effects to be carried through all documents you create in Word, PowerPoint, Excel, Publisher, and Access, you need to create a custom theme. A theme is a collection of predefined formatting options that can be applied to multiple documents.
16. The correct answer is B. AutoFilter. 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, you should use the AutoFilter feature in Excel. This allows you to filter and display only the desired data based on specific criteria.
17. The correct answer is D. Styles. A table of contents for a report can be generated automatically only if you've formatted your headings using styles. Styles provide consistent formatting and structure to your document, allowing for easier generation of a table of contents.
18. The correct answer is D. Style. To save yourself time and avoid typing your memo heading each time, you should create a style. A style is a collection of formatting settings that can be applied to text with a single click.
19. The correct answer is A. Merge fields. When using mail merge, the part that contains variable information such as names and addresses is called the merge fields. These merge fields are replaced with the respective information from the data source during the merge process.
20. The correct answer is D. Layout. Options for designing the way text and graphics are positioned on a single PowerPoint slide are provided by the slide layout. The layout determines the arrangement of placeholders and content on a slide.