SCTE Exam Questions and Correct
Answers
#DIV/0! - Answer-The formula or function contains a number divided by 0
#NAME? - Answer-Excel doesn't recognize text in the formula or function, such as when the function
name is misspelled
#N/A - Answer-A value is not available to a function or formula, which can occur when a workbook is
initially set up prior to entering actual data values
#NUM! - Answer-Invalid numbers are used in a formula or function, such as text entered in a function
that requires a number
#REF! - Answer-A cell reference used in a formula or function is no longer valid, which can occur when
the cell used by the function was deleted from the worksheet
#VALUE! - Answer-The wrong type of argument is used in a function or formula. This can occur when
you reference a text value for an argument that should be strictly numeric
###### - Answer-The formula entered into the cell produces a result that is wider than the cell
,Sequence in which operators are applied in a calculation - Answer-order of operations
order of operations - Answer-1. Calculate any operations within parenthesis
2. Calculate an exponentiations
3. Calculate an multiplications
4. Calculate any divisions
5. Calculate any additions
6. Calculate any subtractions
adds the values in a collection of numbers - Answer-SUM
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
calculates the average of a collection of numbers - Answer-AVERAGE
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
used to determine the total count of numeric values in the specified range - Answer-COUNT
arguments- value1, value2, etc. - Answer-rep. numbers, range reference, or cell references
Counts how many cells are not empty in ranges including both numbers and text entries - Answer-
COUNTA
arguments- value1, value2, etc. - Answer-rep. range selected
, determines smallest value in specified range - Answer-MIN
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
determines largest value in specified range - Answer-MAX
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
Rounds number to the number of digits specified (only numbers 1-5 rounded down?) - Answer-ROUND
arguments- number and num_digits - Answer-rep. number you're rounding and num_digits rep.
number of digits you're rounding to
Rounds all numbers down to 0, to the number of digits specified - Answer-ROUNDDOWN
arguments- number and number_digits - Answer-number-rep. number you're rounding and num_digits
rep. number of digits you're rounding to
Returns the most frequently occurring number in a numeric data set - Answer-MODE.SNGL
arguments- number1, number2, etc. - Answer-rep. a number or cell reference
Calculates the median, or middle, value of a collection of numbers - Answer-MEDIAN
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
Answers
#DIV/0! - Answer-The formula or function contains a number divided by 0
#NAME? - Answer-Excel doesn't recognize text in the formula or function, such as when the function
name is misspelled
#N/A - Answer-A value is not available to a function or formula, which can occur when a workbook is
initially set up prior to entering actual data values
#NUM! - Answer-Invalid numbers are used in a formula or function, such as text entered in a function
that requires a number
#REF! - Answer-A cell reference used in a formula or function is no longer valid, which can occur when
the cell used by the function was deleted from the worksheet
#VALUE! - Answer-The wrong type of argument is used in a function or formula. This can occur when
you reference a text value for an argument that should be strictly numeric
###### - Answer-The formula entered into the cell produces a result that is wider than the cell
,Sequence in which operators are applied in a calculation - Answer-order of operations
order of operations - Answer-1. Calculate any operations within parenthesis
2. Calculate an exponentiations
3. Calculate an multiplications
4. Calculate any divisions
5. Calculate any additions
6. Calculate any subtractions
adds the values in a collection of numbers - Answer-SUM
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
calculates the average of a collection of numbers - Answer-AVERAGE
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
used to determine the total count of numeric values in the specified range - Answer-COUNT
arguments- value1, value2, etc. - Answer-rep. numbers, range reference, or cell references
Counts how many cells are not empty in ranges including both numbers and text entries - Answer-
COUNTA
arguments- value1, value2, etc. - Answer-rep. range selected
, determines smallest value in specified range - Answer-MIN
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
determines largest value in specified range - Answer-MAX
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
Rounds number to the number of digits specified (only numbers 1-5 rounded down?) - Answer-ROUND
arguments- number and num_digits - Answer-rep. number you're rounding and num_digits rep.
number of digits you're rounding to
Rounds all numbers down to 0, to the number of digits specified - Answer-ROUNDDOWN
arguments- number and number_digits - Answer-number-rep. number you're rounding and num_digits
rep. number of digits you're rounding to
Returns the most frequently occurring number in a numeric data set - Answer-MODE.SNGL
arguments- number1, number2, etc. - Answer-rep. a number or cell reference
Calculates the median, or middle, value of a collection of numbers - Answer-MEDIAN
arguments- number1, number2, etc. - Answer-rep. numbers or cell references
