Practice Using Functions And Charts Together (4) - Spreadsheet

Practise this section

10 questions

Flashcard drill
4 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
4 questions · about 3 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does the SUM function do?
Show hintHide hint
Think about calculating total amounts.
Question 2.
Name a type of chart that is useful for comparing categories.
Show hintHide hint
Consider horizontal versus vertical representation.
3Question 3.
What does the AVERAGE function do?
- It calculates the total
- It finds the middle number
- It counts values
Show hintHide hint
Think about how averages reflect central tendencies.
4Question 4.
True or False: A bar chart is the best choice for showing trends over time.
- True
- False
Show hintHide hint
Consider what a line chart does.
Question 5.
You have the sales data for each quarter in cells A1 to A4. How would you use a function to find out the total sales, and which chart would you use to depict this data?
Show hintHide hint
Think about how you can represent the total visually.
Question 6.
Given monthly test scores in cells B1 to B12, create a formula to evaluate the average score and suggest an appropriate chart for visualizing this performance trend over the year.
Show hintHide hint
Consider how a line chart portrays continuous data.

6 more questions in this section. Enroll free to practise them all.