Question: Exp 2 2 _ Excel _ Ch 0 2 _ Cumulative - Garten Furniture _ Instructions.docxProject Description:You are a finance manager for Garten furniture, a

Exp22_Excel_Ch02_Cumulative - Garten Furniture_Instructions.docxProject Description:You are a finance manager for Garten furniture, a local furniture store that also provides financing, delivery, and hands-free setup. As part of your daily tasks, you create an Excel workbook that reports sales, payment plan information, and summary statistics.Steps to Perform:AaBbCcDdHeading 2English (United States)StepInstructionsPointsPossibleStart Excel. Download and open the file named Exp22_ Excel_Ch02_Cumulative_ Fumiture_Sales x/sx. Grader has automatically added your last name to the beginning of the filename.2Insert a function in cell C3 to display the current date and ensure that the format is set as a Long Date.43Set column C's width to Autofit.04Insert a function in cell D11 to display the item name based on the provided inventory lookup information in the range B24:29. Ife sure to use the appropriate absolute cell referencing and the function returns an exact matck Copy the function from cell D11 down through D19 to complete column D10Insert 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. Copy the function from cell F11 down through F19 to complete column F.10Apply Currency Format to column F5Insert an IF function in cell G11 to calculate the total due. If the customer has chosen delivery(column E = Yes), there is an additional delivery charge located in cell L11. If the item is notdelivered, the total due is price. Be sure to use appropriate relative and absolute cell references. Copy the function from cell G11 down through G19 to complete column G.10Apply Currency format to column G5Insert the function in cell 111 to calculate the first customer's monthly payment, using appropriate relative and absolute cell references. Place a minus sign to the left of the present value argument so that the function returns a positive result. Copy the formula down the column.1010Use Quick Analysis to insert a function in cell 120 that calculates the total of all monthly payments in column I.4

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!