Practice Spreadsheet Tools – Advanced Features (3.2) - Information and Communication

Practice: Spreadsheet Tools – Advanced Features

Lesson 3.2Information and Communication

Practise this section

9 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
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What function would you use to find the average of a range of cells?
Show hintHide hint
Think about the formula for average.
Question 2.
What is data validation?
Show hintHide hint
Consider how we prevent errors in data entry.
3Question 3.
What does the IF function do?
- Returns a value if a condition is true, and another value if it is false
- Adds numbers together, Counts the number of cells that meet a specific condition
Show hintHide hint
Remember what decisions you can make with the `IF` function.
4Question 4.
True or False: Conditional Formatting can only change the background color of a cell.
- True
- False
Show hintHide hint
Think about the customization options available.
Question 5.
You have sales data for different regions and products. Create a pivot table that summarizes sales by product and region. What steps would you take, and what insights might you draw?
Show hintHide hint
Think about how to categorize your data for clarity.
Question 6.
Design a spreadsheet that highlights any overdue tasks, applies conditional formatting, and uses functions to calculate remaining time until the deadlines.
Show hintHide hint
Combine your skills in functions and formatting for best results.

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