Question: Spreadsheet One
In this project, you will create and format charts that display your overall grade average for the courses that you are currently taking. You will create and format a 2-D column chart and a 3-D chart.
Perform the following tasks: 1. Open FILE U3IP and save the worksheet as "FirstInital_LastName_ChartsIPA03_.xlsx."(SEE ATTACHED DOCUMENT)
2. Select cell range A5:A8 and G5:G8, using the control feature to select G5:G8, and then click the Insert tab select the Column tab, choose the 3-D Column.
3. Select a style from the Design tab and then format the all courses (on the chart) with the fill color of Olive Green, Accent 3.
4. Select the Cluster Cylinder Column chart, use the Cut command, and then paste a copy of the chart in cell A31.
5. Use the same range in 2 to create a second chart from the Design tab. This time, select a Bar chart.
6. Add a chart title to both charts using the Layout Style 1. Label the 3D Column chart CTU Grade Average, and label the bar chart "Your Name" Grade Average.
7. You realize that a score is missing for your IP5 assignment in IT254. Modify cell F6, and add the value of 70.
• Note: Look at your charts. This action will change your averages.
8. Prepare the worksheet for printing by changing the orientation to Landscape. Go to File and Print preview and adjust the sheet to Fit All Columns on One Page if it is not set in Page Setup.
9. Save the workbook. Close the workbook and then exit Excel.
Spreadsheet Two: In this project, you will determine what core courses that are required to complete your degree in Information Systems Management. You are trying to determine which classes will be offered and how much longer it will take you to complete your degree. Once you complete your pivot table and chart, you will now be able to visually see what courses are available and which semester offers the most courses that you will need to successfully graduate.
To complete the assignment, perform the following tasks:
1. Open FILE U4IP and save the workbook as "FirstInital_LastName_PivotIPA04_.xlsx."(SEE ATTACHED DOCUMENT)
2. Highlight the entire data set, and insert a pivot table on a new worksheet.
• For more information on how to create a pivot table, click here.
3. Sort the pivot table as follows:
• Move Student level to the Column level.
• Move the Year to Values, change your values to count instead of sum.
• Move the Course to Row Label.
4. Insert a Column chart. Select Chart Layout 3, and also change your chart to design to style 2.
5. Change the title of your chart to "Course Availability".
6. Name the worksheet as "Course Availability," and save your document as "FirstInitial_LastName_PivotIPA04_solution."
7. Return to the Data sheet, highlight all the data, and click on Insert a pivot chart on a new worksheet.
• For more information on how to create a pivot chart, click here.
8. Sort the pivot chart as follows:
• Filter the Year.
• Move Courses to Axis Fields.
• Move the Count of Student to Value.
9. Change your chart type to columns if the type is not columns and choose a style from the design tab. Insert the name "Course Overview" as your title.
10. Add two more courses at the end of the list and adjust your new chart to include the two courses.
11. Rename the worksheet to "Course Overview."
12. Save the workbook. Close the workbook and then exit Excel.
Spreadsheet Three: In this project, you will realize that you really need to invest in a new computer to complete course assignments for the school's use. You will create a worksheet, use the PMT function, and format a worksheet to show a comparison of two electronic computers that you are interested in purchasing. You will make a comparison of the two items and determine which one is feasible to purchase.
• The Excel PMT function is used to calculate the payment for a loan based on constant payments and a constant interest rate.
To complete this assignment, perform the following tasks:
1. Data has been provided for you to generate a payment for each of the two products to help determine which product is feasible for you to purchase for school purposes. Open FILE U5_IP to access the data.(SEE ATTACHED DOCUMENT)
2. The loan parameters have been entered into the worksheet. Click in cells B8 and E8 to calculate the amount to finance as Price - down payment - rebate.
3. Calculate the payment on B10 and E10.
• Hint: Click Insert function and select PMT for payment.
4. Save the workbook as "FirstInitial_LastName_Purchase_solution.xlsx"
5. Merge and center the titles in Cells A1:E1. Format your worksheet by including color as well as providing an appropriate clip art to accent the document.
6. Indent the content in cells A4:A9 and show the Payment amount in font size 14.
7. Indent the content in cells D4:D9 and show the Payment amount in font size 14.
8. Save the School Computer Purchase Analysis spreadsheet. Close the workbook and then exit Excel.
Information related to above question is enclosed below:
Attachment:- Files.rar