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

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

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.

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

Which key do you hold down when selecting cells that are in different areas of a worksheet?

Use the Set statement to point the worksheet object variable to the January worksheet in this workbook. Use the InputBox function to prompt the user for his/her name. Store the user’s response in the string variable called strName.