Please, do all and include the formulas you used.

Problem #1: You will complete a problem from a list of unit sales of Rosebud Distributing Companys five products by its five sales representatives in three markets during the year ending December 31, 2021.

a)Use the =VLOOKUP function to enter the price of each product sold.

You will need to use absolute cell references in the range for the table array to be able to copy the formula down for each sale.

b) Compute the sales amount for each sale. Use the =ROUND function to round the commission amounts to whole cents (two decimals).

c)Use the =VLOOKUP function to enter the commission rate of each sale.

You will need to use absolute cell references in the range for the table array to be able to copy the formula down for each sale.

d) Compute the total commission amount for each sale. Use the =ROUND function to round the commission amounts to whole cents (two decimals).

e) On a separate worksheet, prepare a cross-tabulated pivot table on a separate worksheet that summarizes the sales value for each product in the rows by sales rep in the column.

f)Insert a slicer for the Markets.

g) Properly format the new schedule.

h) On a separate worksheet, prepare a pivot table on a separate worksheet that summarizes the total sales commission earned by each sales rep.

i) Properly format the new schedule.

Rosebud Distributing Company Sales Report For the year ended December 31, 2023 Points Assigned Points Earned 15 points VLOOKUP Price and Sales Computation Computation VLOOKUP Commission Rate and Commission Computation \begin{tabular}{|c|c|c|} \multicolumn{1}{c}{15 points } & \multicolumn{1}{c}{15 points } & \multicolumn{1}{c}{ Total } \\ \multicolumn{1}{l|}{\begin{tabular}{c} Report \#1 \\ Report \#2 \end{tabular}} & \multicolumn{1}{c|}{60 points } \\ \hline & & 0 \\ \hline \end{tabular}