Baylor Bus 1350 Erica Ancira FINAL EXAM | UPDATED Questions with 100% Verified Answers

Baylor Bus 1350 Erica Ancira FINAL EXAM | UPDATED
Questions with 100% Verified Answers
Q1: What is an array formula?
A: A formula that can return a single result or multiple results


Q2: What is spilling?
A: When the formula entered results in multiple values and the values are returned to
neighboring cells


Q3: When is using a named range not a good idea?
A: If you need a formula to copy across a range of cells with the references remaining
relative


Q4: When is using a named range a good idea?
A: When sets of data are used in multiple formulas or when other users need to understand
the construction of the spreadsheet


Q5: What is a syntax?
A: The structure and order of the function and the arguments


Q6: What is the ABS function?
A: Returns the absolute value of the number analyzed by the function


Q7: What is the INT function?
A: Rounds down any decimal values associated with a number to the nearest whole integer


Q8: What is the ROUND function?
A: Rounds a number to a specified number of digits


Q9: What is the RAND function?
A: Returns a random number from 0 to less than 1


Q10: What is the RANDBETWEEN function?
A: Returns a random integer between the numbers you specify


Q11: What is the ROUNDDOWN function?
A: Rounds a number down to a specified number of digits

,Q12: What is the ROUNDUP function?
A: Rounds a number up to a specified number of digits


Q13: What is the AVERAGE function?
A: Returns the average from a set of numbers


Q14: What is the COUNT function?
A: Counts the number of cells in a range that contain numbers


Q15: What is the COUTNA function?
A: Counts the number of cells in a range that are not empty


Q16: What is the COUNTBLANK function?
A: Counts the number of empty cells in a range


Q17: What is the MEDIAN function?
A: Returns the number in the middle of a set of numbers


Q18: What is the MAX function?
A: Returns the largest number from a set of numbers


Q19: What is the MIN function?
A: Returns the smallest number from a set of numbers


Q20: What is the MODE.SNGL function?
A: Returns the value that occurs most often within a set


Q21: Why is the COUNTA function useful?
A: Great method for counting the number of records in a data set that may include numbers
and letters


Q22: What are date and time functions useful for?
A: Entering the current day and time into a worksheet as well as for calculating the intervals
between dates


Q23: What is the DATE function?
A: Returns the number that represents the date in Excel date-time code


Q24: What is the DATEDIF function?
A: Returns the time unit specified between two dates, including the two dates (inclusive)

, Q25: What is the DAY function?
A: Returns the day of the month, a number from 1 to 31


Q26: What is the MONTH function?
A: Returns the month, a number from 1 to 12


Q27: What is the NETWORKDAYS function?
A: Returns the number of whole workdays between tow dates, inclusive; does not count
weekends and can skip holidays that are listed


Q28: What is the TODAY function?
A: Returns the computer system date


Q29: What is the NOW function?
A: Returns the computer system date and time


Q30: What is the WEEKDAY function?
A: Returns a number from 1 to 7 representing the day of the week. Can be set to return 0-6
or 1-7


Q31: What is the WEEKNUM function?
A: Returns the week number in the year, which week of the year the date occurs


Q32: What is the YEAR function?
A: Returns the year of a date, an integer in the range 1900-9999


Q33: What is the YEARFRAC function?
A: Returns the year fraction representing the number of whole days between start date and
end date


Q34: What is the HOUR Function?
A: Returns the hour in a time value, from 0 to 23


Q35: What is the MINUTE function?
A: Returns the minute in a time value, from 0 to 59


Q36: What is the SECOND function?
A: Returns the number of seconds in a time value, from 0 to 59