Name:     ID: 
 
Email: 

Computer Application Final

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

 1. 

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

 2. 

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.
 

 3. 

A format is the design of text.
 

 4. 

COUNT CELLS determine how many entries are included in the range.
 

 5. 

A chart sheet does not have worksheet cells and cannot contain data or formulas.
 

 6. 

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.
 

 7. 

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

 8. 

To replace all instances of the Find what text with the Replace with text, click Replace Now.
 

 9. 

Quick Parts you create are stored in the Quick Parts gallery.
 

 10. 

AutoComplete is a feature in Word that automatically completes the spelling of days of the week and months of the year that have less than three letters in their names.
 

 11. 

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

 12. 

When you are creating a document, you should consider what kind of impression you want the text to make.
 

 13. 

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

 14. 

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

 15. 

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

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

 16. 

When Excel starts, the program window displays a blank workbook titled Book1, which includes ____ blank worksheets.
a.
one
c.
three
b.
two
d.
four
 

 17. 

To replace cell contents, you can select the cell, type the new data, and then enter the data by  ____.
a.
pressing the Enter key
b.
pressing the Tab key
c.
clicking the Enter button on the Formula bar
d.
all of the above
 

 18. 

You can close a workbook by clicking the ____ tab on the Ribbon, and then clicking Close in the navigation bar.
a.
Home
c.
Review
b.
File
d.
View
 

 19. 

You can change the active worksheet in a workbook to next worksheet by pressing the ____+Page Down keys.
a.
Fn
c.
Alt
b.
Ctrl
d.
Tab
 
 

FIGURE EX 1-1

nar001-1.jpg
 

 20. 

Referring to Figure EX 1-1 above, if you entered an incorrect value in one of the cells and wanted to find it, you would choose “cell contents” as your place to search in the ____ option box.
a.
Look in
c.
Within
b.
Search
d.
Replace with
 
 
Case EX 1-1
Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking.
 

 21. 

Nicole notices that the point changes shape to become a ____ when it is in the worksheet.
a.
white arrow
c.
black arrow
b.
thick white plus sign
d.
thick black plus sign
 

 22. 

When Nicole moves the pointer to a button on the Ribbon, the pointer changes to a ____.
a.
white arrow
c.
black arrow
b.
thick white plus sign
d.
thick black plus sign
 

 23. 

Excel ____ all numbers.
a.
right-aligns
c.
top-aligns
b.
left-aligns
d.
bottom-aligns
 

 24. 

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.
a.
Align
c.
Center
b.
Merge
d.
Merge & Center
 

 25. 

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.
Format
c.
Data
b.
Home
d.
Edit
 

 26. 

