Answered step by step
Verified Expert Solution
Question
1 Approved Answer
W . C . Hicks Appliances 1 W . C . Hicks Appliances 4 . Client Name 5 Garten 6 Leggett 7 Vong 8 Ranger
WC Hicks Appliances
WC Hicks Appliances
Client Name
Garten
Leggett
Vong
Ranger
Williams
Davis
Jackson
Garcia
Broadnax
Totals
Inventory Information
SKU Description
Refrigerator
Dishwasher
Microwave
Oven
Washer
Dryer
Delivery Fee
Interest Rate
Months Per Yeas
Insert a function in cell to display the item named based on the provided inventory lookup information. Copy the function from cell C down through C to complete column C
AutoFit the width of column
Insert a function in cell to display the item price based on the provided inventory lookup information. Copy the function from cell E down through to complete column
Apply Currency Number Format with two decimal places to column E
Insert an IF function in cell F to calculate the total due. If the customer has chosen home delivery, there is an additional dellvery charge located in cell B Be sure to use appropriate relative and absolute cell references.
Copy the function from cell F down through F to complete column F and apply Currency Number Format with two decimal places to column
Insert the function in cell to calculate the first customer's monthly payment, using appropriate relative and absolute cell references. Ensure the result is a positive number. Copy the formula down to complete column
Insert a function in cell to calculate the total of all monthly payments in column and apply Currency Number Format with two decimal places to column if necessary.
Insert a function in cell to calculate the total number of orders based on entries in column
A
Insert a function in cell to calculate the lowest monthly payment in column
Insert a function in cell to calculate the average monthly payment in column
Insert a function in cell to calculate the highest monthly payment in column
Insert a function in cell to calculate the median monthly payment in column
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started