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

$(2$ marks$)$

$1\mathrm{.}4$ Add a message to the date column that notifies the user that the column only accepts date entries and an alert message when a text is entered.

$(2$ marks$)$

$1\mathrm{.}5$ Restrict the total sales column to accept currency without decimals and add a message that reads, "Only enter currency values without decimals."

$(2$ marks$)$

You have decided to show how the different machinery categories have been performing using a Pivot Table. Answer the following questions.

$1\mathrm{.}6$ Use a Pivot Table to show the product items and quantities sold in each month.

$(3$ marks$)$

Note: NO marks if the table was not created using a Pivot Table.

$1\mathrm{.}7$ Show the total sales from each product item in a Pivot Table.

$(3$ marks$)$

Note: NO marks if the table was not created using a Pivot Table.