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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!