Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

How It Works
Order Now
glass
pen
clip
papers
heaphones

Liberty University Computing the Monthly Payment Amount Excel Task

Business Finance, Liberty University

Business Finance, Liberty University

Liberty University Computing the Monthly Payment Amount Excel Task

Description

  1. On the GuestList sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Use error checking as needed and/or display the formulas on-screen for easy viewing. 
    1. In the Name Tag column, modify the formula to display the guest name in this format: BILL SMITH Hint: There are multiple errors in this formula. Fix the formula in cell D10 and then copy it to the other cells in the column. 
    2. Correct the function used in cell A3 to calculate the sum of the values in the NumAttending column. 
    3. Correct the function used in cell A4 to count the number of values in the Street column.
    4. Correct the function used in cell A5 to count the number of blank cells in the NumAttending column.
    5. Correct the function used in cell A6 to display the largest value in the NumAttending column.
    6. Correct the function used in cell A7 to display the average value in the NumAttending column.
  2. On the Shopping List sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Many of the problems on this worksheet can be solved by creating named ranges or using a name that already exists.
    1. The formula in cell B2 uses the wrong function. 
    2. The formulas in cells A9:A23 reference a named range that doesn’t exist. There is more than one correct way to fix this problem using the cell range A5:H18 on the Places to Shop worksheet. You can create the named range referenced in the formulas, or you can change the function arguments to reference the cell range instead. 
    3. The formula in cell H9 results in the correct value. However, the workbook author copied this formula to the remaining cells in the column and those values are definitely not correct! Fix the formula in cell H9 and copy it to cells H10:H23. Hint: Notice that cell H8 is named Tax. 
  3. If you’ve fixed the formulas in cells H9:H23 correctly, the formulas in cells I9:I23 and G5 should calculate properly now. However, the formulas in cells G2:G4 still have errors that need to be fixed. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing. 
    1. Correct the function used in cell G2 to average value of the Cost column. 
    2. Correct the function used in cell G3 to display the largest value in the Cost column. 
    3. Correct the function used in cell G4 to display the smallest value in the Cost column. 
  4. On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light purple color. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing. 
    1. Cell B2 should use a function that will update the date to the current date every time the workbook is opened. 
    2. Cell B4 references a named range that doesn’t exist. It should reference cell A4 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead. 
    3. Cell B5 references a named range that doesn’t exist. It should reference cell A3 on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead. 
    4. Cell B8 is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet + the total Costfor purchasing and mailing invitations on the Guest List sheet is greater than the available cash. The cell should display yesor no. 
    5. Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping List sheet + the total Costfor purchasing and mailing invitations on the Guest List sheet – the cash available) if the value in cell B8 is yes. If the value in cell B8 is not yes, the cell should display 0. 
    6. Add a formula to cell B12 to calculate the monthly loan payment based on the information in cells B9:B11. Use a negative number for the Pv argument.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Writers Hero only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Writers Hero are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Writers Hero is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Writers hero, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.

Menu
Free resources
 
Dissertation help
 
Email
support@writeship.com  
Writershero.org ©2019 All rights reserved. Terms of use | Privacy Policy