True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
To print a wide database table, a table whose contents do not fit on the screen,
you will need portrait orientation.
|
|
|
2.
|
To find all clients whose amount paid is greater than $20,000.00 and whose
recruiter is recruiter 21, enter each criterion on the same line.
|
|
|
3.
|
Parameter queries are useful for summarizing data.
|
|
|
4.
|
The Find button is available only in Form view.
|
|
|
5.
|
To add a field to a table structure, click the row selector for the field that
will follow the new field, and then press the INSERT key to insert a blank row.
|
|
|
Figure 4-1
|
|
|
6.
|
In the accompanying figure, the worksheet contains 4 sections.
|
|
|
7.
|
The Currency style format has no impact on text in a cell.
|
|
|
8.
|
When you format a cell to display percentages, Excel will not assume that
whatever you enter into that cell in the future will be a percentage.
|
|
|
9.
|
Worksheets often have column titles at the top of each column and row titles to
the left of each row that describe the data within the worksheet.
|
|
|
Figure 4-2
|
|
|
10.
|
In the accompanying figure, after you set the print area and save the workbook,
Excel remembers this setting the next time you open the workbook.
|
|
|
11.
|
Data validation rules can be mandatory or informational.
|
|
|
12.
|
Each column of a table should have different data.
|
|
|
13.
|
The order of priority for sorting is: numbers, alphabetic characters, special
characters
|
|
|
14.
|
Options on the Sort & Filter menu change depending on the data in the
column.
|
|
|
Figure 5-2
|
|
|
15.
|
In the accompanying figure, the range A8:H8 was selected before clicking the
Format As Table button, so Excel automatically selects this range for the ‘Where is the data
for your table’ box.
|
|
|
Figure 6-1
|
|
|
16.
|
In the accompanying figure, the height of row 4 could have been adjusted by
dragging the bottom boundary of row heading 4 to the desired height as indicated in the
ScreenTip.
|
|
|
Figure 6-2
|
|
|
17.
|
In the accompanying figure, column B shows a linear series.
|
|
|
Figure 4-1
|
|
|
18.
|
You resize a chart, like the one shown in the accompanying figure, the same way
you resize any other graphical object.
|
|
|
19.
|
To create a complex table, one with different numbers of rows and columns,
select the dimension of the table in the Table gallery.
|
|
|
20.
|
To advance from the rightmost column in a table to the next row in the table,
press the ENTER key.
|
|
|
21.
|
The basic content of a group of form letters is the same; however, items like
name and address are different from one letter to the next.
|
|
|
22.
|
Word, by default, saves a data source in the My Data Sources folder on your hard
disk.
|
|
|
23.
|
Whether field codes are on or off on the screen has no effect on the merge
process.
|
|
|
24.
|
When you select two colors for a drawing object, Word uses a gradient effect to
blend them into one another.
|
|
|
25.
|
If a WordArt object that extends from the left to the right margins is centered
between the left and right margins, you may not notice a difference in its position after you click
the Center button.
|
|
|
26.
|
In Word, borders can be used to create ruling lines.
|
|
|
27.
|
A floating object can be positioned over or behind text in a document.
|
|
|
28.
|
When a clip art image is inserted into a document, Word inserts the picture as
an inline object.
|
|
|
29.
|
To position a pull-quote between columns, place a text box around it and then
move it to the desired location.
|
|
|
30.
|
Word allows you to split the window into two separate panes, each containing the
current document and having its own scroll bar.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
31.
|
In Access, table and field names can be up to ____ characters in length.
|
|
|
32.
|
A saved database is referred to as a ____.
a. | file | c. | DBMS | b. | databook | d. | template |
|
|
|
33.
|
You only can delete a primary key in ____ view.
a. | Datasheet | c. | Print Preview | b. | Layout | d. | Design |
|
|
|
34.
|
If the Field Size for a field whose data type is Number is set to ____, the
field size will be an integer value in the range of 0 to 255.
a. | Byte | c. | Least | b. | Smallint | d. | Integer |
|
|
|
35.
|
If a Security Warning appears when you open a database, click the ____ button to
display the Microsoft Office Security Options dialog box.
a. | Customize | c. | Security | b. | Options | d. | Warning |
|
|
|
36.
|
To view the results of a query, open it by right-clicking the query in the
Navigation Pane and clicking ____ on the shortcut menu.
a. | Datasheet View | c. | Run | b. | Design View | d. | Open |
|
|
|
37.
|
To save a query, click the Save button on the ____.
a. | Quick Access Toolbar | c. | Create tab on the Ribbon | b. | Home tab on the
Ribbon | d. | status
bar |
|
|
|
Figure 3-2
|
|
|
38.
|
To delete record EA45 shown in the accompanying figure, click the record
selector in the datasheet for the record on which the client number is EA45 and then press
____.
a. | CTRL+D | c. | CTRL+DELETE | b. | DELETE | d. | CTRL+Y |
|
|
|
39.
|
When you use Filter By Form to restrict records that appear, you create the
filter and then click the ____ button to apply the filter.
a. | Apply Filter | c. | Toggle Filter | b. | Filter | d. | Select |
|
|
|
40.
|
If the Client Number field in a record always should display the two characters
in the client number in uppercase, then the correct format for this field is ____.
|
|
|
41.
|
To include totals and other statistics at the bottom of a datasheet, click the
____ button on the Home tab to include the Total row in the datasheet.
a. | Statistics | c. | Insert Total | b. | Add Total | d. | Totals |
|
|
|
42.
|
You can ensure correctness in your formulas by carefully checking them using
____.
a. | Range Finder | c. | the TOTAL function | b. | the Ribbon | d. | the Edit menu |
|
|
|
43.
|
By double-clicking the ____ side of the heavy black border surrounding the
active cell, Excel will make the first non-blank cell in the row the active cell.
a. | top | c. | bottom | b. | left | d. | right |
|
|
|
44.
|
If more than one condition is true for a cell, then Excel applies the formats of
each condition, beginning with the____.
a. | most recent | c. | row | b. | first | d. | column |
|
|
|
45.
|
A series of fixed payments is called ____.
a. | an annuity | c. | a loan | b. | amortization | d. | a mortgage |
|
|
|
46.
|
To prevent round-off errors, use the ____.
a. | correct formula | c. | Range Finder | b. | ROUND function | d. | data table |
|
|
|
47.
|
A worksheet’s row-and-column structure can be used to organize and store a
____.
a. | table | c. | function | b. | formula | d. | cell |
|
|
|
48.
|
Excel automatically creates an empty row in the table so that you are ready to
enter the first ____ in the table.
a. | formula | c. | record | b. | field | d. | cell |
|
|
|
49.
|
A table_array contains table ____.
a. | text | c. | functions | b. | arguments | d. | dollar signs |
|
|
|
50.
|
The ____ expand or collapse rows in the worksheet.
a. | expand symbols | c. | collapse symbols | b. | row level symbols | d. | row expand and collapse
symbols |
|
|
|
Figure 5-2
|
|
|
51.
|
In the accompanying figure, the Format As Table dialog box is displayed when you
____.
a. | click the Format as Table button on the Design tab | c. | click the Format as Table button on
the Home tab | b. | point to a number of table quick styles in the Table Style
gallery | d. | enter data in a
range
|
|
|
|
52.
|
A section in a format code can be ____.
a. | functions | c. | zeros | b. | formulas | d. | colors |
|
|
|
53.
|
What happens if Excel replaces a text string?
a. | The replacement string is formatted as red italic font. | c. | A dialog box
indicates the number of replacements that were made. | b. | No replacement occurs on a Clustered Cone Chart
sheet. | d. | All of the
above |
|
|
|
54.
|
To select nonadjacent text, select the first item, hold the ____ key, and then
select the subsequent items.
|
|
|
55.
|
After you click the Draw Table command, the mouse pointer changes to the shape
of a(n) ____.
a. | pencil | c. | crosshair | b. | eraser | d. | block arrow |
|
|
|
56.
|
Use the ____ button on the Layout tab to display text vertically in a
cell.
a. | Flip or Rotate | c. | Text Direction | b. | Horizontal or Vertical Text | d. | Vertical Text |
|
|
|
Figure 5-3
|
|
|
57.
|
After the use of the dialog box shown in Figure 5-3, the phrase that will appear
after the word If is called a(n) ____.
a. | operator | c. | field | b. | expression | d. | condition |
|
|
|
58.
|
A ____ on the first page of a newsletter may consist, for example, of the
information above the multiple columns.
a. | table of contents | c. | nameplate | b. | headline | d. | subhead |
|
|
|
Figure 6-2
|
|
|
59.
|
The button used to create the WordArt shown in the accompanying figure is
located on the ____ tab.
a. | Home | c. | Page Layout | b. | Insert | d. | Drawing |
|
|
|
60.
|
The font size of text in columns should be no larger than ____ point.
|