Create and format charts that display overall grade

Assignment Help Basic Computer Science
Reference no: EM13760088

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: EM13760088

Questions Cloud

Write a paper on dun and bradstreets key business ratio : This assignment focuses on Dun and Bradstreet's key business ratio analysis,a current financial situation analysis, and strategy development.
Determine the funds received and use the text to column : In this project, you will be assigned the task to record money received for a school fundraiser and create an Excel spreadsheet to record your receipts. You will determine the funds received and use the text to column feature
Find a press release from the board of governors : Find a press release from the Board of Governors of the Federal Reserve System, dated December 16, 2009, which discusses the decisions of the Federal Open Market Committee (FOMC) for that date.
Data protection of a company : As the CIO of a company engaged in business today, one of the main areas of focus is data protection. Discuss the key data protection points that must be taken into consideration prior to a strategy plan and policy being established for a company.
Create and format charts that display overall grade : 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.
Modern fires and legacy fires : Include in your discussion a response to the following questions in regard to both the modern and legacy fire.
What is strength message and strength-oriented action mean : What do the terms ‘strength message' and ‘strength-oriented action' mean? What evidence do you see of this concept played out in your local school or organizational setting?
Outline the main features of a global mindset : You are manager of a district that has just hired several recent university and college graduates. Most of these people are starting their first full-time job, although most or all have held part-time and summer positions in the past.
Define a business process and an example : Define a business process and an example - Compare book's methodology to the methodology you found in your research. (Can use to different methodologies to compare not in text book).

Reviews

Write a Review

Basic Computer Science Questions & Answers

  What is the output from the following c++ code fragment

What is the output from the following C++ code fragment

  Compute the cost per equivalent unit for materials

Micro Labs' September 30th general ledger showed a balance of $634,500 in work-in process inventory. $206,500 of the balance was direct materials.

  Describe a violation of opsec principles

Describe a violation of OPSEC principles that plays a major role in the plot of a movie you have seen, then describe briefly how the 5 step process.

  Write a create table statement that recreastes the table

write a create table statement that recreastes the table, this time with a unique constraint that prevents an individual from being a memeber in the same group twice.

  City number two

City Number Two

  How many pages does a process have

A machine has a 32 bit virtual address space and a 16kb page size. It has 1gb of physical memory. How many pages does a process have? How many bytes are needed for a page table, assuming 4 control bits and that disk addresses are stored elsewhere?

  Use collaboration technologies

Summarize the main reason(s) that prompted Isuzu Australia Limited (IAL) to use collaboration technologies.

  Explain the characteristics of value-type variables

Briefly explain the characteristics of value-type variables that are supported in the C# programming language.

  Describe four different kinds of wireless technologies in a

bull discuss four different types of wireless technologies in a 350- to 700-word paper in apa format.bull describe the

  What is the size of a char and a string

What are the sizes in memory of other data types in C++? I mean, I know that a double is 8 bytes and an int is 4 bytes. What is the size of a Char and a String?

  Show by induction

Show by induction that n^5- n is divisible by 5 for all n ? 0.

  Create a japplet that contains a jlabel and jbutton.

Create a JApplet that contains a JLabel and JButton. You'll create a JButton that will automatically change font typeface, style, and size when clicked by the user. Change the font typeface, style, and size on the JLabel.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd