Free Excel 2003 quiz - Test Your Skills!

Protecting Your Work

The aim of this quiz is to check your knowledge of Protecting Your Work in Excel 2003.

We've detected that you don't have Javascript enabled in your browser - you can still try the Quiz, but clickable 'image map' questions won't work. Please enable Javascript and refresh this page. If you can't, you can follow this link for a version which converts image questions to multiple-choice. You may also prefer to use the multiple-choice version if you use screen reading software, like JAWS, to browse.

Please ensure that you read all questions carefully and spell all answers correctly! Once you have completed the quiz, please click the 'score my answers!' button to find out how you did.

If you like this quiz, there are plenty more where it came from! You can see the full list of subjects here.

You can learn more about our classroom, online and soft skills courses at our Happy websites.

Questions

How would you lock cells B5 to C6 in a worksheet, but leave all other cells unlocked?

Please select an answer...
- Lock the sheet, and choose cells B5 to C6 from the dialog box
- Select the whole sheet, unlock all cells, select cells B5 to C6, and lock those cells
- Select the whole sheet, deselect cells B5 to C6, and lock those cells
- Select cells B5 to C6, and lock those cells
Which password option should you select if you want to prevent unauthorised users from modifying your worksheet?

Please select an answer...
- Password to open
- Always create backup
- Password to modify
- Read-only recommended
If you've created a password to prevent people opening a workbook, how can you later remove it?

Please select an answer...
- Click on File, Save As, Tools, Remove Password, then delete the password that is there already.
- You can't
- Click on File, Save As, Tools, General Options, then delete the password that is there already.

Top