Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?
by

1 Answer

Answer :

What kind of results are you looking for ? I.e. what are you comparing between test1 and test2 ? Also, I’m not sure I understand what are ‘value points’ ? And when you say ‘group all the students’ do you mean counts of students that got that level of score on the test?
by

Related questions

What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Description : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

What do you use to create a chart? 1) Pie Wizard 2) Excel Wizard 3) Data Wizard 4) Chart Wizard

Description : What do you use to create a chart? 1) Pie Wizard 2) Excel Wizard 3) Data Wizard 4) Chart Wizard

Last Answer : 4) Chart Wizard

What kind of graph should you use to compare the test grades of every student in the class?

Description : What kind of graph should you use to compare the test grades of every student in the class?

Last Answer : Scatter Plot 

If a bar chart showed that 4 students received an A on the test 3 students received a B and 1 student received a C the shortest bar on the chart would be for the B column.?

Description : If a bar chart showed that 4 students received an A on the test 3 students received a B and 1 student received a C the shortest bar on the chart would be for the B column.?

Last Answer : No, the shortest bar would be C

When making a chart in Excel, how do I put a heading at the top of the page?

Description : When making a chart in Excel, how do I put a heading at the top of the page?

Last Answer : Insert -> Header & Footer

How do I add a secondary x axis to a chart in excel 2008?

Description : How do I add a secondary x axis to a chart in excel 2008?

Last Answer : Click on the chart, then go to chart type, Custom Types, Line -Column on Two axes.

In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Description : In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Last Answer : (c) Text displayed at data points to indicate the specific category is called data label.

In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Description : In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Last Answer : c. A collection of related data

Which chart can be created in Excel a. Area b. Line c. Pie d. All of the above

Description : Which chart can be created in Excel a. Area b. Line c. Pie d. All of the above

Last Answer : d. All of the above

Which chart can be created in Excel a. Area b. Line c. Pie d. All of the above

Description : Which chart can be created in Excel a. Area b. Line c. Pie d. All of the above

Last Answer : d. All of the above

In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Description : In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Last Answer : c. A collection of related data

MS Excel Help: Calculate Amount of Time?

Description : MS Excel Help: Calculate Amount of Time?

Last Answer : If your timestamps are in columns A and B, I'd imagine this would do the trick: =B1-A1 and then make sure to set the cell format to time, showing the difference in minutes and seconds. Just tested with this: timestamp A ... = custom: dd/mm/yyyy hh:mm:ss) =B-A: 0:29:57 (cell format = custom: h:mm:ss)

How do I automatically add the date to a MS Excel cell?

Description : How do I automatically add the date to a MS Excel cell?

Last Answer : You would want a macro, or if you hit Ctrl+; it automatically puts in the current date in the selected cell, and you can add the called left message afterward If you want to do a macro, you can record ... need to edit the macro to work for each line. So it might be easier to use the Ctrl+; shortcut

How to track timings in MS Excel?

Description : How to track timings in MS Excel?

Last Answer : Use a Custom format of ‘hh:mm:ss.000’

How do you apply a linear curve fit in MS Excel?

Description : How do you apply a linear curve fit in MS Excel?

Last Answer : answer:Right click on one of the data points. Add Trendline… Select Linear for Trendline Regression Type Close A linear trend line should appear. (Excel 2010)

I have a MS Excel file with mutliple email adresses, some are dulplicates, is there an easy way to delete the duplicates in Excel?

Description : I have a MS Excel file with mutliple email adresses, some are dulplicates, is there an easy way to delete the duplicates in Excel?

Last Answer : Yes. You’ll need to create filters. In one of the tabs (I think tools) select auto filter. Then you can sort by the column with the email addresses. When you have duplicates, you can highlight and delete the rows you don’t need. Practice on a test file first. Hope this helps.

What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?

Description : What kind of documentation is allowed by MS - Excel default worksheet ( .xls) ?

Last Answer : MS-Excel allows creation of Worksheet (.xls) documents by default worksheet ( .xls ).

What does decrease decimal mean in ms excel?

Description : What does decrease decimal mean in ms excel?

Last Answer : It means round the number so that fewer digits after the decimalpoint are shown.

What is listed in a formula autocomplete list MS Excel?

Description : What is listed in a formula autocomplete list MS Excel?

Last Answer : A list of valid functions, names, and text strings that matchthe letters or trigger that you have begun to type. So if you typethe equals sign and then a letter, functions that start with ... letters, that list will shorten down,maintaining the ones that still match what you have typed sofar.

What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Description : What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Last Answer : Need answer

Where can I learn MS Excel for free?

Description : Where can I learn MS Excel for free?

Last Answer : You may learn MS excel for free at this web site "Microsoft Excel Training & Word 2007 Tutorial - Learn Free Office", the site address is: www.free-training-tutorial.com.

Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Description : Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Last Answer : Answer : B

The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Description : The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Last Answer : (C) Visicalc

