Excel Chapter 7: End-of-Chapter Quiz
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
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
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)
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?
AND
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?
AVERAGEIF
You want to use an IFS function to indicate which gift card customers get based on the points they have accumulated in one month in the rewards program. Customers who spent over $500 get $50, customers who spent between $250-$499 get $25, and customers who spent $00-$199 get $10. The first customer's amount spent is in cell B5. If the first logical test is B5>=500, what is the second logical argument?
B5>=250
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?
FV
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
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
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
