Practice What Is A Function? (1) - Spreadsheet – Functions and Charts - ICSE 8 Computer Applications

Practice: What is a Function?

Lesson 1Spreadsheet – Functions and Charts

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 is the purpose of the SUM function?
Show hintHide hint
Think about how you would sum multiple numbers.
Question 2.
How would you write the formula to find the maximum number in cells B1 to B5?
Show hintHide hint
Remember, MAX finds the highest value.
3Question 3.
What does the SUM function do?
- Counts numeric entries
- Adds numbers
- Finds maximum value
Show hintHide hint
Think about what we do with numbers when we total them.
4Question 4.
True or False: The AVERAGE function calculates the median.
- True
- False
Show hintHide hint
Remember the difference between mean and median.
Question 5.
Create a spreadsheet model that tracks sales over four quarters, and use functions to calculate the total sales, average quarterly sales, highest quarterly sales, and lowest quarterly sales.
Show hintHide hint
Think about how you can apply each function to a typical data set.
Question 6.
Write an Excel formula that checks if the average score from cells F1 to F5 exceeds 60, and returns 'Passed' if true, and 'Failed' if not.
Show hintHide hint
Combine the AVERAGE function with the IF function to create this logic.

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