# We Helped With This Excel Programming Homework: Have A Similar One?

SOLVED
Category Programming Excel College Solved Excel Assignment

## Short Assignment Requirements

I have an assignment due which contains 2 chapters. I will attach the two chapters. Please make sure the instructions match the spreadsheet. I will have to submit the excel spreadsheet for chapter 5 once I submit my order. Only 3 spaces to download files.

## Assignment Description

Project Description:

In this project, you will use a PMT function to calculate a value and then use it in a two-variable data table. You will create named ranges and use them in formulas.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download, save, and open the workbook named go16_xl_ch04_grader_4e_hw.xlsx. 0.000 2 Display the Condo Purchase worksheet. In cell B5, insert the PMT function using the data from the range B2:B5—be sure to divide the interest rate by 12 multiply the years by 12 and display the payment as a positive number. The result, \$6,598.44, is larger than the maximum desired payment of \$6,250. 10.000 3 Use Goal Seek to change the amount of the loan so that the payment is \$6,250. Then, in cell A7, type Option #1 Reduce the Loan To cell A1, apply the Title cell style, and then Copy the format from cell A1 to cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A8. In cell B2, type 615000 to restore the original loan amount. 7.000 4 Use Goal Seek to change the period of the loan (of the original data) so that the payment is \$6,250. Then, in cell A13, type Option #2 Increase Years Format the cell the same as cell A7. Copy the range A2:B5, and then Paste the Values & Number Formatting to cell A14. Display the value in cell B15 with two decimal places, and then in cell B3, type 10 to restore the original value. Save your workbook. 4.000 5 Display the Payment Table worksheet, in the range A2:B4, enter the following row titles and data. Amount of Loan               \$615,000 Period (months)              120 Interest Rate (per year)  5.25% 5.000 6 In cell C8, type 60—the number of months in a 5-year loan. In D8, type 120—the number of months in a 10-year loan. Fill the series through cell H8. Apply Bold and Center to the range C8:H8. 10.000 7 Beginning in cell B9, enter varying interest rates in decrements of 0.5% beginning with 7.5% and ending with 4.0% If necessary, format all the interest rates with two decimal places, and then apply Bold and Center to the range B9:B16. 10.000 8 In cell B8, enter a PMT function using the information in cells B2:B4. Be sure that you convert the interest rate to a monthly rate and that the result displays as a positive number. 5.000 9 Create a Data table in the range B8:H16 using the information in cells B2:B4 in which the Row input cell is the Period and the Column input cell is the Interest rate. Copy the format from cell B8 to the results in the data table. Format cell D16 with the Note cell style as the payment option that is close to but less than \$6,250 per month. 10.000 10 Display the Advertising Costs by Quarter worksheet, and then apply the Currency [0] cell style to the range B6:E6 and to the range B18:E18. Apply the Comma [0] cell style to the range B7:E17, and then apply the Total cell style to the range B18:E18. 9.000 11 Name the following ranges: B6:E10 Newspaper_Costs B11:E14 Digital_Costs B15:E16 Magazine_Costs B17:E17 Billboard_Costs Insert a new row 15. In cell A15, type Business Podcasts In cell B15, type 12500 In cell C15, type 11525 In cell D15, type 14455 In cell E15, type 13009 7.000 12 Display the Name Manager, click Digital_Costs, and then change cell E14 to E15. Select the Billboard_Costs and then Edit the name to Outdoor_Costs Save your workbook. 7.000 13 Display the Annual Advertising Costs sheet. In cell B5, type =sum(N and sum the values using the appropriate range name in the displayed list of functions. Repeat for the other named ranges. From the Formulas tab, in the Function Library group, use AutoSum to sum all the costs. Apply Currency [0], Comma [0], and Total cell styles to the appropriate cells. 10.000 14 In the sheet tab row, right-click any sheet tab, and then click Select All Sheets. Display the Page Setup dialog box, click the Margins tab, and then under Center on page, click Horizontally. Click the Header/Footer tab, click Custom Footer, and then in the Left section, insert the File Name. Click OK two times. Ungroup the sheets, display the Payment Table sheet. Set the Orientation of this sheet to Landscape and set the Scale to 85%. 5.000 15 Display Backstage view, click Show All Properties. On the list of Properties, in the Tags box, type payment table, advertising costs In the Subject box, type your course name and section #. Under Related People, be sure that your name displays—edit if necessary. On the left, click Print. Under Settings, click the Print Active Sheets arrow, and then click Print Entire Workbook. At the bottom of the window, click Next Page to scroll through the worksheets. On the left, click Save. 1.000 16 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Condo Purchase, Payment Table, Advertising Costs by Quarter, Annual Advertising Costs. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0.000 Total Points 100.000

## Assignment Description

Project Description:

In this project, you will you will edit a worksheet, with data that has been sorted, filtered, and grouped that analyzes Delivery Modes for programs at Laurel College.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download, save, and open the workbook named go16_xl_ch05_grader_5f_hw.xlsx. Save it in your Excel Chapter 5 folder as Lastname_Firstname_5F_Career_Programs.xlsx 0.000 2 On the Main-East-West worksheet, insert a table using the range A1:J40. Apply Light Green, Table Style Light 21. 12.000 3 Sort the values in the Campus column using a custom list in the following order: Main, East, and then West. Add a second level sort by Division and a third level sort by Program Name, both in ascending order. 15.000 4 On the Delivery Mode Comparison worksheet, copy the range A6:G7. Paste it in cell A1, change the title in cell A1 to Criteria and then name the range A2:G3 Criteria. 15.000 5 Copy the range A1:G2, and paste it into cell A36. Change the title in cell A36 to Online-Hybrid Delivery Mode and then name the range A37:G37 Extract. Select the range A7:G34, and then name this range Database. 15.000 6 Create an advanced filter that will place in the extract area the records from the Database range in which Online is the primary delivery mode and Hybrid is the secondary delivery mode. 12.000 7 Display the Stipends by Division worksheet. Sort the data in ascending order first by Division and then by Program Chair Stipend. 10.000 8 Apply subtotals to the Program Chair Stipend column at each change in Division. AutoFit columns C: D and then collapse the outline so that the Level 2 summary information is displayed. 8.000 9 Group all three worksheets. Insert a footer in the left section that includes the File Name field, and in the right section, insert the Sheet Name field. Center the worksheets Horizontally, and then set the Width and Height to 1 page. 11.000 10 Show all the properties, and then as the Tags, type career programs As the Subject, type your course name and section number. Be sure your name displays as the Author. 2.000 11 Save the workbook. Ensure that the workbook contains the following sheet tabs, in this order: Main-East-West, Delivery Mode Comparison, and Stipends by Division. Close the workbook, and then exit Excel. Submit the workbook as directed. 0.000 Total Points 100.000

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

 Regular homework \$20 - \$150 Advanced homework \$100 - \$300 Group project or a report \$200 - \$500 Mid-term or final project \$200 - \$800 Live exam help \$100 - \$300 Full thesis \$1000 - \$3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for \$100, we could tell that the price is \$200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On