Question: 2. Apply date validation over the cell range C3 through G11 that allows only decimal numbers in the range 0 through 1 to be entered.

2. Apply date validation over the cell range C3 through G11 that allows only decimal numbers in the range 0 through 1 to be entered. Note that 1 represents 100%. The data validation must include the input message Enter student grade. Additionally, set an error alert o style Stop, with the error message Grade must be a decimal number between 0 and 100%. Do not include a title for either the input message or error alert Make sure to test that your data validation rejects invalid data by attempting to enter a negative number (for example -1), a number greater than 100%% (for example 101%). Also try re-entering the original value in one of the cells to make sure that it is accepted. Make
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
