NEW
Font size
WorksheetsExcel Functions and Formulas
Total questions: 14
Worksheet time: 28mins
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 function 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 function 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 function 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.
Excel will display _______________________ if the cell is not wide enough.
******
^^^^^
######
>>>>>
What is the syntax for the sum function in excel that sums a range from B1 to E1?
Sum(B1:E1)
Sum( B1:E1)=
=( B1:E1)Sum
=Sum(B1:E1)
For multiplying numbers in A1 AND B1,you use the following formula
=A1/B1
=A1*B1
A1%B1
A1*B1
Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is
=A4+B5
=A3+B4
=B4+B5
=B3+C4
How would you write a cell reference formula for cell A1 subtracted from Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
A _________ is a prewritten formula that is built into EXCEL.
function
problem
equation
equal sign
Which of these symbols is used to do a division on a computer?
\
*
/
|
Answer =3+5*(6-2)
23
32
31
64
