Multiple Choice
Identify the choice that best completes the statement or
answers the question.
|
|
|
1.
|
Which of these is the SUM function button?
|
|
|
2.
|
 What type of relationship is illustrated in this
picture?
a. | one-to-many | b. | one-to-one | c. | many-to-many | d. | indeterminate |
|
|
|
3.
|
What button in the Paragraph group allows you to
see nonprinting paragraph symbols?
a. | Clear Formatting | b. | Show/Hide | c. | Borders | d. | Center |
|
|
|
4.
|
What data type should you use for a field that will store telephone
numbers?
a. | Yes/No | b. | Text | c. | Date/Time | d. | Number |
|
|
|
5.
|
If you want to customize a print job you can display the Print dialog box
by
a. | clicking Print on the Page Layout tab. | b. | clicking the Office button, then clicking
Print. | c. | pressing Ctrl + P. | d. | b or c |
|
|
|
6.
|
You have typed several paragraphs of text, and
decide that you want them numbered. What do you do?
a. | Select the text and click the Numbering
button. | b. | Indent the text 0.5 inch from left margin, and numbers
will add automatically. | c. | Select the text
and press Ctrl + N. | d. | Delete the text
and retype with numbers. |
|
|
|
7.
|
An Excel workbook consists of multiple “pages” represented by tabs
at the bottom of the Excel window. These are called
a. | ranges. | b. | tables. | c. | worksheets, or
sheets. | d. | cells. |
|
|
|
8.
|
A database must contain as least one
a. | form. | b. | query. | c. | table. | d. | report. |
|
|
|
9.
|
 The icon in cell H2 in this illustration indicates
that the user is using the __________ feature in Excel. a. | AutoComplete | b. | AutoFill | c. | Help | d. | AutoCorrect |
|
|
|
10.
|
How do you select the text between the insertion
point and the I-beam pointer using the mouse?
a. | Click in the selection bar. | b. | Position the insertion point where you want to begin the selected text, hold
down the Shift key, click the I-beam pointer at the end of the selection, and release the Shift
key. | c. | Position the I-beam pointer on the first word of the
selected text, hold the left mouse button, drag the I-beam pointer to the last character to be
selected, and release the mouse button. | d. | all of the
above |
|
|
|
11.
|
 This images shows a
a. | table in Datasheet view. | b. | Form based on a table. | c. | Query in Design
view. | d. | table in Design view. |
|
|
|
12.
|
What symbol is used to indicate an absolute cell reference?
a. | pound or number sign (#) | b. | asterisk (*) | c. | dollar sign
($) | d. | exclamation point (!) |
|
|
|
13.
|
You can add a border to a selected cell or cells by clicking the Borders button
in the
a. | Page Layout tab, Page Setup group. | b. | Home tab, Font group. | c. | Page Layout tab,
Themes group. | d. | Home tab, Styles group. |
|
|
|
14.
|
 This image is part of
a. | a subdatasheet. | b. | the Relationships window. | c. | the Edit
Relationships dialog box. | d. | a Table Design
view. |
|
|
|
15.
|
By default, when inserting a column in worksheet, the new column is
placed
a. | immediately to the left of the column containing the active cell. | b. | at the far left of
the worksheet. | c. | immediately to the right of the column containing the active
cell. | d. | one column to the left of the last column of the worksheet that contains
data. |
|
|
|
16.
|
When a table is displayed in Datasheet view, each column represents a
a. | record in the table. | b. | field in the table. | c. | unique
value. | d. | query. |
|
|
|
17.
|
What is the default setting for top, bottom, left
and right margins?
a. | 1 inch | b. | 2 inches | c. | 1.25
inches | d. | 1.5 inches |
|
|
|
18.
|
Which document screen feature displays the open
programs in Microsoft Word?
a. | Title bar | b. | Status bar | c. | Quick Access
toolbar | d. | Taskbar |
|
|
|
19.
|
When creating a new table, by default Access provides the ____ field as the
first field and assigns it the ____ data type.
a. | ID; AutoNumber | b. | Sequence; Number | c. | Name;
Text | d. | Description; Text |
|
|
|
20.
|
If you have accidentally pressed the Delete key while writing a complex formula
in your worksheet, you will be happy to know that there is a(n) __________ button on the Quick Access
toolbar.
a. | Redo | b. | Undo | c. | Search | d. | Replace |
|
|
|
21.
|
How could you make a table of contents easier to
read using the Tabs dialog box?
a. | Change the tab stop
positions. | b. | Add leaders to the
tabs. | c. | Set decimal tabs. | d. | Clear the tabs. |
|
|
|
22.
|
What is the default typeface typically used in
Word?
a. | Times New Roman | b. | Calibri | c. | Arial | d. | Courier |
|
|
|
23.
|
To enter data in a cell, the cell must be
a. | empty. | b. | in the upper left corner of the worksheet
area. | c. | active. | d. | all of these. |
|
|
|
24.
|
What tool on the Status bar allows you to increase
or decrease the size of the document view?
a. | the Full Screen Reading
button | b. | the Draft button | c. | the Zoom slide bar | d. | the Book
icon |
|
|
|
25.
|
A primary key field ____ contain the same value for different records.
a. | should | b. | cannot | c. | can | d. | must |
|