BAYLOR BUS 1350 ERICA ANCIRA
FINAL EXAM QUESTIONS & EXACT
CORRECT ANSWERS
What is an array formula? - Correct Answer ✔✔ A formula that can return a single result
or multiple results
What is spilling? - Correct Answer ✔✔ When the formula entered results in multiple
values and the values are returned to neighboring cells
When is using a named range not a good idea? - Correct Answer ✔✔ If you need a
formula to copy across a range of cells with the references remaining relative
When is using a named range a good idea? - Correct Answer ✔✔ When sets of data
are used in multiple formulas or when other users need to understand the construction
of the spreadsheet
What is a syntax? - Correct Answer ✔✔ The structure and order of the function and the
arguments
What is the ABS function? - Correct Answer ✔✔ Returns the absolute value of the
number analyzed by the function
What is the INT function? - Correct Answer ✔✔ Rounds down any decimal values
associated with a number to the nearest whole integer
What is the ROUND function? - Correct Answer ✔✔ Rounds a number to a specified
number of digits
What is the RAND function? - Correct Answer ✔✔ Returns a random number from 0 to
less than 1
What is the RANDBETWEEN function? - Correct Answer ✔✔ Returns a random integer
between the numbers you specify
What is the ROUNDDOWN function? - Correct Answer ✔✔ Rounds a number down to
a specified number of digits
What is the ROUNDUP function? - Correct Answer ✔✔ Rounds a number up to a
specified number of digits
, What is the AVERAGE function? - Correct Answer ✔✔ Returns the average from a set
of numbers
What is the COUNT function? - Correct Answer ✔✔ Counts the number of cells in a
range that contain numbers
What is the COUTNA function? - Correct Answer ✔✔ Counts the number of cells in a
range that are not empty
What is the COUNTBLANK function? - Correct Answer ✔✔ Counts the number of
empty cells in a range
What is the MEDIAN function? - Correct Answer ✔✔ Returns the number in the middle
of a set of numbers
What is the MAX function? - Correct Answer ✔✔ Returns the largest number from a set
of numbers
What is the MIN function? - Correct Answer ✔✔ Returns the smallest number from a set
of numbers
What is the MODE.SNGL function? - Correct Answer ✔✔ Returns the value that occurs
most often within a set
Why is the COUNTA function useful? - Correct Answer ✔✔ Great method for counting
the number of records in a data set that may include numbers and letters
What are date and time functions useful for? - Correct Answer ✔✔ Entering the current
day and time into a worksheet as well as for calculating the intervals between dates
What is the DATE function? - Correct Answer ✔✔ Returns the number that represents
the date in Excel date-time code
What is the DATEDIF function? - Correct Answer ✔✔ Returns the time unit specified
between two dates, including the two dates (inclusive)
What is the DAY function? - Correct Answer ✔✔ Returns the day of the month, a
number from 1 to 31
What is the MONTH function? - Correct Answer ✔✔ Returns the month, a number from
1 to 12
What is the NETWORKDAYS function? - Correct Answer ✔✔ Returns the number of
whole workdays between tow dates, inclusive; does not count weekends and can skip
holidays that are listed
FINAL EXAM QUESTIONS & EXACT
CORRECT ANSWERS
What is an array formula? - Correct Answer ✔✔ A formula that can return a single result
or multiple results
What is spilling? - Correct Answer ✔✔ When the formula entered results in multiple
values and the values are returned to neighboring cells
When is using a named range not a good idea? - Correct Answer ✔✔ If you need a
formula to copy across a range of cells with the references remaining relative
When is using a named range a good idea? - Correct Answer ✔✔ When sets of data
are used in multiple formulas or when other users need to understand the construction
of the spreadsheet
What is a syntax? - Correct Answer ✔✔ The structure and order of the function and the
arguments
What is the ABS function? - Correct Answer ✔✔ Returns the absolute value of the
number analyzed by the function
What is the INT function? - Correct Answer ✔✔ Rounds down any decimal values
associated with a number to the nearest whole integer
What is the ROUND function? - Correct Answer ✔✔ Rounds a number to a specified
number of digits
What is the RAND function? - Correct Answer ✔✔ Returns a random number from 0 to
less than 1
What is the RANDBETWEEN function? - Correct Answer ✔✔ Returns a random integer
between the numbers you specify
What is the ROUNDDOWN function? - Correct Answer ✔✔ Rounds a number down to
a specified number of digits
What is the ROUNDUP function? - Correct Answer ✔✔ Rounds a number up to a
specified number of digits
, What is the AVERAGE function? - Correct Answer ✔✔ Returns the average from a set
of numbers
What is the COUNT function? - Correct Answer ✔✔ Counts the number of cells in a
range that contain numbers
What is the COUTNA function? - Correct Answer ✔✔ Counts the number of cells in a
range that are not empty
What is the COUNTBLANK function? - Correct Answer ✔✔ Counts the number of
empty cells in a range
What is the MEDIAN function? - Correct Answer ✔✔ Returns the number in the middle
of a set of numbers
What is the MAX function? - Correct Answer ✔✔ Returns the largest number from a set
of numbers
What is the MIN function? - Correct Answer ✔✔ Returns the smallest number from a set
of numbers
What is the MODE.SNGL function? - Correct Answer ✔✔ Returns the value that occurs
most often within a set
Why is the COUNTA function useful? - Correct Answer ✔✔ Great method for counting
the number of records in a data set that may include numbers and letters
What are date and time functions useful for? - Correct Answer ✔✔ Entering the current
day and time into a worksheet as well as for calculating the intervals between dates
What is the DATE function? - Correct Answer ✔✔ Returns the number that represents
the date in Excel date-time code
What is the DATEDIF function? - Correct Answer ✔✔ Returns the time unit specified
between two dates, including the two dates (inclusive)
What is the DAY function? - Correct Answer ✔✔ Returns the day of the month, a
number from 1 to 31
What is the MONTH function? - Correct Answer ✔✔ Returns the month, a number from
1 to 12
What is the NETWORKDAYS function? - Correct Answer ✔✔ Returns the number of
whole workdays between tow dates, inclusive; does not count weekends and can skip
holidays that are listed
