$1.$ Click the sales sheet. Format the data set as a table. Choose a style from the styles gallery.

$2.$ Create the following calculated columns.

a$)$ In I$4,$ and J$4,$ use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. $[$Hint: The Product Table sheet lists the Price and Cost$]$ If any error messages appear, check the Range Lookup.

b$)$ In K$4,$ use a formula to calculate Profit. Hint: Profit $=($Product Price$-$Product Cost$)*$Units Sold

$3.$ Format columns I, J$,$ and K as currency with two decimal places.

$4.$ Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.

a$)$ What was the total Profit for Online Sales?

b$)$ Sort the results by Date Sold $($A$/$Z$).$