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 | | |
|
|
|