CSUF Excel Lesson 2 Quiz ISDS 361A Skordi

CSUF Excel Lesson 2 Quiz ISDS 361A Skordi
If you were to count the number of cost values you had in column D, you would use the
following function:
Select one:

a. COUNTIF
b. COUNT
c. COUNTA
d. COUNTN - -b. COUNT

-The formula you used for the Total Retail Value of Glasses was____.
Select one:

a. =C21*E21
b. =C17 * E17
c. =SUM(C21*E21)
d. =SUM(C21:E21) - -b. =C17 * E17

-To calculate the Median Retail Price, you used the following function:
Select one:

a. MEDIAN
b. MAX
c. AVERAGE
d. HIGHEST - -a. MEDIAN

-To calculate the Lowest Retail Price, you used the following function:
Select one:

a. LOWEST
b. MIN
c. SMALLEST
d. MINIMUM - -b. MIN

-To get to the Current Date button which allows you to show the Current Date in the
header, you would click on the following tabs, ribbons, and or buttons.
Select one:

a. View/Insert/Header
b. Insert/Header & Footer
c. File/Insert/Header
d. Page Layout/Header & Footer - -b. Insert/Header & Footer

-What is the total quantity of items in inventory?