Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
In
Excel, if you hold down the End key and hit the up arrow, what cell is selected? a. | The topmost
non-blank cell | c. | Cell
A1 | b. | the next cell
up | d. | A cell in row
1 | | | | |
|
|
|
2.
|
Which
cell is highlighted in Excel if you hold down the control key and press the home
button? a. | The uppermost
non-blank cell | c. | A cell in Row
1 | b. | Cell
A1 | d. | The next cell
up | | | | |
|
|
|
3.
|
How
would you navigate to the bottom of your worksheet in Excel? a. | Ctrl-down
arrow | c. | Ctrl-Down
twice | b. | Ctrl-End | d. | Press the down arrow as many times as it
takes. | | | | |
|
|
|
4.
|
What
is true about workbooks and worksheets? a. | They are the same thing | c. | Workbooks are contained within
worksheets | b. | Worksheets are contained within
workbooks | d. | Workbooks can
exist without worksheets | | | | |
|
|
|
5.
|
What
character always begin a formula in Excel?
|
|
|
6.
|
If
you wanted to add Cells A1, A2, A3, A4 and A5, what would be the best formula to do
that? a. | sum(A1:A5) | c. | =sum(a1:a5) | b. | =Add(A1+A2+A3+A4+A5) | d. | =a1+a2+a3+a4+a5 | | | | |
|
|
|
7.
|
If
you wanted to find the minimum value in cells a1,a2,a3,a4 and a5 in Excel, what would the formula
be? a. | =minimum(a1,a2,a3,a4,a5) | c. | =min(a1:a5) | b. | =min(a1,a3,a5) | d. | =min(sum(a1:a5)) | | | | |
|
|
|
8.
|
If
you wanted to find the average of cells a1, b1 and c1, what is the easiest formula for accomplishing
this? a. | =a1+a2+a3/3 | c. | =avg(a1:c1) | b. | =sum(a1:a3)/3 | d. | =average(a1:c1) | | | | |
|
|
|
9.
|
What
does the  key do in Excel? a. | Autocorrect | c. | Autoadd | b. | Autosum | d. | AutoSelect | | | | |
|