Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
What
is a Header Row in a data file? a. | A group of aligned soccer
players | c. | The top row of a
data table which describes each column | b. | The first row of variable data | d. | An italian bedframe | | | | |
|
|
|
2.
|
Where
do enter data or labels that you want repeated on each page of a worksheet that you
print? a. | The top
row | c. | In the middle of
the worksheet | b. | In a header or footer | d. | At the end of the worksheet | | | | |
|
|
|
3.
|
Before you actually print a large worksheet, you should... a. | cross your
fingers | c. | print
preview | b. | save the worksheet | d. | check for hanging freeze-ups | | | | |
|
|
|
4.
|
The
correct syntax for calculating the minimum value of cells in column A should be... a. | minimum(A1:A3) | c. | min(A1-A3) | b. | =min(A1:A3) | d. | =minimum(A1-A3) | | | | |
|
|
|
5.
|
The
correct syntax for calculating the maximum value in a column would be... a. | =maximum(B1:B4) | c. | =max(B1:B5) | b. | =max(B1:F1) | d. | max(B1:B5) | | | | |
|
|
|
6.
|
If a
cell contained the value 0.75 and you formatted to display as a percentage, it would appear
as... a. | .75% | c. | 75.00% | b. | .0075% | d. | 7.50% | | | | |
|
|
|
7.
|
What
formatting would you use to change the color of a specific cell based on the value of that
cell? a. | color
formatting | c. | if else
formatting | b. | conditional formatting | d. | greater than less than formatting | | | | |
|