Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
To open a table in Design view, right-click the table in the Navigation Pane and
then click ____ on the shortcut menu
a. | Table Design | c. | Structure View | b. | Design View | d. | Layout View |
|
|
2.
|
To import data to a table, click the ____ tab on the Ribbon.
a. | Database Tools | c. | Import | b. | File | d. | External Data |
|
|
3.
|
To create a parameter query, enter a parameter rather than a specific value as a
criterion in the design grid. The parameter must be enclosed in _____.
a. | curly braces { } | c. | parentheses ( ) | b. | square brackets [
] | d. | single quotes
‘’ |
|
|
4.
|
To order the records in the answer to a query in a particular way, you ____ the
records.
a. | index | c. | arrange | b. | sort | d. | list |
|
|
5.
|
To find the largest amount paid amount for a client, select _____ as the entry
in the Total row for the Amount Paid column.
a. | Large | c. | LGE | b. | Maximum | d. | MAX |
|
|
6.
|
Which of the following is the Ribbon path to the Cell Styles button?
a. | (Home tab | Styles group) | c. | (Home tab | Format
group) | b. | (Styles tab | Home group) | d. | (Format tab | Styles group) |
|
|
7.
|
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals
_____.
|
|
8.
|
The _____ function sums the numbers in the specified range and then divides the
sum by the number of cells with numeric values in the range.
|
|
9.
|
The _____ function determines the lowest number in a range.
|
|
10.
|
The _____ displays numbers with a fixed dollar sign to the left of the number, a
comma every three positions to the left of the decimal point, and displays numbers to the nearest
cent.
a. | Comma style format | c. | Percent style format | b. | Accounting number format | d. | Currency style
format |
|
|
11.
|
A _____ provides consistency in design and color throughout the entire
presentation.
a. | placeholder | c. | chart | b. | slide show | d. | document theme |
|
|
12.
|
The default document theme is the _____.
a. | Opulent theme | c. | Office Theme | b. | Oriel theme | d. | Origin theme |
|
|
13.
|
The box on a slide that has a dotted or hatch-marked border and that contains
the insertion point is a text _____.
a. | placeholder | c. | layout | b. | pane | d. | recorder |
|
|
14.
|
The Undo button is located on the _____.
a. | Home tab on the Ribbon | c. | vertical scroll bar | b. | Quick Access Toolbar | d. | status bar |
|
|
15.
|
When you add a new slide following the title slide, PowerPoint uses the _____
slide layout for the new slide.
a. | Title Only | c. | Comparison | b. | Title and Content | d. | Blank |
|
|
16.
|
The _____, or typeface, defines the appearance and shape of letters, numbers,
and special characters.
a. | font | c. | point | b. | font size | d. | paragraph
formatting |
|
|
17.
|
A(n) ____ paragraph is a paragraph that begins with a dot or other
symbol.
a. | headline | c. | bulleted | b. | centered | d. | indexed |
|
|
18.
|
Each time the _____ key is pressed, the paragraph formatting in the previous
paragraph is carried forward to the next paragraph.
a. | ENTER | c. | CTRL | b. | SHIFT | d. | ALT |
|
|
19.
|
The Word Count dialog box displays the number of words as well as the number of
_____ in the current document.
a. | lines | c. | paragraphs | b. | characters | d. | all of the
above |
|
|
20.
|
When the same word is used in multiple locations or a word is used that was not
quite appropriate, a thesaurus can be used to look up a(n) _____, or a word similar in
meaning.
a. | synonym | c. | antonym | b. | homonym | d. | metronym |
|