Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
A quiz for csuf's isds 361a course, focusing on excel skills. It includes multiple-choice questions covering topics like counting values, calculating totals, finding median and minimum values, and using the 'current date' button. The quiz provides a valuable learning tool for students to assess their understanding of basic excel functions and features.
Typology: Exams
1 / 5
This page cannot be seen from the preview
Don't miss anything!
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*E
b. =C17 * E
c. =SUM(C21*E21)
d. =SUM(C21:E21) ✔✔b. =C17 * E
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
Select one:
a. $32.
b. $16.
c. $352.
d. $16.95 ✔✔d. $16.
What was the Median Retail Price that you calculated?
Select one:
a. $15.
b. $352.
c. $3.
d. $15.00 ✔✔d. $15.
What was the Total Retail Value of Glasses?
Select one:
a. $384.
b. $32.
c. $64.
d. $12.00 ✔✔a. $384.
Which of the following functions was the one you should have used to count the number of categories in column A?
Select one:
a. =SUM(A9:A29)
b. =COUNTA(A9:A29)
c. =COUNT(A9:A29)
d. =COUNT(C9:C29) ✔✔b. =COUNTA(A9:A29)
