The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?

(a) =YEAR(C1)

(b) =MONTH(C1)

(c) =DAYS(B1,C1)

(d) =DAY(C1)

The date February 16, 2021 is stored in cell B1. The last day of the semester (May 7, 2021) is stored in cell B2. Which function calculates the number days until the end of the semester?

(a) =DAYS(B1,B2)

(b) =DAYS(B2,B1)

(c) =YEARFRAC(B1,B2)

(d) =DAY(B1)

For which situation would you use the SWITCH function?

(a) You want to display a bonus if an employee earned a 5 on a performance evaluation and was hired before 1/1/2021.

(b) You want to calculate a three-tier bonus based on salaries for employees: 5% bonus for employees who exceeded their goals, 3% bonus for employees who met their goals, and 0% for employees who did not meet their goals.

(c) You have a spreadsheet with a list of articles and a column containing authors initials (JD, KM, MP, RG). You want to create another column that evaluates the initials and returns their respective names.

(d) You have a list of graduating students. You want to calculate the average GPA for only students graduating with a marketing degree

A workbook contains a list of houses and the months that they were sold in Florida. You are interested in determining the average price of sold houses in June in Ft. Lauderdale. What function is best suited for this calculation?

(a) AVERAGEIFS

(b) AVERAGEIF

(c) SUMIF

(d) MAXIFS

You want to create a spreadsheet with populations. Which of the following could not be used to produce a map chart in Excel?

(a) State names, such as Ohio, Oklahoma, Oregon

(b) City names, such as Boston, Denver, Los Angeles

(c) Postal codes, such as 73085, 73701, 74074

(d) State abbreviations, such as TX, CO, CA, MA

What function would you use to calculate the total interest paid for the first year of a mortgage?

(a) CUMIPMT

(b) PMT

(c) PPMT

(d) CUMPRINC

A dataset contains a list of U.S. Representatives, the states they represent, the years they were elected, and their salaries. You want to identify the highest-paid representative who was elected before 1/1/2020. What is the best function to use?

(a) MAX

(b) IFS

(c) MAXIFS

(d) YEARFRAC

You constructed a loan amortization table with beginning balance, monthly payment, interest paid, principal repayment, and ending balance columns. If all the formulas are correct, which is the only column that shows an increase in value throughout the term of the loan?

(a) Beginning Balance

(b) Monthly Payment

(c) Interest Paid

(d) Principal Repayment

A local police chief wants to create a rule that a person will be ticketed if an officer pulls over a person for exceeding the speed limit by at least five miles per hour or if that person has two or more speeding violations on record. Which function should be used?

(a) AND

(b) MAXIFS

(c) OR

(d) SWITCH

What function would you use to calculate the total number of periods in a loan or investment?

(a) NPER

(b) RATE

(c) PV

(d) FV