Ch9 Part 2 Q4 Match the words with the concept:Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab A cell in a worksheet that prevents a user from entering data if the worksheet is protected.Locked cellA cell in a worksheet that prevents a user from entering data if the worksheet is protected.Press space or enter to grab It simply prevents users from modifying locked cells within the worksheet.Protect sheetIt simply prevents users from modifying locked cells within the worksheet.Press space or enter to grab To lock your file so that other users can’t open it.Protect workbookTo lock your file so that other users can’t open it.

Ch9 Part 2 Q2 Match the words with the concept:Drag and drop options on the right-hand side and submit. For keyboard navigation...SHOW MOREPress space or enter to grab An area that displays the workbook name worksheet name cell addresses values and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen.Watch WindowAn area that displays the workbook name worksheet name cell addresses values and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen.Press space or enter to grab Occurs when a formula contains a direct or an indirect reference to the cell containing the formula.Circular referenceOccurs when a formula contains a direct or an indirect reference to the cell containing the formula.

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

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

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