Chapter 7
1. Today’s date (February 12, 2018) is stored in cell B1. The last day of the semester (May
4, 2018) is stored in cell B2. You want to know how many days until the end of the
semester. Which function should you use?
a. =DAYS(B2, B1)
2. The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function
should you use to extract just 12?
a. =DAY(C1)
3. You workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out,
Available if it is still readily available, or Limited if only a few pieces are available. In
the third column, you want to display TRUE if the art is not sold out. What function
would produce the same results as =OR(B1=”Available”, B1=”Limited”)?
a. =NOT(B1=”Sold Out”)
4. A workbook contains a list of members in the Computer Club. You want to identify the
number of students who are freshmen who are Information Systems majors. Without
filtering the dataset, what function should you use?
a. DCOUNT
5. A worksheet contains the times in which runners completed a race, with the times
organized from fastest to slowest. You will us the MATCH function to identify what
place a runner came in given a time of 4:05. Which argument should contain the specific
runners time?
a. Lookup_value
