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

  Write a program that reads in an integer

Write a program that reads in an integer, and breaks it into a sequence of individual digits. For example, the input 16384 is displayed as 1 6 3 8 4 You may assume that the input has no more than five digits and is not negative

  Elements corresponding to the inorder sequence

Suppose that you are given two sequences of elements corresponding to the inorder sequence and the preorder sequence. Prove that it is possible to reconstruct a unique binary tree .

  Examine each of the principles discussed

Examine each of the principles discussed in Sec. 2.1.4 and tell whether they are so important (assuming that high performance is still desired).

  What are the pros and cons of sparklines versus

question 1 what are the pros and cons of sparklines vs. charts?question 2 do you prefer using the datasheet view or the

  Create an application predict size of population organisms

Create an application that will predict the approximate size of the population of organisms. The user should select or enter the starting number of organisms in a combo box, enter the average daily population increase(as a percentage) in a text bo..

  Design a remote access control policy for richman

Richman Investments is an investment and consulting firm. The company wants to expand its business operations both in the U.S. and in foreign countries. It intends to eventually have 10,000 employees in 20 countries.

  Network consultation for designit

Network Consultation for DesignIT

  Class polygon which draws a hexagon for a set of numbers

Write a class Polygon which draws a hexagon for a set of numbers given by the user. You must only use method drawLine of class Graphics (other fill or draw methods won't be accepted).

  Write a recursive method

public static boolean isSorted(List l) Write a recursive method that returns true if a linked list is sorted (nondecreasing) order and returns false otherwise. An empty list is considered to be sorted.

  What are the five different approaches to risk

What are the five different approaches to risk? What are the pros and cons of each strategy? Support your answer with solid reasoning class is cmgt 400

  Write a function that displays the prompt string

Write a function that displays the prompt string, followed by a space, reads a floating point number in, and returns it.

  Write a fragment of code that assigns the smallest of x y z

Given the integer variables x , y , and z , write a fragment of code that assigns the smallest of x , y , and z to another integer variable min . Assume that all the variables have already been declared and that x , y , and z have been assigned va..

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