Studied by 21 people
The date February 16, 2024, is stored in cell B1. The last day of the semester (May 7, 2024) is stored in cell B2. Which function calculates the number days between those dates?
DAYS(B2,B1)
The date 8/9/2024 is stored in cell C5, and =WEEKDAY (C5) is stored in cell D5. What is the default function result if cell D5 has not been formatted?
6
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 and if that person has two or more speeding violations on record. Which function should be used?
OR
A dataset contains a list of nursing employees at a hospital. You want to give a $500 bonus to head ER nurses and nurse managers. Which function do you nest within an IF function to ensure all the nurses with either title get the bonus?
OR
A workbook contains a list of houses and the months that they were sold in several cities in Florida in June. You are interested in determining the average price of sold houses in Ft. Lauderdale. What function is best suited for this calculation?
AVERAGEIFS
A dataset contains a list of governors, the states they represent, the years they were elected, and their salaries. You want to identify the lowest-paid representative who was elected after 11/1/2024. What is the best function to use?
MINIFS
Which of the following could not be used to produce a map chart in Excel?
412 Elm Avenue, 700 S Logan Circle, 602 Cedar Street
Which function should you use to calculate the cumulative value at the end of 20 years in which you invest $100 every month with 4.5% APR?
CUMIPMT
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?
Principal Repayment
Note 
Flashcard (20)