BUS 1350 – Final Exam, Erica Ancira, Baylor University, 2026 – Comprehensive study and practice guide

BUS 1350 – Final Exam, Erica Ancira, Baylor University, 2026 – Comprehensive
study and practice guide


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



What is the TODAY function? - correct answer ✔✔ Returns the computer system date