You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys.
a.
Ctrl+? (question mark)
c.
Ctrl+! (exclamation point)
b.
Ctrl+` (grave accent)
d.
Ctrl+* (asterisk)
 

 27. 

The SUM function that adds the numbers in the range D5:D17 is ____.
a.
SUM(D5:D17)
c.
(D5:D17)SUM
b.
=SUM(D5:D17)
d.
=(D5:D17)SUM
 
 
Case EX 4-2
Ben is copying some formulas and wants to make sure he has the cell references correct.
 

 28. 

Ben also wants to copy a formula from the bottom of the spreadsheet and put it at the top of the spreadsheet in a summary section.  He wants the formula to stay exactly the same and result in the same figure. What type of cell reference should Ben use?
a.
Mixed
c.
Absolute
b.
Relative
d.
None of the above
 

 29. 

An example of the function of the natural logarithm of a number written correctly is ____.
a.
=LOG(50)
c.
=NL(50)
b.
=LN(50)
d.
=(NL,50,2)
 

 30. 

In the IF function, the third argument determines the value that appears in the cell if the logical test is ____.
a.
false
c.
an error
b.
true
d.
none of the above
 
 
Case EX 5-1
Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet.
 

 31. 

Cheryl has found the formula she wants to use by using Formula AutoComplete.  How can she access a Screen Tip to guide her in entering the necessary arguments?
a.
Double-click the name of the function
b.
Double-click anywhere inside the worksheet
c.
Double-click anywhere outside the worksheet
d.
None of the above
 

 32. 

The chart types are available on the ____ tab in the Charts group.
a.
Data
c.
Worksheet
b.
Edit
d.
Insert
 

 33. 

You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.
a.
Text box
c.
File name
b.
Rename
d.
Chart name
 

 34. 

A selected chart element is surrounded by a ____.
a.
fill box
c.
text box
b.
selection box
d.
border
 

 35. 

You can change a chart type or subtype at any time. On the Design tab, under Chart Tools on the Ribbon, in the ____ group, click the Change Chart Type button.
a.
Type
c.
Text
b.
Format
d.
Style
 

 36. 

When using ____ software such as Word, you can easily create and edit documents, such as letters and reports.
a.
spreadsheet
c.
presentation
b.
database
d.
word processing
 

 37. 

Pressing the ____ key deletes the character to the left of the insertion point.
a.
Enter
c.
Backspace
b.
Tab
d.
Delete
 

 38. 

To exit Word, click the Close button in the ____ corner of the document window.
a.
upper-right
c.
upper-left
b.
lower-right
d.
lower-left
 
 
FIGURE WD 1-1

nar005-1.jpg
 

 39. 

Referring to Figure WD 1-1 above, the document percentage that would make your document the largest is ____.
a.
15%
c.
65%
b.
50%
d.
100%
 

 40. 

When a toggle command on a menu is selected, a(n) ____ appears next to it.
a.
asterisk
c.
arrow
b.
question mark
d.
check mark
 

 41. 

To select text with the mouse, position the I-beam pointer to the left of the first character of the text you want to select. Hold down the left button on the mouse, drag the pointer to the end of the text you want to select, and release the button. This is called ____.
a.
dropping
c.
pasting
b.
copying
d.
dragging
 

 42. 

When you cut selected text, it is removed from the document and placed ____.
a.
on the Clipboard
c.
in the Recycle bin
b.
on the Desktop
d.
in the System tray
 

 43. 

Clicking the Paste button or pressing Ctrl+V pastes the contents of the ____ Clipboard into the document.
a.
system
c.
both a. and b.
b.
Office
d.
neither a. nor b.
 

 44. 

With Automatic spell checking, a ____, wavy underline indicates a word that might be misused.
a.
blue
c.
red
b.
green
d.
yellow
 
 
FIGURE WD 3-1

nar006-1.jpg
 

 45. 

When a contextual spelling error is detected, the dialog box that appears is the same as the one shown in Figure WD 3-1 above, but only the Change and ____ commands are available.
a.
Ignore Once
c.
Change All
b.
Ignore All
d.
Auto Correct
 
 
Case WD 3-1
Sela is learning about all the options in the Spelling and Grammar dialog box.
 

 46. 

Sela has completed a 100-page Employee manual. She will update a page occasionally, and notices that takes a long time to check the entire 100 pages for spelling and grammar errors. Sela should ____.
a.
only check the portion of the document that she has just updated for spelling and grammar errors
b.
not use the Spelling and Grammar checker, but instead be more careful to not make errors
c.
use AutoComplete more often
d.
none of the above
 

 47. 

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

 48. 

Like font styles, font effects are ____ commands—a font effect is either turned on or off.
a.
toggle
c.
simple
b.
switch
d.
click
 

 49. 

The ____ determines the default font, the color of headings formatted in the Heading Quick Styles, and other features of the document.
a.
theme
c.
effect
b.
style
d.
layout
 

 50. 

When you remove a style, the ____ Style is automatically applied.
a.
Normal Quick
c.
Quick
b.
Normal
d.
Microsoft 100
 
 

Case WD 4-1
Charlotte wants to apply a theme to the paper she is writing for her Art design class.
 

 51. 

As a first step, Charlotte decides to review the themes. One of the first things she notices is that they are organized ____.
a.
by color
c.
alphabetically
b.
by number of colors
d.
by category
 
 
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.
 

 52. 

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

 53. 

The Intense Quote Quick Style reformats paragraphs so ____.
a.
they are indented from both margins
b.
the text is the color of Accent 1 color
c.
a colored horizontal line is added under the last paragraph in the quote
d.
all of the above
 
 
Case WD 5-1
Genny is completing a research paper that requires some different types of paragraph formatting.
 

 54. 

Genny notices that Line spacing is at 1.15 and Paragraph spacing says 10pt of spacing after the paragraph.  She is wondering if one or both of these entries is a Microsoft default.  She figures out that the figure for ____ is a Microsoft default.
a.
Paragraph spacing
b.
Line spacing
c.
both a. and b.
d.
neither a. nor b.
 

 55. 

If you use the ____ button in the Font group on the Home tab, you can apply the same effect as with the WordArt button, but the text is not placed in a text box.
a.
Text Effects
c.
Transform Text
b.
Text Styles
d.
Font Styles
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Style
b.
Font size
c.
Font
d.
Cell style
e.
Font style
 

 56. 

Features such as bold, italic, and underlining that add emphasis to a font.
 

 57. 

A collection of formatting characteristics you apply to a cell or range of data.
 

 58. 

Combination of formatting characteristics such as alignment, font color, and borders.
 

 59. 

The design of text. 
 

 60. 

Determines the height of characters as measured in points.
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Paste
b.
Margins
c.
Cut
d.
Scale
e.
Copy
 

 61. 

Enables you to resize a worksheet to print on a specific number of pages.
 

 62. 

Blank spaces around the top, bottom, and sides of a page.
 

 63. 

Duplicates the cell’s contents without affecting the original cell.
 

 64. 

The selected cell contents are placed as an item on the Clipboard and are removed from their original location.
 

 65. 

Places the last item from the Clipboard into the cell or range selected in the worksheet.
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Match case
b.
Sounds like (English)
c.
Match suffix
d.
Incremental find
e.
Match prefix
 

 66. 

Finds words that begin with the text you type in the Search Document box.
 

 67. 

Finds words that end with the text you type in the Search Document box.
 

 68. 

Searches for words with the same capitalization as the text that you type.
 

 69. 

Locates homonyms.
 

 70. 

Finds the text as you type.
 



 
         Start Over