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

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

From the following list, select the choice that BEST describes the purpose of using cell validation inExcel worksheets.*It allows you to see changing values in cells that you cannot actively view within the worksheet.It allows you to check if cell references being displayed by auditing arrows that point to external workbooks are correct and valid.It allows you restrict the range of values that can be entered into selected cells in a worksheet.

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.

Question 4Fill in the blank: Data validation is a tool for checking the _____ of data before adding or importing it. 1 pointorigin and agesize and structureaccessibility and opennessaccuracy and qualityCoursera Honor Code  Learn mo

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.