Quiz: Formulae and Operators
Cambridge Nationals IT Level 1/Level 2
Ready to start this lesson?
Sign in to track your progress. 11 steps including 9 interactive questions.
Sign In to Start Learning
Students also studied
Browse allSteps in this lesson (11)
Building on what you've learned about spreadsheets, let's test your knowledge of formulae and operators!
Which operator is used to multiply values in a spreadsheet formula?
Start the lesson to answer this multiple choice question
Which of the following are valid Excel formula operators? (Select all that apply)
Start the lesson to answer this multi-select question
To add two numbers in a spreadsheet, you use the {{blank0}} operator.
Start the lesson to answer this fill in the blank question
Match the items on the left with their correct pairs on the right
Start the lesson to answer this matching question
What is the result of the formula =15+7?
Start the lesson to answer this math equation question
Match the items on the left with their correct pairs on the right
What would the formula =A1/B1 do?
Start the lesson to answer this multiple choice question
To find the average of a range of cells, you use the {{blank0}} function.
Start the lesson to answer this fill in the blank question
Which of the following are examples of logical operators used in spreadsheet formulas? (Select all that apply)
Start the lesson to answer this multi-select question
Which function is used to add all values in a range of cells?
Start the lesson to answer this multiple choice question
Want to Learn More?
Get personalised lessons, quizzes, and instant feedback from your AI tutor.
Explore More Topics