Quiz

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
BartoszCreated by Bartosz
11 Steps9 Questions

Students also studied

Browse all

Steps in this lesson (11)

1
Text

Building on what you've learned about spreadsheets, let's test your knowledge of formulae and operators!

2
Multiple ChoiceInteractive

Which operator is used to multiply values in a spreadsheet formula?

Start the lesson to answer this multiple choice question

3
Multi-SelectInteractive

Which of the following are valid Excel formula operators? (Select all that apply)

Start the lesson to answer this multi-select question

4
Fill in the BlankInteractive

To add two numbers in a spreadsheet, you use the {{blank0}} operator.

Start the lesson to answer this fill in the blank question

5
MatchingInteractive

Match the items on the left with their correct pairs on the right

Start the lesson to answer this matching question

6
Math EquationInteractive

What is the result of the formula =15+7?

Start the lesson to answer this math equation question

7
typedAnswer

Match the items on the left with their correct pairs on the right

8
Multiple ChoiceInteractive

What would the formula =A1/B1 do?

Start the lesson to answer this multiple choice question

9
Fill in the BlankInteractive

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

10
Multi-SelectInteractive

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

11
Multiple ChoiceInteractive

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