True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
A formula consists of two components: an operand and an operator.
|
|
|
2.
|
A + (plus sign) is an example of an operator.
|
|
|
3.
|
Computers evaluate and assess worksheet values.
|
|
|
4.
|
Generally, values are used in formulas rather than cell references.
|
|
|
5.
|
To create an absolute cell reference, you insert an equal sign (=) before the
column letter and/or row number of the cell reference you want to stay the same.
|
|
|
6.
|
AVERAGE is a statistical function.
|
|
|
7.
|
In a 3-D reference, length and width refer to the worksheet rows and
columns.
|
|
|
8.
|
Many parts of a chart are positioned on the chart in a text box.
|
|
|
9.
|
When you edit the data in a worksheet, you must edit the data in the chart as
well.
|
|
|
10.
|
Excel has more than 300 built-in formulas for performing calculations.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
All Excel formulas begin with ____.
|
|
|
12.
|
Formulas containing more than one operator are called ____.
a. | mixed cell references | c. | absolute cell references | b. | complex
formulas | d. | relative cell
references |
|
|
|
13.
|
The sequence used to calculate the value of a formula is called the ____.
a. | cell reference | c. | order of evaluation | b. | operand | d. | operator |
|
|
|
14.
|
The operator for performing multiplication is the ____.
a. | + (plus sign) | c. | - (minus sign) | b. | * (asterisk) | d. | / (forward
slash) |
|
|
|
15.
|
By default, when you create formulas, the cell references are formatted as
____.
a. | absolute cell references | c. | relative cell
references | b. | mixed cell references | d. | complex cell references |
|
|
|
16.
|
The formula =$A1 is an example of a(n) ____ cell reference.
a. | relative | c. | mixed | b. | absolute | d. | statistical |
|
|
|
17.
|
____ is a mathematical function.
|
|
|
18.
|
A(n) ____ is a special formula that names a function instead of using operators
to calculate a result.
a. | argument | c. | complex formula | b. | range | d. | function
formula |
|
|
|
19.
|
A ____ is used to separate cell references that are not adjacent.
a. | colon | c. | period | b. | comma | d. | asterisk |
|
|
|
20.
|
____ are often used in summary worksheets to condense and total data from other
worksheets.
a. | Mixed cell references | c. | 3-D references | b. | Absolute cell references | d. | Relative cell
references |
|
|
|
21.
|
A ____ is a graphic representation of your worksheet data.
a. | legend | c. | function | b. | formula | d. | chart |
|
|
|
22.
|
____ are computer programs that are so necessary or desirable that they prove
the core value of some larger technology, and as a result, they substantially increase the sales of
the platform that they run on.
a. | Windows | c. | Platform computers | b. | Killer apps | d. | Graphical User
Interfaces |
|
|
|
23.
|
A shortcut for entering cell references is to ____.
a. | enter all the cell references | c. | enter a formula | b. | name a range of
cells | d. | enter the function
name |
|
|
|
24.
|
Which of the following chart types does not have a horizontal and a vertical
axis?
|
|
|
25.
|
If you input an incorrect formula, or if you input invalid data, the formula
produces a false result--often referred to as ____.
a. | an error | c. | a killer app | b. | Garbage In, Garbage Out | d. | an argument |
|
|
|
26.
|
To resize a chart proportionally, drag a ____ handle.
a. | corner | c. | side | b. | top center | d. | bottom center |
|
|
|
27.
|
Which formula will produce a result of 48?
a. | =8+4*4 | c. | =(8+4)*4 | b. | =8*4+4 | d. | =8/4-4 |
|
|
|
28.
|
Which type of cell reference adjusts automatically when copied to another
cell?
a. | Relative | c. | Absolute | b. | Mixed | d. | Complex |
|
|
|
FIGURE 19-1 
|
|
|
29.
|
What is the arrow pointing to in Figure 19-1 above?
a. | Change Chart Type button | c. | Excel Help
button | b. | More button | d. | Error Checking button |
|
|
|
FIGURE 19-2 
|
|
|
30.
|
Which part of the function formula shown in Figure 19-2 above is the
argument?
a. | Equal sign (=) | c. | (B4:B8) | b. | SUM | d. | SUM(B4:B8) |
|
|
|
Case 19-1
Macy is the treasurer for a professional organization, and
she is compiling the financial data to present to the board members at the next meeting.
|
|
|
31.
|
Macy sees the error #NULL! in a cell of her worksheet. What is likely the
problem?
a. | The column is not wide enough | c. | The wrong type of argument or
operand is used | b. | Negative data is entered | d. | A space is used where it isn’t appropriate |
|
|
|
32.
|
Macy wants to show the organization’s total dollar amount of dues
collected in the cells B2 to B40. Which is the correct formula?
a. | =COUNT(B2:B40) | c. | =SUM(B2:B40) | b. | =SUM(B2,B40) | d. | =TOTAL(B2:B40) |
|
|
|
Case 19-2
Pablo works as an assistant at a local art gallery. He is
completing a worksheet that shows sales for the previous year. Now he wants to create a chart to
represent the data.
|
|
|
33.
|
Pablo wants to use only part of the data in a column chart. What should he do
first?
a. | Click the Column button | c. | Click the Insert
tab | b. | Select the data he wants to use in the chart | d. | Select all the data in the
worksheet |
|
|
|
34.
|
Pablo decides a bar chart would illustrate the data more effectively. Which
button will enable him to choose a new chart?
a. | Move Charts | c. | Data Labels | b. | Legend | d. | Change Chart
Type |
|
Matching
|
|
|
Identify the letter of the choice that best
matches the phrase or definition.
a. | SUM | b. | AVERAGE | c. | MIN | d. | MAX | e. | COUNT |
|
|
|
35.
|
Tallies the number of cells with values in the specified range.
|
|
|
36.
|
Shows the largest number contained in the range identified in the
argument.
|
|
|
37.
|
Calculates the average of the range identified in the argument.
|
|
|
38.
|
Adds the values in the specified range of cells.
|
|
|
39.
|
Shows the smallest number contained in the range identified in the
argument.
|