CSUF Excel Lesson 2 Quiz ISDS 361A Skordi Latest Version 100% Pass

CSUF Excel Lesson 2 Quiz ISDS 361A Skordi Latest Version 100% Pass 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? Select one: a. 591 b. 22 c. 583 d. 21 a. 591 What was the Average Retail Price that you calculated? Select one: a. $32.09 b. $16.81 c. $352.94 d. $16.95 d. $16.95 What was the Median Retail Price that you calculated? Select one: a. $15.50 b. $352.94 c. $3.00 d. $15.00 d. $15.00 What was the Total Retail Value of Glasses? Select one: a. $384.00 b. $32.00 c. $64.00 d. $12.00 a. $384.00