Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
You can enter the correct range in a function by typing the beginning and ending
cell references separated by a ____.
a. | semi-colon | c. | colon | b. | none of these | d. | period |
|
|
|
2.
|
Typing text, followed by two hyphens, followed by more text and then a space
changes the two hyphens to a(n) ____.
a. | border | c. | ampersand | b. | em dash | d. | en dash |
|
|
|
3.
|
A ____ is a prewritten formula that is built into Excel.
a. | calculation | c. | task | b. | function | d. | feature |
|
|
|
4.
|
Word includes a variety of document ____ to assist you with coordinating visual
elements in a document.
a. | layouts | c. | graphs | b. | formats | d. | themes |
|
|
|
5.
|
One way to add a correctly spelled word to the custom dictionary is to click the
____ button in the Spelling and Grammar dialog box
a. | Add to Dictionary | c. | New Entry | b. | Add to Custom | d. | Custom Entry |
|
|
|
6.
|
When you add a new slide following the title slide, PowerPoint uses the ____
slide layout for the new slide.
a. | Title and Content | c. | Title Only | b. | Blank | d. | Comparison |
|
|
|
7.
|
A ____ reference is an adjusted cell reference in a copied and pasted
formula.
a. | revised | c. | relative | b. | retained | d. | recycled |
|
|
|
8.
|
Having used the Color gallery to change the color of a graphic, with the graphic
selected, click ____ in the Color gallery to change a graphic back to its original color.
a. | Revert | c. | No Recolor | b. | Restore | d. | Default Color |
|
|
|
9.
|
____ view allows you to look at several slides at one time.
a. | Review Sorter | c. | Slide Sorter | b. | Slide Show | d. | Reading |
|
|
|
10.
|
The shortcut keys used to center a paragraph are ____.
a. | CTRL+T | c. | CTRL+M | b. | CTRL+E | d. | CTRL+SHIFT+T |
|
|
|
11.
|
In the ____ letter style, all components of the letter begin flush with the left
margin.
a. | block | c. | modified semi-block | b. | modified block | d. | all of the
above |
|
|
|
12.
|
In a business letter, the ____, if present, begins two lines below the last line
of the inside address.
a. | salutation | c. | message | b. | date line | d. | complimentary
close |
|
|
|
13.
|
You can select slide objects in order to delete them simultaneously by pressing
the ____ key as you click each object.
|
|
|
14.
|
To display the Color gallery, with the graphic selected, click the Color button
in the ____ group on the PICTURE TOOLS FORMAT tab.
a. | Adjust | c. | Tools | b. | Format | d. | Options |
|
|
|
15.
|
If a flagged word is spelled correctly, right-click it and then click ____ on
the shortcut menu to instruct Word not to flag future occurrences of the same word in this
document.
a. | Do Not Correct | c. | Correct Spelling | b. | Not a Mistake | d. | Ignore All |
|
|
|
16.
|
A ____ is a named group of formatting characteristics.
a. | set | c. | plan | b. | group | d. | style |
|
|
|
17.
|
You can insert a new slide by pressing the ____ keyboard shortcut keys.
a. | CTRL+N | c. | CTRL+I | b. | CTRL+HOME | d. | CTRL+M |
|
|
|
18.
|
The adjusted cell references in a copied and pasted formula are called ____ cell
references.
a. | relative | c. | alternative | b. | related | d. | pasted |
|
|
|
19.
|
The path to the Format Painter button is ____.
a. | (HOME tab | Font group) | c. | (HOME tab | Number
group) | b. | (HOME tab | Painting group) | d. | (HOME tab | Clipboard group) |
|
|
|
20.
|
____ includes special visual and sound effects applied to text or other
content.
a. | Visual effects | c. | Animations | b. | Playback control | d. | Audio control |
|
|
|
21.
|
In the ____ letter style, the date, complimentary close, and signature block are
positioned approximately one-half inch to the right of center or at the right margin.
a. | block | c. | modified block | b. | all of the above | d. | semi-modified
block |
|
|
|
22.
|
All of the following are guidelines about the appearance of letterhead elements
EXCEPT ____.
a. | use fonts that are easy to read | c. | choose colors that convey your
goals | b. | consider formatting your name in bold | d. | make the font size of your name the same size
as the rest of the text in the letterhead |
|
|
|
23.
|
Which of the following formulas contains an absolute cell reference?
|
|
|
24.
|
____ help one slide flow gracefully into the next during a slide show.
a. | Shapes | c. | Variants | b. | Transitions | d. | Videos |
|
|
|
25.
|
Each time you press the ____ key, Word carries forward custom tab stops to the
next paragraph.
|
|
|
26.
|
A ____ is a specific design with coordinating colors, fonts, and special
effects.
a. | placeholder | c. | document theme | b. | slide show | d. | chart |
|
|
|
27.
|
When you set up a worksheet, you should use cell references in formulas whenever
possible, rather than ____ values.
a. | calculated | c. | consistent | b. | constant | d. | logical |
|
|
|
28.
|
Adding a ____ to text adds depth and helps the letters display
prominently.
a. | shadow | c. | sizing handle | b. | shape | d. | font |
|
|
|
29.
|
Combining two or more selected cells into one cell is called ____ cells.
a. | combining | c. | spanning | b. | mixing | d. | merging |
|
|
|
30.
|
Footnote text is _____.
a. | double-spaced, right-aligned, and a smaller font size than the text in the research
paper | c. | double-spaced, left-aligned, and a smaller font size than the text in the research
paper | b. | double-spaced, left-aligned, and the same font size as the text in the research
paper | d. | single-spaced,
left-aligned, and a smaller font size than the text in the research
paper |
|
True/False
Indicate whether the
statement is true or false.
|
|
|
31.
|
Some themes center text paragraphs between the left and right placeholder
borders.
|
|
|
32.
|
Word inserts text to the right of the insertion point.
|
|
|
33.
|
PowerPoint provides only three picture effects.
|
|
|
34.
|
The AutoCorrect feature can automatically capitalize the first letter in the
names of days.
|
|
|
35.
|
Worksheet titles and subtitles should be as wordy as possible.
|
|
|
36.
|
Excel can display characters in only three font colors: black, red, and
blue.
|
|
|
37.
|
To zoom a document using a touch screen, repeatedly pinch and stretch in order
to change the size of the document in the document window.
|
|
|
38.
|
A slide show is another name for a PowerPoint presentation.
|
|
|
39.
|
You cannot adjust the volume of sound that has been recorded on a file.
|
|
|
40.
|
In the MLA style, notes are used only for optional content or bibliographic
notes.
|
|
|
41.
|
Gradient fill is one color shade gradually progressing to another shade of the
same color or one color progressing to another color.
|
|
|
42.
|
An inline object is an object that can be positioned at a specific location in a
document or in a layer over or behind text in a document.
|
|
|
43.
|
Excel has more than 400 functions that perform just about every type of
calculation you can imagine.
|
|
|
44.
|
Both the Cancel button and the Enter button appear on the formula bar when you
begin typing in a cell.
|
|
|
45.
|
You can apply artistic effects to a picture used as a slide’s
background.
|
|
|
46.
|
Excel includes four types of sparkline charts: line, column, win/loss, and
stock.
|
|
|
47.
|
The arithmetic operator, ^, directs Excel to perform the division
operation.
|
|
|
48.
|
The most common error when entering a formula is to reference the wrong cell in
the formula.
|
|
|
49.
|
The layout gallery displays 10 slide layouts with a variety of placeholders to
define text and content positioning and formatting.
|
|
|
50.
|
By default, PowerPoint ends a slide show with a black slide.
|