Answered step by step
Verified Expert Solution
Question
1 Approved Answer
mon. As part of your daily, you create nel wordt oorspoon, and You are an manager for W.C. Hicks Appliances, local plane store dangery and
mon. As part of your daily, you create nel wordt oorspoon, and You are an manager for W.C. Hicks Appliances, local plane store dangery and Start Excel Download and open the feed Ex EONORA Insert a Pinction in costo display the bandoma Long Insert a function in CS to play the hom nomed bed on the provided inventory lookup Ex2919 Project Description: Exp19_Excel_Cho2_Cap_Appliances summary statistics Steps to Perform Point Possible Step Instructions 0 1 Grader has automatically added your last name to the beginning of the Serama 8 2 0 3 Autofit the width of column B. 7 4 0 5 7 6 4 7 10 8 8 9 10 10 8 11 AutoFit the width of column Insert a function in coll ES to display the tom price based on the provided Inventory lookup information. Copy the function from cell Es domlough 13 to comic com E Apply Currency Number Format to column E. Insert an IF function in cell F5 to calculate the total dun. If the customer has chosen horre delivery, there is an additional delivery charge located in coll B25. Be sure to use appropriate relative and absolute coll references Copy the function from cell FS down through F13 to complete column F and apply Currency Number Format to column F. Insert the function in collH5 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 coll H14 to calculate the total of all monthly payments in column Hand apply Currency Number Format to column H. Insert a function in cell H18 to calculate the total number of orders based on entries in column A. Insert a function in cell H19 to calculate the lowest monthly payment in column H. Insert a function in coll H20 to calculate the average monthly payment in column H. Insert a function in cell H21 to calculate the highest monthly payment in column H. Insert a function in cell H22 to calculate the median monthly payment in column H. Apply Currency Number Format to the range H19.-22. Insert a footer with your name on the left side, the shoot name in the center, and the file name on the right side. 6 12 6 13 6 14 6 15 6 16 2 17 6 18 mon. As part of your daily, you create nel wordt oorspoon, and You are an manager for W.C. Hicks Appliances, local plane store dangery and Start Excel Download and open the feed Ex EONORA Insert a Pinction in costo display the bandoma Long Insert a function in CS to play the hom nomed bed on the provided inventory lookup Ex2919 Project Description: Exp19_Excel_Cho2_Cap_Appliances summary statistics Steps to Perform Point Possible Step Instructions 0 1 Grader has automatically added your last name to the beginning of the Serama 8 2 0 3 Autofit the width of column B. 7 4 0 5 7 6 4 7 10 8 8 9 10 10 8 11 AutoFit the width of column Insert a function in coll ES to display the tom price based on the provided Inventory lookup information. Copy the function from cell Es domlough 13 to comic com E Apply Currency Number Format to column E. Insert an IF function in cell F5 to calculate the total dun. If the customer has chosen horre delivery, there is an additional delivery charge located in coll B25. Be sure to use appropriate relative and absolute coll references Copy the function from cell FS down through F13 to complete column F and apply Currency Number Format to column F. Insert the function in collH5 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 coll H14 to calculate the total of all monthly payments in column Hand apply Currency Number Format to column H. Insert a function in cell H18 to calculate the total number of orders based on entries in column A. Insert a function in cell H19 to calculate the lowest monthly payment in column H. Insert a function in coll H20 to calculate the average monthly payment in column H. Insert a function in cell H21 to calculate the highest monthly payment in column H. Insert a function in cell H22 to calculate the median monthly payment in column H. Apply Currency Number Format to the range H19.-22. Insert a footer with your name on the left side, the shoot name in the center, and the file name on the right side. 6 12 6 13 6 14 6 15 6 16 2 17 6 18
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