Help start 1. Create the following spreadsheet in Microsoft ExcelMonthly Sales ReportLocation Product 1 Product 2 Product 3 Product 4 Totals by LocationOttawaTorontoVancouverTotal Sales% Of Sales21930 14812 2851 426715992 111933198159916930 11005 287830472. Apply any font colour, font size, fill colours to thedata to make it look professional.3. Calculate the totals for each city and each productrespectively.4. Calculate the percentage of sales.

Here are the steps to create the given table in excel : First turn off the grid lines in the excel…

1. Create the following spreadsheet in Microsoft Excel Monthly Sales Report Location Product Product 2 Product 3 Product 4 Totals by Location Ottawa Toronto Vancouver Total Sales % Of Sales 21930 14812 2851 15992 11193 1599 16930 11005 2878 4267 3198 3047 2. Apply any font colour, font size, fill colours to the data to make it look professional. 3. Calculate the totals for each city and each product respectively. 4. Calculate the percentage of sales.

1. Create the following spreadsheet in Microsoft Excel Monthly Sales Report Location Product Product 2 Product 3 Product 4 Totals by Location Ottawa Toronto Vancouver Total Sales % Of Sales 21930 14812 2851 15992 11193 1599 16930 11005 2878 4267 3198 3047 2. Apply any font colour, font size, fill colours to the data to make it look professional. 3. Calculate the totals for each city and each product respectively. 4. Calculate the percentage of sales.