1. On the Scorecard sheet, select cell I1 and format the date to appear in the preferred format. Example: 2021 April 08 Thu.
2. On the Scorecard sheet, select cells H3:H13 and use data validation to allow only values from 1.00 to 4.00. Create a stop message that displays: Values between 1.00 and 4.00 only.
3. On the Scorecard sheet, select cells I3:I13 and use data validation to allow only values from 1 to 100. Create an input message that displays: Enter a value from 1 to 100. Do not exceed a total of 100 in cell I14.
4. On the Feedback sheet, remove duplicate entries submitted by employees.
5. On the Feedback sheet, select the dates in column B and apply the custom format you created earlier for the date on the Scorecard sheet.
6. On the Detail sheet, sort the data by Project ID to prepare for subtotals.
7. On the Detail sheet, select a single cell to clear any previous selections. Then create subtotals by Project ID, including the sum of Sale Price, Sale, Disposal, and Net.