Excel Formulas & Functions
Questions with Correct Answers
Excel - ANSWERSA Microsoft application that allows the user to create spreadsheets
which are mathematical in nature and include formulas to automatically calculate
answers; also creates charts.
Formula - ANSWERSMust always start with "=".
Function - ANSWERSA prewritten formula that makes it easy to perform common
calculations especially when they involve too many cells to list separately.
Sum Function - ANSWERSAn Excel function that adds all the numbers in a selected
range of cells.
Average Function - ANSWERSAn Excel function that adds a group of values, and then
divides the result by the number of values in the group.
Count Function - ANSWERSAn Excel function used to provide a count of the number of
cells containing numerical values within the selected range of cells. This function
ignores any text values contained in the selected range of cells.
100 - ANSWERSAnswer to following function if the value in cell B5 contains a 10 and
the answer in cell C5 contains a 20; =IF(B5<C5, 100, 200)
200 - ANSWERSAnswer to following function if the value in cell B5 contains a 10 and
the answer in cell C5 contains a 20; =IF(B5>C5, 100, 200)
If...Then Function - ANSWERSConditional statement in Excel that performs one action
or value if the condition is true and a different action or value if the condition is false.
( ) - Parenthesis - ANSWERSSymbol required at the start and finish when writing
functions in Excel.
Max Function - ANSWERSAn Excel function that displays the highest value in a range.
Min Function - ANSWERSAn Excel function that displays the lowest value in a range.
Relative Cell Reference - ANSWERSThe default cell reference where the cell
references in a formula or function will change to reflect the new location when moved
or copied.
Questions with Correct Answers
Excel - ANSWERSA Microsoft application that allows the user to create spreadsheets
which are mathematical in nature and include formulas to automatically calculate
answers; also creates charts.
Formula - ANSWERSMust always start with "=".
Function - ANSWERSA prewritten formula that makes it easy to perform common
calculations especially when they involve too many cells to list separately.
Sum Function - ANSWERSAn Excel function that adds all the numbers in a selected
range of cells.
Average Function - ANSWERSAn Excel function that adds a group of values, and then
divides the result by the number of values in the group.
Count Function - ANSWERSAn Excel function used to provide a count of the number of
cells containing numerical values within the selected range of cells. This function
ignores any text values contained in the selected range of cells.
100 - ANSWERSAnswer to following function if the value in cell B5 contains a 10 and
the answer in cell C5 contains a 20; =IF(B5<C5, 100, 200)
200 - ANSWERSAnswer to following function if the value in cell B5 contains a 10 and
the answer in cell C5 contains a 20; =IF(B5>C5, 100, 200)
If...Then Function - ANSWERSConditional statement in Excel that performs one action
or value if the condition is true and a different action or value if the condition is false.
( ) - Parenthesis - ANSWERSSymbol required at the start and finish when writing
functions in Excel.
Max Function - ANSWERSAn Excel function that displays the highest value in a range.
Min Function - ANSWERSAn Excel function that displays the lowest value in a range.
Relative Cell Reference - ANSWERSThe default cell reference where the cell
references in a formula or function will change to reflect the new location when moved
or copied.
