True/False Indicate whether the
statement is true or false.
|
|
|
1.
|
A worksheet is an electronic grid that performs numeric calculations.
|
|
|
2.
|
You can add more worksheets if you need more than the default number.
|
|
|
3.
|
When you first start Excel or open a workbook, the cell in the upper-right
corner of Sheet1 is always the active cell.
|
|
|
4.
|
Entering data in a worksheet requires you to first type data into the active
cell and then accept the entry.
|
|
|
5.
|
AutoFit allows you to single-click on a column boundary to automatically widen
or narrow it to fit the longest entry in the column.
|
|
|
6.
|
Formulas can only contain numbers and mathematical operators.
|
|
|
7.
|
You can copy and move formulas just like other data in a worksheet.
|
|
|
8.
|
You can revise the contents of a cell by editing its contents in the formula bar
or by double-clicking and typing directly in the cell.
|
|
|
9.
|
When you first enter data in a cell, Excel automatically right-aligns labels and
left-aligns values.
|
|
|
10.
|
You can format numbers to appear in one of several standard formats, including
currency, percent, and date.
|
Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
A ____ can contain one or more worksheets.
a. | notebook | c. | spreadbook | b. | workbook | d. | sheetbook |
|
|
|
12.
|
The intersection of a row and column is called a(n) ____.
a. | block | c. | data point | b. | object | d. | cell |
|
|
|
13.
|
In a worksheet, the cell with the dark border around it is the ____ cell.
a. | active | c. | preferred | b. | editing | d. | updating |
|
|
|
14.
|
You can refer to a cell by its ____, a column letter followed by a row
number.
a. | cell id | c. | placement | b. | cell address | d. | grid id |
|
|
|
15.
|
The ____ box shows the address of the selected cell.
a. | formula | c. | name | b. | data | d. | address |
|
|
|
16.
|
The ____ bar just above the column headings shows the contents of the selected
cell.
a. | formula | c. | name | b. | data | d. | address |
|
|
|
|
|
|
17.
|
In the accompanying figure, item 1 points to the ____.
a. | Name box | c. | Formula bar | b. | Office button | d. | Quick Access
toolbar |
|
|
|
18.
|
In the accompanying figure, item 2 points to the ____.
a. | View buttons | c. | Formula bar | b. | Office button | d. | Quick Access
toolbar |
|
|
|
19.
|
In the accompanying figure, item 4 points to the ____.
a. | Name box | c. | Formula bar | b. | Office button | d. | Quick Access
toolbar |
|
|
|
20.
|
In the accompanying figure, item 5 points to the active cell its name
is;.
|
|
|
21.
|
In the accompanying figure, item 8 points to the ____.
a. | View buttons | c. | Formula bar | b. | Office button | d. | Quick Access
toolbar |
|
|
|
22.
|
In the accompanying figure, item 12 points to the ____.
a. | View buttons | c. | Formula bar | b. | Office button | d. | Quick Access
toolbar |
|
|
|
23.
|
In a spreadsheet, the boxes at the top containing letters are known as ____
headings.
a. | data | c. | row | b. | sheet | d. | column |
|
|
|
24.
|
The boxes containing numbers on the left are known as ____ headings.
a. | data | c. | row | b. | sheet | d. | column |
|
|
|
25.
|
References to cell addresses, such as A1, E42 are known as ____.
a. | cell ids | c. | referent addresses | b. | cell references or address | d. | referent ids |
|
|
|
26.
|
All formulas must begin with a(n) ____.
a. | equal sign (=) | c. | minus sign (-) | b. | plus sign (+) | d. | forward slash |
|
|
|
27.
|
When you copy a formula using the fill handle, Excel automatically replaces the
original cell references with cell references that are in the same ____ position as those in the
original formula.
a. | absolute | c. | relative | b. | approximate | d. | possible |
|
|
|
28.
|
To indicate an absolute cell reference, you type a ____ before the part of the
address you want to remain constant.
a. | percent sign (%) | c. | forward slash (/) | b. | dollar sign ($) | d. | back slash (\) |
|
|
|
29.
|
You can copy or move cells, rows, or columns using the ____ group on the Home
tab.
a. | Duplicate | c. | Clipboard | b. | Search | d. | Save |
|
|
|
|
|
|
30.
|
In the accompanying figure, item 1 points to the ____.
a. | Center button | c. | Enter button | b. | Formula bar | d. | Merge and Center
button |
|
|
|
31.
|
In the accompanying figure, item 5 points to the ____.
a. | Center button | c. | Enter button | b. | Formula bar | d. | Merge and Center
button |
|
|
|
32.
|
You can format individual cells or a range of cells using the ____ group on the
Home tab.
a. | Format | c. | Object | b. | Font | d. | Style |
|
|
|
33.
|
You can add headers and ____ in an Excel worksheet containing important
information that you want to include at the top or bottom of each page.
a. | footers | c. | bottoms | b. | footnotes | d. | tails |
|
|
|
34.
|
It is important to ____ your work before printing, so that if you experience
technical problems while printing you do not lose your work.
a. | update | c. | review | b. | check | d. | save |
|
|
|
35.
|
____ lets you examine your document as it will appear when printed.
a. | Print View | c. | Print Preview | b. | Test Print | d. | Test View |
|