(Solved): Complete all steps to make project look like final picture Garten Furniture Weekly Sales Possible ...

Garten Furniture Weekly Sales Possible Start Excel Download and open the file named 0 Exp22_Excel_Ch02_Cumulative_Fumiture_Sales $$x/sx$$. Grader has automatically added your last name to the beginning of the filename Insert a function in cell C3 to display the current date and ensure that the format is set as a 4 Long Date. Set column C's width to Autofit. 0 Insert a function in cell D11 to display the item name based on the provided inventory lookup information in the range B24:D29. Be sure to use the appropriate absolute cell referencing and the function returns an exact match. Copy the function from cell D11 down through D19 to complete column D. Insert a function in cell F11 to display the item price based on the provided inventory lookup information. Be sure to use appropriate absolute cell referencing and the function returns an exact match. Copv the function from cell $$F11$$ down through $$F19$$ to complete column $$F$$. 10 \begin{tabular}{|c|l|c|c|} \hline Step & \multicolumn{1}{|c|}{ Instructions } & Points Possible \\ \hline 16 & Insert a function in cell H25 to calculate the lowest monthly payment in column I. \\ \hline 17 & Insert a function in cell H26 to calculate the average monthly payment in column I. \\ \hline 18 & Insert a function in cell H27 to calculate the highest monthly payment in column I. \\ \hline 19 & Insert a function in cell H28 to calculate the median monthly payment in column I. \\ \hline 20 & Apply Currency format to the range H25:H28. \\ \hline 21 & Save and close Exp22_Excel_ChO2_Cumulative_Fumiture_Sales.x/sx. Exit Excel. Submit the file as directed \\ \hline \end{tabular} Garten Furniture Weekly Sales