Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
Which
type of cell reference does not change when it is moved or copied to a new cell? a. | relative | c. | mixed | b. | stable | d. | absolute | | | | |
|
|
|
2.
|
The
____ function displays the number of cells with numerical values in the argument
range. a. | COUNT | c. | MAX | b. | VAR | d. | AVERAGE | | | | |
|
|
|
3.
|
Which
calculation will be performed first in a formula that does not contain parentheses? a. | multiplication | c. | exponentiation | b. | subtraction | d. | addition | | | | |
|
|
|
4.
|
What
is the intersection of a worksheet column and a row called? a. | highlight | c. | cell | b. | range | d. | name box | | | | |
|
|
|
5.
|
Which
operator represents exponentiation?
|
|
|
6.
|
Suppose that the value in B3 is equal to 3 and the value in C3 is 4. Which formula
would display the value of 24? a. | =(B3*C3+4) | c. | =(B3*C3)+4 | b. | =B3*(C3+4) | d. | =B3*C3+4 | | | | |
|
|
|
7.
|
What
happens if data are copied in cells that have existing data? a. | An error message
will appear. | b. | Old data will be replaced by new
data. | c. | New data will not be copied. | d. | Old data will be
placed on the Clipboard. | | |
|
|
|
8.
|
Which
function determines the payment needed each period to repay a loan?
|
|
|
9.
|
What
is a collection of worksheets called? a. | notebook | c. | workbook | b. | spreadsheet | d. | work
area | | | | |
|
|
|
10.
|
The
drag-and-drop method is the same for moving data as it is for copying data except that you do not
hold down the ____ key. a. | Insert | c. | Ctrl | b. | Shift | d. | Alt | | | | |
|
|
|
11.
|
Suppose that the value in B3 is equal to 12 and the value in C3 is 3. Which
formula would display the value of 3? a. | =B3/(C3+1) | c. | =(B3/C3+1) | b. | =B3/C3+1 | d. | =(B3/C3)+1 | | | | |
|
|
|
12.
|
Which
chart type shows values in what’s referred to as “slices?” a. | doughnut | c. | column | b. | scatter | d. | pie | | | | |
|
|
|
13.
|
Data
stored on the ____ will remain until it is replaced with new data. a. | formula
bar | c. | Clipboard | b. | border | d. | toolbar | | | | |
|
|
|
14.
|
What
is the purpose of the COUNT function? a. | It determines the number of filled cells in a
range. | b. | It determines the number of columns in a
range. | c. | It determines the number of cells in a
range. | d. | It determines the number of empty cells in a
range. | | |
|
|
|
15.
|
To
edit data in a cell, select the cell and press the ____ key, referred to as the Edit
key.
|
Completion
Complete each sentence or
statement.
|
|
|
16.
|
A
graphical representation of data contained in a worksheet is referred to as a(n)
____________________.
|
|
|
17.
|
A(n)
____________________ is a list that identifies patterns or symbols used in a chart.
|
|
|
18.
|
To
create a new spreadsheet file, click the ____________________ button on the Standard
toolbar.
|
|
|
19.
|
The
____________________ command removes data from its original place on the worksheet and places it on
the Clipboard.
|
|
|
20.
|
As a
default, Excel will name a chart saved on a sheet as ____________________.
|
Matching
|
|
|
Assume C3 contains the value of 5, C4 the value of 7, and C5 the value of 9. Match
the following functions with the value the function would display below. a. | =SUM(C3:C5) | b. | =COUNT(C3:C5) | c. | =MAX(C3:C5) | d. | =MIN(C3:C5) | e. | =AVERAGE(C3:C5) | | |
|
|
|
21.
|
3
|
|
|
22.
|
7
|
|
|
23.
|
9
|
|
|
24.
|
21
|
|
|
25.
|
5
|
|
|
Match the format name with the display description below. a. | General | b. | Scientific | c. | Text | d. | Number | e. | Special | | |
|
|
|
26.
|
Displays either text or numerical data as keyed.
|
|
|
27.
|
Displays numerical data that requires a specific format.
|
|
|
28.
|
Displays numerical data with a fixed number of places to the right of the decimal
point.
|
|
|
29.
|
Displays numerical data in exponential notation.
|
|
|
30.
|
Displays numerical data that will not be used for calculation.
|
|
|
Match the following chart names with its description below.
|
|
|
31.
|
uses
points on a grid
|
|
|
32.
|
shows
the relationship of parts to a whole
|
|
|
33.
|
uses
segments connected by points to illustrate the values in a worksheet
|
|
|
34.
|
uses
rectangles of varying heights to illustrate the values in a worksheet
|
True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
35.
|
Data
that is copied is stored on the Clipboard until it is pasted or until you copy something
else.
|
|
|
36.
|
With
the point-and-click method of cell referencing, you click the cell instead of keying a cell
address.
|
|
|
37.
|
The
Merge and Center alignment button is commonly used to center a title across the top of a
worksheet.
|
|
|
38.
|
You
can widen a column by using the Column Width dialog box.
|
|
|
39.
|
The
formula bar appears directly above the toolbar in the worksheet.
|
|
|
40.
|
If
you want to move the cursor to cell A1, press Ctrl+Home on your keyboard.
|
|
|
41.
|
You
can use the DATE function to display dates in many different formats.
|
|
|
42.
|
When
creating a new chart sheet, you must first cut and paste the data that is to be included in the
chart.
|
|
|
43.
|
Rotating will move text from the right side of the cell to the left side of the
cell.
|
|
|
44.
|
You
must enter an ampersand (&) as the first character in a function formula so that Excel will
recognize it as a formula.
|
|
|
45.
|
The
AutoSum feature may be used to add a long column of numbers.
|
|
|
46.
|
You
would use a column chart to show the relationship of parts to a whole.
|
|
|
47.
|
Once
you have keyed a formula, you can enter it by clicking the dollar sign ($) on the formula
bar.
|
|
|
48.
|
To
replace the contents of a cell, you must first select the cell and then key in the new
data.
|
|
|
49.
|
Formulas are recognized in a worksheet when a star sign (*) is the first character in
a cell.
|
|
|
50.
|
Wrapping will create a new line of text within a cell.
|