(15) hal in the colutin "Avg Dscigutsed Pitice by frid item saies price for items that Did have a promction at the lime of transaction based on the cata in the Trancactens Log worksheet. - If there is an errori roturn a blari value Q.e 'i] (8) 16) Create a Cungered Column. chartigraph with the daka from the column Transactions' and the days of the week. - Name the chart 'Transacilens_By,Day' usingthe Name Box. Place the Tranactions by Category on Sunday chart hare - The days should be listed across thefor gradne x ans - Change the chart uile to 'Tranactions by Day' and position the upper lett corner to be in ceil H3) (12) (1.7) Createa tine chart with the data from the colum= 'Reveabe' and the days of the week: (1.5) Fill in the column "Avg Discounted Price" by finding the average item sales price for items that DID have a promotion at the time of transaction based on the data in the Transactions Log worksheet. - If there is an error, return a blank value (i.e. "'). 8 (1.6) Create a Clustered Column chart/graph with the data from the column "Transactions" and the days of the week. - Name the chart "Transactiolis_By_Day" using the Name Box. - The days should be listed across the X axis. - Change the chart title to "Transactions by Day" and position the upper left corner to be in cell H3). Book10 Home Insert Draw Page Layout Formulas Data Review View \& Tellme \begin{tabular}{l} Calibri (Body) \\ \hline Paste \end{tabular} Conditi Format Cell Styl workbook. There is an unneeded column Fill in the column Fill in the column "Revenue" by Fill in the column "Avg Full Sale Price" by finding the average item sales price for items that DID NOT have a promotion at the time of the transaction based on the data in the Transactions Log worksheet. - If there is an error, return a blank value (i.e. ""). 8 1.5) Fill in the column "Avg Discounted Price" by finding the average item sales price for items that DID have a promotion at the time of transaction based on the data in the Transactions (15) hal in the colutin "Avg Dscigutsed Pitice by frid item saies price for items that Did have a promction at the lime of transaction based on the cata in the Trancactens Log worksheet. - If there is an errori roturn a blari value Q.e 'i] (8) 16) Create a Cungered Column. chartigraph with the daka from the column Transactions' and the days of the week. - Name the chart 'Transacilens_By,Day' usingthe Name Box. Place the Tranactions by Category on Sunday chart hare - The days should be listed across thefor gradne x ans - Change the chart uile to 'Tranactions by Day' and position the upper lett corner to be in ceil H3) (12) (1.7) Createa tine chart with the data from the colum= 'Reveabe' and the days of the week: (1.5) Fill in the column "Avg Discounted Price" by finding the average item sales price for items that DID have a promotion at the time of transaction based on the data in the Transactions Log worksheet. - If there is an error, return a blank value (i.e. "'). 8 (1.6) Create a Clustered Column chart/graph with the data from the column "Transactions" and the days of the week. - Name the chart "Transactiolis_By_Day" using the Name Box. - The days should be listed across the X axis. - Change the chart title to "Transactions by Day" and position the upper left corner to be in cell H3). Book10 Home Insert Draw Page Layout Formulas Data Review View \& Tellme \begin{tabular}{l} Calibri (Body) \\ \hline Paste \end{tabular} Conditi Format Cell Styl workbook. There is an unneeded column Fill in the column Fill in the column "Revenue" by Fill in the column "Avg Full Sale Price" by finding the average item sales price for items that DID NOT have a promotion at the time of the transaction based on the data in the Transactions Log worksheet. - If there is an error, return a blank value (i.e. ""). 8 1.5) Fill in the column "Avg Discounted Price" by finding the average item sales price for items that DID have a promotion at the time of transaction based on the data in the Transactions
