Question: 2 Rename Sheet 1 FlexPay. Hint: Double-click the sheet name tab to rename the worksheet. 3 4 Type Flex Pay Calculator in cel A1, and

2 Rename Sheet 1 FlexPay. Hint: Double-click the sheet name tab to rename the worksheet. 3 4 Type Flex Pay Calculator in cel A1, and then merge and center the title on the first row in the range A1:01. Apply bold, 20 ot.font size, Blue, Accent 1, font color. Merge and center the range A2:C2. type Inputs, and apply Thick Outside Borders. Note, Mac users, apply Thick Box Border. Type APR and # of payments in the range A3:A4. Type 1.75% in cell B3 and 36 in cell B4. Merge and center the range A6:06, type Outputs, and apply Thick Outside Borders. Type Model in cell A7. Price in cell B7, and Payment in cell C7. 5 6 7 8 9 Type iphone x in cel AB. Samsung Galaxy in cell A9, and LG V30 in cell A10. Enter the corresponding prices 949.799, and 650 in the range BB:B10 and apply Currency Number Format. Resize column A as needed to display all text. In cell CB, enter a PMT function to calculate the monthly flex payment for the first option. Be sure to use the appropriate absolute, relative, or mixed cell references. Use the fill handle to copy the function down through ceil C10. Make sure each of the monthly flex payments is a positive value. Type Highest payment. Average payment, and Lowest payment in the range A12:A14. In cell B12, use the MAX function to calculate the highest flex payment, in cell B13, use the AVERAGE function to calculate the average flex payment and in cell B14, use the MIN function to calculate the lowest flex payment. Insert a footer with your name on the left side, the sheet name in the center, and the file name code on the right side of the worksheet. 10 11 12 13 Save the workbook. Close the workbook and then exot Excel. Submit the workbook as directed

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 General Management Questions!

XYZ, Inc. is considering a 5-year project. The production will require net working capital investments each year equal to 15% of the projected sales. Total fixed costs are $1,350,000 per year,...

Step Instructions Point Value 1 Start Excel. Download and open the file named Exp 1 9 _ Excel _ Ch 0 2 _ Assessment _ SmartPhone.xlsx . Grader has automatically added your last name to the beginning...

Steps to Perform: Step Instructions Points Possible 1 0 2 4 3 8 4 10 5 6 6 12 7 9 Start Excel. Download and open the file named Exp19_Excel_Cho2_Assessment_SmartPhone.xlsx. Grader has automatically...

Design References Review Layout Mailings View 21 A Arbore TIL A A AaBbCcD Aa > Emphasis Heading 1 Styles Pane A U o momeny payment Comment reports top three Smartphones Gin, you WOULD BE work for...

I am really stuck on this problem can someone please help me? You have just graduated from college and before beginning your first professional job, you would like to purchase a new smartphone. You...

how do i do the first sheet ?? Tom is evaluating his monthly bills to determine the effect of changes he could potentially make to his monthly expenses to help him pay off his loan from his rich...

Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then...

Hello wanted to know if someone could help me with an Excel assignment. Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete...

need help don't know excel. thank you. Personal Budget Exercise ? MS Excel Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete...

Please provide all steps. Exp19_Excel_Ch01_Cap_Ticket_Sales Project Description: You work in the accounting division at Sugarhouse District Theatre, where touring Broadway plays and musicals are...

Personal Budget Exercise ? MS Excel (These instructions are also attached here as a Word document) Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this...

A special consumer index has increased 100% during the past 10 years. If the index is now 360, what was it 10 years ago?

Explain why the efficient markets hypothesis states that analysts should not be able to predict future stock returns based on recurring patterns observed in past stock returns.

Which of the following is a true statement living all property to the surviving spouse maximize the murder of deduction and therefore minimize the total transfer taxes on the state of both spouses...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...