MICROSOFT EXCEL MULTIPLE CHOICE:

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?

=DAYS(B1,B2)

=DAYS(B2,B1)

=YEARFRAC(B1,B2)

2.) 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")?

=TRUE(B1<>"Sold Out")

=NOT(B1="Sold Out')

=AND(B1="Available",B1="Limited")

3.) 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?

DCOUNT

COUNT

COUNTA

4.) When you are performing an advanced filter, where do you enter the range for the dataset?

List Range

Copy to Range

Output Range