Name:     ID: 
 
Email: 

Microsoft Final

True/False
Indicate whether the statement is true or false.
 

 1. 

The Transfer command pastes a row of cells into a column, or a column of cells into a row.
 

 2. 

Word provides rulers along the bottom and right margins to help you as you format your documents.
 

 3. 

Automatic spelling and grammar checking can be turned on and off or adjusted in the Popular section of the Word Options dialog box.
 

 4. 

You can left-align, center, right-align, or justify your text.
 

 5. 

If a cell is not wide enough to display all the cell’s contents, extra text extends into the next cells if there is room.
 

 6. 

To apply a text effect to selected text, click the button corresponding to that effect in the Font group on the Home tab.
 

 7. 

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.
 

 8. 

Widows and orphans are avoided when automatic page breaks are inserted.
 

 9. 

An 11-point text in one font might be larger or smaller than 11-point text in another font.
 

 10. 

Design view is helpful when you prepare a worksheet for printing.
 

 11. 

In the Search for box, type a word or words that describe the type of clip art you wish to insert. These words are called clip art words.
 

 12. 

Formulas can include more than one operator.
 

 13. 

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
 

 14. 

To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.
 

 15. 

You cannot copy a chart you created in Excel to a report you are writing in Word.
 

 16. 

You can use the Format Painter to copy formatting only to adjacent cells or ranges.
 

 17. 

Each formula begins with a quotation mark (“).
 

 18. 

To change the format of text, you must first select the text you want to change.
 

 19. 

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.
 

 20. 

Grammar blocks are document parts that you can create, store, and reuse.
 

 21. 

Unlike the Office Clipboard, which is available all the time, you must activate the system Clipboard to use it.
 

 22. 

To add shading to an entire page, in the Page Background group on the Page Layout tab, click the Shading button.
 

 23. 

To change the paragraph from a numbered list to normal text, you can click the Text button in the Styles group on the Format tab.
 

 24. 

If you worked on the document recently, you can click the File tab, on the navigation bar,
click Recent, and then in the middle pane, click the name of the document in the list
of recently opened and saved documents.
 

 25. 

After you set a first-line indent in one paragraph, all subsequent paragraphs you type will have the same first-line indent.
 

 26. 

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.
 

 27. 

In the Align group, you can click the Recolor button, and then click a style to recolor the image all in one shade.
 

 28. 

The easiest way to change the font style is to select the text, and then click the Bold, Italic, or Underline buttons in the Font group on the Home tab.
 

 29. 

You can create a new folder in the Save As dialog box.
 

 30. 

To change the font of text not yet typed, you must save and reopen the file.
 

 31. 

You can keep clicking the Undo button to continue reversing recent actions, or you can click the arrow next to the Undo button to see a list of your recent actions.
 

 32. 

Sometimes a document can be more effective if the text is formatted in multiple columns.
 

 33. 

Print Layout view displays only the text of a document without showing the arrangement of the text.
 

 34. 

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.
 

 35. 

You can indent text either from the left margin, from the right margin, but not from both margins.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 36. 

Click the Ctrl+C keys to ____ selected cells.
a.
paste
c.
move
b.
copy
d.
cut
 

 37. 

If you try to close a workbook that contains changes you haven’t saved, ____.
a.
the workbook closes and your changes are lost
b.
the workbook closes and your changes are saved anyway
c.
you receive an error message
d.
a dialog box asks you whether or not you want to save the file
 

 38. 

The SUM function that adds the numbers in the range D5:D17 is ____.
a.
(D5:D17)SUM
c.
=SUM(D5:D17)
b.
=(D5:D17)SUM
d.
SUM(D5:D17)
 
 
Case EX 4-1
Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers.
 

 39. 

What should Kayden do to show the default calculations for a range of cells?
a.
Select the range and click the Sum button
b.
Select the range and the calculations will appear in the status bar
c.
Select the range and click the Number button
d.
Select the range and click the Calculate button
 
 
FIGURE WD 4-1

nar008-1.jpg
 

 40. 

The item numbered 3 in Figure WD 4-1 above is the ____ gallery.
a.
Fast Styles
c.
Styles
b.
Quick Styles
d.
Font Styles
 

 41. 

The item numbered 4 in Figure WD 4-1 above is the ____ of the Title Quick Style.
a.
Quick View
c.
Final Result
b.
Live Preview
d.
Font View
 
 
Case WD 5-2
Ron is preparing a price list to pass out to customers.  He will use tab stops to help with the formatting.
 

 42. 

At the top of the page, Ron wants to add a title, and have it centered.  To help, he chooses to use the ____.
a.
Justify tab stop
c.
Center tab stop
b.
Align tab stop
d.
Middle tab stop
 

 43. 

As Ron types in the numbers, he is having a hard time lining up the numbers.  He decides he wants to use the ____ so that the text is all aligned with the decimal point.
a.
Bank tab stop
c.
Decimal tab stop
b.
Money tab stop
d.
Currency tab stop
 
 
FIGURE WD 1-1

nar005-1.jpg
 

 44. 

Referring to Figure WD 1-1 above, the easiest way to change the Zoom percentage is to ____.
a.
drag the slider
c.
click the View tab on the Ribbon
b.
open the Zoom dialog box
d.
none of the above
 
 
FIGURE EX 2-1

nar002-1.jpg
 

 45. 

In Figure EX 2-1 above, you can see that when you wrap text, the ____increases automatically to display additional lines until all the text is visible.
a.
row width
c.
column width
b.
row height
d.
column height
 

 46. 

In Figure EX 2-1 above, the cell that shows wrapped text is ____.
a.
A16
c.
A19
b.
A18
d.
A21
 

 47. 

