Microsoft Excel 2021365 - Beginner to Advanced - Exercise 15

This video tutorial covers how to perform spell checking on a worksheet and protect cells and worksheets. It begins with instructions on running a spell check, ensuring all errors are corrected, and reviewing proofing settings. The tutorial then shifts to protecting cells, specifically unlocking cells with constant numbers and using 'Go to Special' to select them. Finally, it demonstrates setting a password to protect the worksheet and testing the protection by attempting to edit formula cells.

What is the primary purpose of running a spell check on a worksheet?

• To protect the worksheet from editing

• To ensure all formulas are correct

• To catch and correct any spelling errors

• To format the worksheet

Which feature allows you to select all constant numbers in a worksheet?

• Go to Special

• Conditional Formatting

• Data Validation

• Find and Replace

What should you do after selecting all constant numbers in a worksheet?

• Lock them

• Unlock them

• Hide them

• Delete them

Which tab do you use to protect a worksheet with a password?

• Home

• Insert

• Review

• Data

What happens if you try to edit a cell containing a formula after protection is applied?

• The cell value changes

• An error message appears

• The worksheet crashes

• The formula is deleted