Quiz

Quiz: Security Measures (Locked Cells)

Cambridge Nationals IT Level 1/Level 2

11 Steps9 Questions

Students also studied

Text

Building on what you've learned about spreadsheets, let's test your knowledge of security measures, focusing on locked cells!

Multiple ChoiceInteractive

What is the main purpose of locking cells in a spreadsheet?

Start the lesson to answer this multiple choice question

Multi-SelectInteractive

Which of the following are steps to protect a spreadsheet with locked cells? (Select all that apply)

Start the lesson to answer this multi-select question

Fill in the BlankInteractive

Locked cells in a spreadsheet become effective only when {{blank0}} is enabled.

Start the lesson to answer this fill in the blank question

MatchingInteractive

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

Start the lesson to answer this matching question

Multiple ChoiceInteractive

What happens if you lock a cell but do not enable worksheet protection?

Start the lesson to answer this multiple choice question

typedAnswer

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

Fill in the BlankInteractive

To unlock a locked cell after protection is applied, you need the {{blank0}}.

Start the lesson to answer this fill in the blank question

Multiple ChoiceInteractive

Which of the following settings must be applied to lock cells?

Start the lesson to answer this multiple choice question

Multi-SelectInteractive

Which features can be customised during worksheet protection? (Select all that apply)

Start the lesson to answer this multi-select question

Multiple ChoiceInteractive

Why might you leave some cells unlocked in a protected worksheet?

Start the lesson to answer this multiple choice question

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