In a modern newspaper house editing is done through computers only and the pages are made up on computers using software known as: a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Description : In a modern newspaper house editing is done through computers only and the pages are made up on computers using software known as: a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Last Answer : d) Quark Xpress

Computer software commonly used in a modern newspaper house for editing the copies is known as ---- a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Description : Computer software commonly used in a modern newspaper house for editing the copies is known as ---- a) Adobe Premier b) MS Word c) MS Excel d) Quark Xpress

Last Answer : d) Quark Xpress

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Description : Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Last Answer : a) Move to the previous worksheet in the workbook

In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Description : In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Last Answer : a) Ctrl + Page Down

In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Description : In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Last Answer : a) Ctrl + Shift + Down Arrow Key

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Description : In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Last Answer : c) File

Ms Excel version 5 was launched in: a) 1992 b) 1993 c) 1995 d) None of These

Description : Ms Excel version 5 was launched in: a) 1992 b) 1993 c) 1995 d) None of These

Last Answer : b) 1993

.docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Description : .docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Last Answer : c) MS Word

Slides prepares in: a) MS Word b) MS Power Point c) MS Excel d) None of These

Description : Slides prepares in: a) MS Word b) MS Power Point c) MS Excel d) None of These

Last Answer : a) Data Base Management System

Presentations made on: a) MS Word b) MS Excel c) MS Power Point d) None of These

Description : Presentations made on: a) MS Word b) MS Excel c) MS Power Point d) None of These

Last Answer : c) MS Power Point

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Description : Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Last Answer : PL/SQL

In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Description : In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Last Answer : Charts

Of the following, ____ is different from the group. a) Windows b) MS-Word c) MS-Excel d) MS-PowerPoint

Description : Of the following, ____ is different from the group.  a) Windows b) MS-Word c) MS-Excel d) MS-PowerPoint

Last Answer : Of the following, ____ is different from the group.  a) Windows b) MS-Word c) MS-Excel d) MS-PowerPoint

Find the odd one out A) MS -Excel B) Windows XP C) Linux D) DOS

Description : Find the odd one out A) MS -Excel B) Windows XP C) Linux D) DOS

Last Answer : Find the odd one out   MS -Excel 

Simplest way to convert a row into column in Excel?

Description : Simplest way to convert a row into column in Excel?

Last Answer : answer:Hi @Sassy009, welcome to ask-public! In Excel that is called Transpose. Here’s an explanation from Microsoft. Switch (transpose) columns and rows

Convert Excel cell data to a column header?

Description : Convert Excel cell data to a column header?

Last Answer : answer:From your question it's not entirely clear to me what you want to do. Obviously you want to differentiate one product (Product ID) from another. So, do you just want to change a listing that ... the Find text with , leaving you with only the product ID values. Was that what you wanted?

In Excel, how can I add a popup definition to each column header in the header row?

Description : In Excel, how can I add a popup definition to each column header in the header row?

Last Answer : I typically right click the cell and scroll down to select Add Comment. It will add a little red triangle in the upper right corner of the cell that one must click to read the comment. ... triangle that Excel puts in the upper left corner if it suspects some weird calculation result in the cell.

Excel Question: How can I take firstname, lastname in one column and separate into two columns?

Description : Excel Question: How can I take firstname, lastname in one column and separate into two columns?

Last Answer : answer:Assuming you have a space or comma between the first and last names, you can use Data / Text to Columns. (I'm still using Excel 2000, so your commands on a more recent version may be ... as space , or comma, or whatever it is. The text will be broken into separate columns automatically.

In an Excel worksheet does a column typically contain information that is similar to a list?

Description : In an Excel worksheet does a column typically contain information that is similar to a list?

Last Answer : Yes it does, like a field in a database.

How do I add 1.5 to a column in Excel?

Description : How do I add 1.5 to a column in Excel?

Last Answer : If you have a list of values in one column and want values thatare 1.5 higher in another you could have a formula to add them. Soif you had values in column A, say in cell B2 you could add 1.5 toA2 like this ... to the new one. If there is a formula in thecell, it will put +1.5 at the end of it.

How do I add 1.5 to a column in Excel?

Description : How do I add 1.5 to a column in Excel?

Last Answer : If you have a list of values in one column and want values thatare 1.5 higher in another you could have a formula to add them. Soif you had values in column A, say in cell B2 you could add 1.5 toA2 like this ... to the new one. If there is a formula in thecell, it will put +1.5 at the end of it.

If a bar chart consists of one or more hortizontal barswhat does a column chart consist of?

Description : If a bar chart consists of one or more hortizontal barswhat does a column chart consist of?

Last Answer : Feel Free to Answer

Cox chart is useful in the design of (A) Distillation column (B) Evaporator (C) Dryer (D) Crystallise

Description : Cox chart is useful in the design of (A) Distillation column (B) Evaporator (C) Dryer (D) Crystallise

Last Answer : (A) Distillation column