WorksheetsExcel Chapter 2
Total questions: 10
Worksheet time: 5mins
A _____ is a prewritten formula that is built into Excel.
function
feature
task
calculation
All of the following are valid Excel arithmetic operators except _____.
^
*
%
>
When Excel follows the order of operations, the formula, 8* 3 + 2, equals _____.
40
26
48
13
The adjusted cell references in a copied and pasted formula are called _____ references.
related
relative
pasted
alternative
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto Fill Options
AutoCorrect Options
Insert Options
Paste Options
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
MIN
SUM
AVERAGE
MAX
You should _____ a function name in the Formula AutoComplete list to select the function.
double-click
click
right-click
none of the above
The _____ function displays the highest value in a range.
MIN
SUM
MAX
AVERAGE
The _____ function determines the lowest number in a range.
MAX
AVERAGE
SUM
MIN
When you decrease the row height to _____, the row is hidden.
0
1
2
3
