What happens if you forget the password set for sheet protection?  A. The sheet cannot be unprotected without the password.  B. You can reset the password using Excel options.  C. You can recover the password from Microsoft support.  D. The password can be bypassed by saving the workbook with a new name.

Which of the following steps do you follow to protect a worksheet in Excel?  A. Review -> Protect Workbook  B. File -> Options -> Protect Sheet  C. Review -> Protect Sheet  D. Data -> Protect Workbook

Question 2+5-0Tag to RevisitArrange the following in the correct order to create a workbook encrypted with password?Answer areaNavigate to File OptionsEnter PasswordEncrypt WorkbookReopen WorkbookOpen the WorkbookConfirm PasswordYour workbook will be password encrypted, Re-enter Password to open it.Save WorkbookSubmitReset AnswerPreviousNext

What is the default setting for cells when sheet protection is applied in Excel?  A. All cells are locked.  B. All cells are unlocked.  C. Only cells with data are locked.  D. Only cells without data are unlocked.

Match the FollowingProtect SheetsGroup WorksheetHide WorkbookFreeze PanesSave asSaves the current workbook with a new name or in a different file format.Keeps selected rows and/or columns visible while scrolling through a worksheet.Allows for multiple worksheets to be selected and managed as a group.Prevents users from making changes to specific elements of a worksheet, such as cells or formulas.Conceals a worksheet from view within the workbook.SubmitReset AnswerPreviousNext

Q1. What is data validation?Q2. What is the difference between worksheet protection and workbook protection?