Parts Of Function Formulas
Mathematical Formulas
Statistical Functions
Logic/Financial Functions
Misc.
100
Name the 3 components of a function formula.
What is equal sign, function name, and argument?
100
The number of arguments needed for a rounding function.
What is 2 arguments?
100
Statistical functions are used to describe large quantities of this.
What is data?
100
These are used to analyze loans and investments.
What is Financial functions?
100
There are this many ways to enter a function formula in a worksheet.
What is two ways?
200
This is the value, cell reference, range or text that acts as an operand in a function formula.
What is argument?
200
Mathematical functions manipulate this kind of data.
What is quantitative?
200
You would use the formula AVERAGE(number1,number2...) to find this.
What is to find the average of 2 numbers?
200
These use the word such as If.
What is logical functions?
200
When entering a range of cells you enclose the range in a set of these.
What is parenthesis?
300
When you click the autosum button this appears in a cell.
What is an equal sign followed by the word SUM?
300
Name two out of the three Mathematical functions listed in the book.
What is Square root, Round, and Logarithm?
300
In order to find the number of cells with numerical values you would use this function.
What is the count function?
300
A teacher may use a logical formula for this.
What is determine if a student is passing or failing?
300
Function formulas do not use this to calculate results.
What is an operator?
400
In order to enter a formula into a cell you must first key this.
What is an equal sign?
400
Mathematical functions are useful when you need to determine values such as these.
What is logarithms, factorials, sines, cosines, tangents, or absolute value?
400
All statistical functions contain this for the argument.
What is a range of cells?
400
The second argument in the determines this.
What is determine if the logical test is true?
400
These functions can be used to find cell contents or cell locations.
What is lookup and reference functions?
500
The quickest way to enter a range into a formula.
What is by dragging?
500
These mathematical formulas do not require function formulas.
What is addition, subtraction, multiplication and division?
500
These 5 letters are used to represent Standard Deviation of the numbers contained in a range in a function formula.
What is STDEV?
500
Name one of the primary financial functions.
What is future value, present value, or payment?
500
Excel has this many function formulas.
What is more then 300?
M
e
n
u