Question: Exp 2 2 _ Excel _ Ch 0 2 _ Cumulative - Garten Furniture _ Instructions.docxProject Description:You are a finance manager for Garten furniture, a
ExpExcelChCumulative Garten FurnitureInstructions.docxProject Description:You are a finance manager for Garten furniture, a local furniture store that also provides financing, delivery, and handsfree 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 English United StatesStepInstructionsPointsPossibleStart Excel. Download and open the file named Exp ExcelChCumulative FumitureSales xsx Grader has automatically added your last name to the beginning of the filenameInsert a function in cell C to display the current date and ensure that the format is set as a Long DateSet column Cs width to AutofitInsert a function in cell D to display the item name based on the provided inventory lookup information in the range B: Ife sure to use the appropriate absolute cell referencing and the function returns an exact matck Copy the function from cell D down through D to complete column DInsert a function in cell F 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 F down through F to complete column FApply Currency Format to column FInsert an IF function in cell G to calculate the total due. If the customer has chosen deliverycolumn E Yes there is an additional delivery charge located in cell L 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 G down through G to complete column GApply Currency format to column GInsert the function in cell 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 columnUse Quick Analysis to insert a function in cell that calculates the total of all monthly payments in column I
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
