Question

А B D Question 1 -- Stacy's Travel Agency 2 3 8 Instructions 4. You are an agent at a local travel agency. Your manager has asked you to track your sales of next winter's holiday packages. For each package, customers can schoose whether or not to include a flight in the package. For each sale, an initial down payment of 20% of the total package cost is required. 6 Customers can pay the remainder of their balance owing using a monthly payment plan for one year with a standard annual interest rate applied 7 Make sure you spot-check your work to be sure your formulas and functions are working correctly as you copy them! 9. Always use appropriate relative and/or absolute cell references for every function you build in the first row of each column, copy it down for all customers. 10 a) Assign the name Packages to range A40:044. 11 ) Use a date function to display the current date in cell B25. 12 a For the first customer in row 29, insert an appropriate function to display or calculate the following Cell E29 - the package cost, based on the package chosen. Cell F29 the flight cost, based on the package chosen Cell G29 - the total cost of the package (hint: the flight cost is only included in the total package cost IE the customer needs a flight), Cell H29 - the amount of the down payment required. Cell 129 - the balance owing, which is the difference between the total package cost and the down payment paid. Cell 129 - the client's monthly payment (hint read the question carefully the information you need is in the question) 19 d) After copying your functions down each column for all customers, use a function to calculate the totals on row 37 for columns E through 20 e) Apply accounting format with 2 decimals to all monetary values in rows 29 to 37. Apply the Top and Double Bottom Border style to the range 37:137 2. Complete the Summary Statistics section (cells 640.644) using appropriate functions Format the monetary values to be currency format with O decimals. 13 14 15 16 17 18

please disregard the excel question

Answer 1