1.1 - Syntax of a Function
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What does the SUM function do?
💡 Hint: Think about adding numbers in a list.
Which symbol must all functions start with?
💡 Hint: It shows that a calculation follows.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does the IF function do?
💡 Hint: Remember the structure of the IF function.
True or False: The MIN function will return the highest number in a range.
💡 Hint: Check what the MIN function does.
2 more questions available
Challenge Problems
Push your limits with advanced challenges
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.
💡 Hint: Think about the two separate calculations needed.
If you have a dataset where A1=200, A2=150, and A3=250, write a formula that finds the maximum and minimum values.
💡 Hint: Use the MAX and MIN functions to solve this.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.