NEW
Font size
WorksheetsExcel - Formulas, Functions & Formatting
Total questions: 20
Worksheet time: 20mins
What does the Average formula return?
Returns the lowest argument.
Returns the middle argument.
Returns the three highest arguments.
Returns the mean of all its arguments.
What does the Max formula do?
Returns the highest three values in a set of values and ignores text.
Returns the largest value in a set of values and ignores text.
Returns the text that you are searching for.
Returns the smallest value in a set of values and ignores text.
What does the Min formula return?
Returns the smallest three numbers form a set and ignores text.
Returns the smallest value in a set of values and ignores text.
Returns the largest three numbers form a set and ignores text.
Returns the largest value in a set of values and ignores text.
What does the Countif formula return?
Counts the number of cells within a range that meets the given condition.
Counts the number of words within a range that meets the given condition.
Counts the number of columns within a range that meets the given condition.
Counts the number of letters within a range that meets the given condition.
Which operator is used to multiply in Excel?
+
-
/
*
All formulas begin with a(n) _______________.
&
=
+
#
Excel will display _______________________ if the cell is not wide enough.
******
^^^^^
######
>>>>>
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
To edit a formula you
Double-click the cell
Click in the formula bar
Press Esc
Both A & B
Answer =2+3*3-2
9
10
11
12
Answer =3+5*(6-2)
23
32
31
64
__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.
Formula
Calculation
Cell address
None of the above
There are two types of references.
Relative and Dependent
Relative and Proportionate
Absolute and Dominant
Relative and Absolute
A predefined formula that performs calculations using specific values in a particular order.
Function
Reference
Chart
Multiple arguments must be separated by a ______________.
Space
Comma
= Sign
!
