Quiz

Quiz: Cell Formatting

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
11 Steps9 Questions

Students also studied

Browse all

Steps in this lesson (11)

1
Text

Building on what you've learned about data validation, let's test your knowledge of cell formatting!

2
Multiple ChoiceInteractive

What does 'cell formatting' allow you to do in a spreadsheet?

Start the lesson to answer this multiple choice question

3
Multi-SelectInteractive

Which of the following are cell formatting options? (Select all that apply)

Start the lesson to answer this multi-select question

4
Fill in the BlankInteractive

To format the appearance of text in a cell, you can adjust the {{blank0}}, {{blank1}}, and {{blank2}}.

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
Multiple ChoiceInteractive

When would you use 'merge cells' as a formatting option?

Start the lesson to answer this multiple choice question

7
Math EquationInteractive

You want to format a number in a cell so it shows as currency (£). What formatting option should you apply?

Start the lesson to answer this math equation question

8
typedAnswer

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

9
Multiple ChoiceInteractive

Which formatting option would you use to make text stand out in a cell?

Start the lesson to answer this multiple choice question

10
Multi-SelectInteractive

What are some advantages of formatting cells? (Select all that apply)

Start the lesson to answer this multi-select question

11
Fill in the BlankInteractive

When formatting a cell, you can add a {{blank0}} to separate it or highlight its content.

Start the lesson to answer this fill in the blank question

Genie

Want to Learn More?

Get personalised lessons, quizzes, and instant feedback from your AI tutor.

Explore More Topics
Revision GenieRevision Genie

Turn "I don't understand" into "I aced it" with instant explanations, personalised lessons, and exam practice that actually works.

Need Support?

We're here to help with study stress or exam pressure.

Revision Genie Ltd45 Fitzroy Street, London W1T 6EBCompany: 16212210ICO: ZC008367

© 2026 Revision Genie Ltd. All rights reserved. IBO, AQA, OCR, and Edexcel were not involved in the production of, and do not endorse, the resources or AI tutoring provided on the Revision Genie platform.Payments by Stripe.