NEW
Font size
WorksheetsFunction in Excel
Total questions: 10
Worksheet time: 3mins
To see the result of the applied formula, press _________ key.
Shift
Ctrl
Enter
#REF error occurs when
you divide by zero
cell reference is not valid
when there is no value
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
&
#
=
*
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
%
$
&
#
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
What function was used to find the lowest grade?
average
sum
min
max
All formulas used within the table are seen on the __________
cells
cell reference
name box
formula bar
