Required:

$1\mathrm{.}1$ Correct the date format in the sales record to use the YYYYMMDD date format

$(4$ marks$)$

$1\mathrm{.}2$ Calculate the total sales recorded for each item and the total sales for the period.

$(3$ marks$)$

$1\mathrm{.}3$ Add a data validation message to restrict date entries in the date column.

$(2$ marks$)$ specific go indetail