CGS 2518 Module 5 and 6 questions
well answered already passed
The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should
you use to extract just 12? - correct answer ✔✔=DAY(C1)
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? - correct answer ✔✔=DAYS(B2, B1)
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")? - correct answer ✔✔=NOT(B1="Sold Out")
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? - correct answer ✔✔DCOUNT
A worksheet contains the times in which runners completed a race, with the times organized
from fastest to slowest. You will use the MATCH function to identify what place a runner came in
given a time of 4:05 (four minutes and five seconds). Which argument should contain the
specific runner's time? - correct answer ✔✔Lookup_value
What function would you use to calculate the total (i.e., cumulative) interest paid for the first
year of a mortgage? - correct answer ✔✔CUMIPMT
When you are performing an advanced filter, where do you enter the rage for the dataset? -
correct answer ✔✔List range
well answered already passed
The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function should
you use to extract just 12? - correct answer ✔✔=DAY(C1)
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? - correct answer ✔✔=DAYS(B2, B1)
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")? - correct answer ✔✔=NOT(B1="Sold Out")
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? - correct answer ✔✔DCOUNT
A worksheet contains the times in which runners completed a race, with the times organized
from fastest to slowest. You will use the MATCH function to identify what place a runner came in
given a time of 4:05 (four minutes and five seconds). Which argument should contain the
specific runner's time? - correct answer ✔✔Lookup_value
What function would you use to calculate the total (i.e., cumulative) interest paid for the first
year of a mortgage? - correct answer ✔✔CUMIPMT
When you are performing an advanced filter, where do you enter the rage for the dataset? -
correct answer ✔✔List range
