Create and format charts that display your overall grade

Assignment Help Business Management

Reference no: EM13983255

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: Open this Excel workbook and save the worksheet as "FirstInital_LastName_ChartsIPA03_.xlsx." 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 cluster cylinder column.

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. Select the Cluster Cylinder Column chart, use the Cut command, and then paste a copy of the chart in cell A31.

Create a second chart from the Design tab. This time, select a Bar chart. Add a chart title to both charts using the Layout Style

1. Label the Cluster Cylinder Column chart CTU Grade Average, and label the bar chart "Your Name" Grade Average.

You realize that a score is missing for your IP5 assignment in IT254. Modify cell F6, and add the value of 81.

Note: Look at your charts. This action will change your averages.

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.

Save the workbook. Close the workbook and then exit Excel. Submit the Excel spreadsheet.

Reference no: EM13983255

Questions Cloud

Analysing the effects of changes organisations : What were the external and internal forces that drove that change? How did organisation leaders help facilitate change within the organisation?

Explain the function of a reinforcing contingency : Explain the relationship between aversive stimuli and negative reinforcement. Explain the function of a reinforcing contingency

Discussing the early stages of development : We have been discussing the early stages of development. Choose a topic that we have already touched on in class (Freudian theory, Attachment theory, transitional phenomena, dream interpretation, or another of your choosing)

Calculate the quick ratio and net working capital of firm : Calculate the current ratio, quick ratio, and net working capital of the firm. What is your opinion about the ratios and cash on hand? Why?

Create and format charts that display your overall grade : 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.

What is the total torque about given point : What is the total torque about point P?

Discuss the law of conservation of energy : Discuss the law of conservation of energy with an explanation of how this law applies to energy use and energy conversions.

Solve 1storder differential equation using analytical method : Analyse engineering problems and formulate mathematical model using first order differential equations - Solve second order homogeneous and non-homogenous differential equations.

Calculate the lattice energy of magnesium oxide : The first and second electron affinities of Oxygen are -141KJ/mol and +844kJ/mol respectively. Thestardard hear of formation ofMgO(s) is -602kJ/mol. Calculate the Lattice Energy of magnesium oxide based on the above given information.

User Account

All Pages