True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Before you
enter data into a worksheet, you should determine its purpose and give it a meaningful
title.
|
|
|
2.
|
The
information you collect for a worksheet is called output.
|
|
|
3.
|
Numbers used
in calculations are called results.
|
|
|
4.
|
The desired
results for a worksheet are called the output.
|
|
|
5.
|
Labels are
used in calculations.
|
|
|
6.
|
When entered
in a cell, text, such as "Summer 2003", is a label.
|
|
|
7.
|
When entered
in a cell, text, such as "Summer 2003", is a value.
|
|
|
8.
|
To change
the contents of a cell, put Excel into Edit mode.
|
|
|
9.
|
To correct
mistakes, press [F2] and [Esc].
|
|
|
10.
|
The Undo
button allows you to reverse up to 16 previous actions at the same time.
|
|
|
|
|
|
11.
|
In the
figure above, item 3 is the Redo button.
|
|
|
12.
|
The mode
indicator is located on the far-right side of the status bar.
|
|
|
13.
|
The mode
indicator is located on the far-left side of the status bar.
|
|
|
14.
|
In the Open
dialog box, you can double-click the filename to open a workbook.
|
|
|
15.
|
A group of
two or more cells is called a range.
|
|
|
16.
|
To select a
range of cells, click the first cell and drag to the last cell.
|
|
|
17.
|
Excel is not
case-sensitive which means that B3 and b3 both refer to the same cell.
|
|
|
18.
|
All Excel
formulas begin with an asterisk (*).
|
|
|
19.
|
Formulas are
used to perform calculations, such as addition, multiplication, and averaging.
|
|
|
20.
|
Using a
range name in a formula is known as range referencing.
|
|
|
21.
|
There is NO
order of precedence in Excel formulas.
|
|
|
22.
|
Addition and
subtraction are first in the order of precedence in Excel formulas.
|
|
|
23.
|
An Excel
formula can include several operations; for example, multiplication and addition.
|
|
|
24.
|
All Excel
functions begin with a question mark (?).
|
|
|
25.
|
Like
formulas, functions always begin with the formula prefix =.
|
|
|
26.
|
Functions
are predefined worksheet formulas that can be used in calculations.
|
|
|
27.
|
You can
enter functions in a worksheet manually, or you can use the Insert Function button.
|
|
|
28.
|
A value can
serve as a function argument.
|
|
|
29.
|
A range of
cells can serve as a function argument.
|
|
|
30.
|
In the
formula, =SUM(B3:D3), the (B3:D3) is the argument.
|
|
|
31.
|
SUM and
AVERAGE are examples of arguments.
|
|
|
32.
|
You can use
the Cut, Copy, and Paste buttons or Excel's drag-and-drop feature to copy or move information from
one cell or range in a worksheet to another.
|
|
|
33.
|
Parentheses are used to separate tasks within a complex equation.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
34.
|
The desired
results of a worksheet are sometimes called its ____. a. | Output | b. | Input | c. | Text | d. | Label | | |
|
|
|
35.
|
Information
gathered for a worksheet is sometimes referred to as ____. a. | Output | b. | Input | c. | Text | d. | Label | | |
|
|
|
36.
|
When
creating a worksheet, enter the ____ first to establish the structure of the
worksheet. a. | Values | b. | Data | c. | Labels | d. | None of the above | | |
|
|
|
37.
|
After
entering labels into a worksheet, enter data, or ____, used in calculations. a. | Text | b. | Values | c. | Formulas | d. | None of the above | | |
|
|
|
38.
|
Before
entering data into a worksheet, determine its ____. a. | Purpose | b. | Results | c. | Output | d. | All of the above | | |
|
|
|
39.
|
Which of the
following values would be considered a complex formula? a. | =B3+C9*D12 | b. | =B3 | c. | =B3+C9 | d. | All of the above | | |
|
|
|
40.
|
To change
the contents of a cell, put Excel into ____ mode. a. | Edit | b. | Formula | c. | Status | d. | Select | | |
|
|
|
41.
|
Clicking the
Cancel button on the formula bar before accepting the cell entry allows you to ____. a. | Move forward one
cell | b. | Go to the end of the
workbook | c. | Keep the current contents of the cell | d. | Delete a
row | | |
|
|
|
42.
|
If you want
to modify a cell entry after it has been confirmed, select the Undo button on the
____. a. | Menu
bar | b. | Formatting
toolbar | c. | Standard toolbar | d. | None of the
above | | |
|
|
|
43.
|
To put Excel
into Edit mode, select the cell you want to edit, then ____. a. | Click the formula
bar | b. | Double-click the
selected cell | c. | Press [F2] | d. | All of the above | | |
|
|
|
44.
|
To select a
range of cells, click the first cell and ____ to the last cell you want to include. a. | Paste | b. | Drag | c. | Copy | d. | None of the above | | |
|
|
|
45.
|
B6:C6 is an
example of a(n) ____. a. | Label | b. | Insertion point | c. | Range | d. | Formula | | |
|
|
|
46.
|
Any group of
two or more cells is called a ____. a. | Range | b. | Pair | c. | Worksheet | d. | None of the above | | |
|
|
|
47.
|
Excel
recognizes the entry, =B4/B2*C4, as a ____. a. | Label | b. | Value | c. | Formula | d. | Function | | |
|
|
|
48.
|
All Excel
formulas begin with ____.
|
|
|
49.
|
Using a
range name in a formula is known as ____. a. | Range referencing | b. | Value
referencing | c. | Formula referencing | d. | Cell
referencing | | |
|
|
|
50.
|
The correct
formula to multiply cell D5 by cell B2 is ____. a. | B2*D5 | b. | =D5*B2 | c. | D5*B2 | d. | (D5*B2) | | |
|
|
|
51.
|
In the
calculation =1200/23-600+75*45, which mathematical operation is performed first? a. | Subtraction | b. | Multiplication | c. | Division | d. | Addition | | |
|
|
|
52.
|
Which
operation is performed last in a calculation? a. | Exponentiation | b. | Subtraction | c. | Division | d. | Multiplication | | |
|
|
|
53.
|
The order of
precedence in Excel formulas can be changed by using ____. a. | Quotation
marks | b. | Parentheses | c. | Colons | d. | Question marks | | |
|
|
|
54.
|
In the
calculation =8+.98/3500*9, which operation is performed first? a. | Division | b. | Multiplication | c. | Addition | d. | Subtraction | | |
|
|
|
55.
|
In the
calculation =8+.98/3500*9, which operation is performed second? a. | Division | b. | Multiplication | c. | Addition | d. | Subtraction | | |
|
|
|
56.
|
All Excel
functions begin with the ____ symbol.
|
|
|
57.
|
The
information in the parentheses in =MAX(A1:F5) is an example of a(n) ____. a. | Argument | b. | Function wizard | c. | Prefix | d. | Cell reference | | |
|
|
|
58.
|
SUM and
AVERAGE are examples of ____. a. | Buttons | b. | Toggles | c. | Functions | d. | Arguments | | |
|
|
|
59.
|
A cell
containing =SUM(D1:D4) is recognized as a ____. a. | Function | b. | Formula | c. | Label | d. | Value | | |
|
|
|
60.
|
$A$1 is an
example of a(n) ____. a. | Formula | b. | Absolute cell reference | c. | Calculation | d. | None of the above | | |
|
|
|
61.
|
Which method
can be used to copy information? a. | Copy and Paste buttons | b. | Drag-and-drop | c. | Both a and b | d. | All of the
above | | |
|
|
|
|
|
|
62.
|
In the
figure above, item 1 points to the ____ which allows you to move rapidly among
worksheets. a. | Mode
indicator | b. | Sheet tabs scrolling buttons | c. | Scroll
bar | d. | Undo
button | | |
|
|
|
|
|
|
63.
|
In the
figure above, "Summer 2003 MediaLoft Author Events Forecast" is an example of
____. a. | Output | b. | A value | c. | Calculations | d. | A
label | | |
|
|
|
64.
|
In the
figure above, item 1 is pointing to worksheet ____. a. | Labels | b. | Values | c. | Formulas | d. | None of the above | | |
|
|
|
65.
|
In the
figure above, item 2 is pointing to worksheet ____. a. | Values | b. | Calculations | c. | Labels | d. | Products | | |
|
|
|
|
|
|
66.
|
In the
figure above, item 3 points to the ____. a. | Name box | b. | Worksheet title | c. | Program
title | d. | Title bar | | |
|
|
|
67.
|
In the
figure above, to enter a formula in the formula bar, you would click the item labeled
____. a. | 1 | b. | 3 | c. | 4 | d. | None of the above | | |
|
Completion
Complete each sentence or
statement.
|
|
|
|
|
|
68.
|
In the
figure above, item 4 is on the ____________________ bar.
|
|
|
69.
|
All
worksheet entries are either labels or ____________________.
|
|
|
70.
|
Information
that is collected to be entered in a worksheet is called ____________________.
|
|
|
71.
|
____________________ are the numbers used in calculations.
|
|
|
72.
|
____________________ establish the structure of a worksheet.
|
|
|
73.
|
To make sure
you are in Edit mode, check the mode indicator on the far left of the ____________________
bar.
|
|
|
74.
|
To change
the contents of a cell, put Excel into ____________________ mode.
|
|
|
75.
|
If you make
a mistake when entering data in a cell, you can click the ____________________ button on the formula
bar before accepting the cell entry.
|
|
|
76.
|
To select a
range of cells, ____________________ the first cell and drag to the last cell.
|
|
|
77.
|
A group of
two or more cells is called a(n) ____________________.
|
|
|
78.
|
All formulas
use arithmetic ____________________ to perform calculations.
|
|
|
79.
|
____________________ are used to perform numeric calculations, such as adding,
multiplying, and averaging.
|
|
|
80.
|
All Excel
formulas start with the prefix ____________________.
|
|
|
81.
|
Using a
range name or cell address in a formula is called cell ____________________.
|
|
|
82.
|
The sequence
of performed calculations is called the order of ____________________.
|
|
|
83.
|
The order of
precedence can be changed by using ____________________.
|
|
|
84.
|
The Insert
Function button is located on the ____________________ toolbar.
|
|
|
85.
|
____________________ are predefined formulas that enable you to do complex
calculations easily.
|
|
|
86.
|
A(n)
____________________ is the information inside the parentheses of a function.
|
|
|
87.
|
You can
enter functions manually, or you can use the ____________________ Function button.
|
|
|
88.
|
Using the
Cut, Copy, and ____________________ buttons, you can copy or move information from one cell to
another.
|
|
|
89.
|
A temporary
storage file that holds copied or cut information is called the Office
____________________.
|
|
|
90.
|
To copy and
move formulas, you can use the Copy and Paste commands, as well as the drag-and-____________________
technique.
|
|
|
91.
|
The Copy and
Paste buttons are on the ____________________ toolbar.
|
|
|
92.
|
You identify
an absolute cell reference by placing a ____________________ before the column letter and row number
of the address.
|
|
|
93.
|
A(n)
____________________ cell reference is a cell reference that always refers to a specific cell
address.
|
|
|
|
|
|
94.
|
In the
figure above, item 4 points to the ____________________ Function button on the Formula
toolbar.
|
|
|
95.
|
A(n)
____________________ formula uses more than one type of arithmetic operator.
|
|
|
|
|
|
96.
|
In the
figure above, item 3 shows data in the range B ____________________: D16.
|
|
|
97.
|
In the
figure above, item 1 indicates that the worksheet is in ____________________ mode.
|