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.

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

From the following list, select the choice that BEST describes the purpose of auditing workbooks in Excel.*Auditing allows you to trace formula references between cells.Auditing allows you to spot financial errors in workbooks.Auditing allows you to trace relationships between worksheets.

When using the Data Validation function of Excel, you must ensure that you do what?Select a maximum of four cellsSelect one or more cellsSave your work before you start the process

Data validation does not have to stop data from being entered in a cell, it can also warn you with a user identified message. True False

Sometimes when you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell.Select one:a.userb.inputc.keyd.value