Practice Syntax Of A Function (1.1) - Spreadsheet

Practise this section

10 questions

Flashcard drill
3 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 adding numbers in a list.
Question 2.
Which symbol must all functions start with?
Show hintHide hint
It shows that a calculation follows.
3Question 3.
What does the IF function do?
- Checks a condition and returns a value based on true or false.
- Calculates the sum of a range.
- Returns the maximum value in a set.
Show hintHide hint
Remember the structure of the IF function.
4Question 4.
True or False: The MIN function will return the highest number in a range.
- True
- False
Show hintHide hint
Check what the MIN function does.
Question 5.
Using data in cells F1 to F5 containing values 10, 20, 30, 40, 50, create a summary formula that calculates the total and the average of these values.
Show hintHide hint
Think about the two separate calculations needed.
Question 6.
If you have a dataset where A1=200, A2=150, and A3=250, write a formula that finds the maximum and minimum values.
Show hintHide hint
Use the MAX and MIN functions to solve this.

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