To select blocks of text that are not next to each other, select the first block of text, press and hold down ____, and then use the mouse to select additional blocks of text.
a.
F3
c.
CTRL
b.
ALT+TAB
d.
TAB
 

 48. 

The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____.
a.
comma
c.
colon
b.
period
d.
semicolon
 
 
Case WD 1-2
Sam’s mouse suddenly stopped working and he has an important project to get out the door. He decides to use keyboard shortcuts.
 

 49. 

To move to the beginning of the document, Sam should select the ____ keyboard shortcut.
a.
Ctrl+Home
c.
Ctrl+left arrow
b.
Home
d.
Ctrl+right arrow
 

 50. 

To increase or decrease the font size by small amounts, click the ____ Font or Shrink Font buttons in the Font group on the Home tab or on the Mini toolbar.
a.
Zoom
c.
Grow
b.
Maximize
d.
Enlarge
 

 51. 

You can change the line ____, or thickness, of lines or shape outlines in your drawing.
a.
shape
c.
depth
b.
contrast
d.
weight
 

 52. 

A ____ is text that prints in the top margin of each page.
a.
footer
c.
marker
b.
header
d.
margin
 

 53. 

A ____ is a preset collection of design elements, including fonts, colors, and other effects.
a.
gallery
c.
group
b.
theme
d.
style
 

 54. 

To access the Clipboard task pane, click the Clipboard Dialog Box Launcher on the ____ tab of the Ribbon. The Clipboard task pane appears in a separate pane along the left side of the worksheet.
a.
Data
c.
Edit
b.
Format
d.
Home
 

 55. 

To change text to italic, press the ____ keys.
a.
Ctrl+C
c.
Ctrl+I
b.
Ctrl+B
d.
Ctrl+V
 

 56. 

The style definition for headings usually includes a setting to keep the heading on the same page as the ____ in the next paragraph.
a.
last line
c.
either a. or b.
b.
first line
d.
neither a. nor b.
 

 57. 

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ____ group, click the arrow next to the Font box to display a gallery of available fonts.
a.
Data
c.
Edit
b.
Font
d.
Styles
 

 58. 

If Excel incorrectly flags a word that you use frequently as a misspelling, you can add the word to a custom dictionary that resides on your computer by clicking the ____ button.
a.
Customize
c.
Add to Dictionary
b.
Add to Excel
d.
Add to Thesaurus
 

 59. 

To change the object to a floating object that is positioned in a predetermined location on the page, click the Position button in the ____ group on the Format tab, and then click one of the options in the gallery under With Text Wrapping.
a.
Shapes
c.
Format
b.
Text
d.
Arrange
 
 
Case WD 1-1
Amanda has been using the Save and Save As command interchangeably, and it has caused some problems with her files. Amanda had opened her file from last year, “Junior Year Class Trip.docx,” and spent about an hour updating the text and photos to show the information from her Senior Year Class trip.
 

 60. 

When she was finished she clicked the “Save” button on the Quick Access toolbar. What information will be in the “Junior Year Class Trip.docx file?
a.
No information, the document will be blank
b.
Information from her Senior Year Class Trip
c.
Information from her Junior Year Class Trip
d.
Text only on both trips, no photos will be saved
 

 61. 

To name your style and add it to the Quick Styles gallery, open the Quick Styles gallery, and then click ____ on the menu at the bottom of the gallery.
a.
Save Selection as a New Quick Style
c.
New Quick Style
b.
Save as
d.
Save Selection
 

 62. 

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.
a.
Columns
c.
Rows
b.
Cells
d.
Headings
 
 
Case WD 4-2
Brad has finally got the layout of his brochure perfect on the first page and wants to copy that formatting to the second page.  He is going to use Format Painter.
 

 63. 

Brad wants to copy the formatting to more than one block of text.  He should ____ the Format Painter button.
a.
left-click
c.
single-click
b.
right-click
d.
double-click
 

 64. 

____ view simulates the way a document will look when it is viewed as a Web page.
a.
Outline
c.
Web Layout
b.
Print Layout
d.
Draft
 
 
FIGURE WD 7-1

nar012-1.jpg
 

 65. 

Referring to Figure WD 7-1 above, the entry with the words “Type text” is a ____ control.
a.
header
c.
content
b.
placeholder
d.
footer
 
 
FIGURE WD 6-1

nar011-1.jpg
 

 66. 

In Figure WD 6-1 above, on the far right of the Ribbon, in the Size group, there are two figures. The figure 2.17” is the shape ____.
a.
diameter
c.
width
b.
rotation setting
d.
height
 

 67. 

To use the Research tool, click the Review tab on the Ribbon. In the ____ group, click the Research button.
a.
Searching
c.
Proofing
b.
Formatting
d.
Editing
 
 
Case EX 2-1
Tessa’s boss has asked her to improve the appearance of a worksheet. Please answer the questions below.
 

 68. 

Tessa wants to find and replace italic text with bold text.  Where can she find the dialog box to do this?
a.
On the Home tab, in the Proofing group, click the Find & Select button, and then click Find.
b.
On the Home tab, in the Editing group, click the Find & Select button, and then click Replace.
c.
On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace.
d.
None of the above.
 

 69. 

When you click the New folder button, a new folder appears in the list with the temporary name “____” highlighted in blue.
a.
Name Me
c.
Default
b.
New Folder
d.
New
 
 

FIGURE EX 1-1

nar001-1.jpg
 

 70. 

Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee’s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.
a.
Match case
c.
both a. and b.
b.
Match entire cell contents
d.
neither a. nor b.
 



 
         Start Over