GoSkills
Back to lesson
Question
1
of
3
1. How would we determine the count of non-blank items in the range A1:A10?
=COUNTA(A1:A10)
=COUNT(A1:A10)
=SUM(A1:A10)
Don’t know
2. Which of the following functions will return the most frequently occurring number in a data set?
COUNT()
MODE()
MEDIAN()
Don’t know
3. Which of the following formulas is the best way to return the arithmetic mean of the numbers in a data set?
MEDIAN(A1:A10)
SUM(A1:A10)/COUNT(A1:A10)
AVERAGE(A1:A10)
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement