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

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

This formula placed in data validation will only accept values greater than the cell above it: =A1>A2 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

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.

Explain, using examples, why validation andverification do not ensure that data is correct.