Liberty BUSI 201 Assignment 6 Excel 2016 Fix It 3.6 Answers Complete Solutions
Complete many different versions to get an A on your grade!
Download it for more and ace on your assignments!
Fix It 3.6
4. On the Shopping List sheet, check all the formulas. Cells to check are filled with the light orange 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. a. The formula in cell B2 uses the wrong function.
b. 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.
c. 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.
STATUS
5. If you’ve fixed the formulas in cells H9:H23 correctly, the formulas in cells I9:I23 and G5 should be 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.
6. On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light orange color. Hint: Use error checking as needed and/or display the formulas on-screen for easy viewing. a. Cell B2 should use a function that will update the date to the current date every time the workbook is opened.
d. Cell B8 is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet + the total Cost for purchasing and mailing invitations on the Guest List sheet is greater than the available cash. The cell should display yes or no.
e. Add a formula to cell B9 to calculate the amount to borrow (total Cost with tax on the Shopping List sheet + the total Cost for 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.
f. 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.
7. Save and close the workbook.
8. Upload and save your project file.
9. Submit project for grading.