Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Lecture Notes: Creating Charts and Tables in Excel for CS 101 Summer Section, Study notes of Microcomputers

West Virginia University (WVU)Microcomputers

These lecture notes cover the process of creating charts and tables in excel for the cs 101 summer section. Topics include selecting data series, arranging data, chart types, inserting and designing charts, adding labels and titles, and embedding charts. Additionally, creating tables, formatting, sorting, and filtering are discussed.

Typology: Study notes

Pre 2010

Uploaded on 07/30/2009

koofers-user-4dw
koofers-user-4dw 🇺🇸

10 documents

1 / 3

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CS 101 Summer Section
Tuesday, May 26, 2009
Lecture Notes
Announcements
oMyITLab Due Today
oMyITLab StudentID
oHomework 1 Due Friday
oHomework 2 Posted
Charts
oCreating a Chart
Specify Data Series
Arrange Data Based on Which Chart Will be Used
Don’t Include Totals and Individual Data Points on Same Chart
Select Range of Cells to Chart
Know Ahead of Time Which Cells You’ll Use in Your Chart
Selection Techniques on Page 98
To Select Nonadjacent Cells, Select the First Cell Then Hold Down
Ctrl While Selecting the Other Cells
Select Chart Type
Chart Types on Page 98
Column Compares Categories
Bar Shows Comparisons Between Independent Variables
Pie Shows Percentages of a Whole
Line Shows Changes in a Series Over Time
Doughnu
t
Compares How Multiple Series Contribute to Whole
Scatter Shows Correlation Between Two Sets of Values
In Charts Group on Insert Tab
oClick Chart Type, Then Click Subtype
oClick All Chart Types to Display Create Chart Dialog Box
oScroll Through All Chart Types and Select One to Use
Insert Chart and Designate Chart Location
Chart Will Appear on Current Worksheet
Change Location of Chart
oClick on Chart and Select to Display Chart Tools
oClick Move Chart in Location Group on Design Tab
oChoose Either “New Sheet” or “Object In” to Move Chart
Choose Chart Options
Notice We Now Have Design, Layout, & Format Tabs (p. 99)
pf3

Partial preview of the text

Download Lecture Notes: Creating Charts and Tables in Excel for CS 101 Summer Section and more Study notes Microcomputers in PDF only on Docsity!

CS 101 Summer Section

Tuesday, May 26, 2009

Lecture Notes

 Announcements o MyITLab Due Today o MyITLab StudentID o Homework 1 Due Friday o Homework 2 Posted  Charts o Creating a Chart  Specify Data Series  Arrange Data Based on Which Chart Will be Used  Don’t Include Totals and Individual Data Points on Same Chart  Select Range of Cells to Chart  Know Ahead of Time Which Cells You’ll Use in Your Chart  Selection Techniques on Page 98  To Select Nonadjacent Cells, Select the First Cell Then Hold Down Ctrl While Selecting the Other Cells  Select Chart Type  Chart Types on Page 98 Column Compares Categories Bar Shows Comparisons Between Independent Variables Pie Shows Percentages of a Whole Line Shows Changes in a Series Over Time Doughnu t Compares How Multiple Series Contribute to Whole Scatter Shows Correlation Between Two Sets of Values  In Charts Group on Insert Tab o Click Chart Type, Then Click Subtype o Click All Chart Types to Display Create Chart Dialog Box o Scroll Through All Chart Types and Select One to Use  Insert Chart and Designate Chart Location  Chart Will Appear on Current Worksheet  Change Location of Chart o Click on Chart and Select to Display Chart Tools o Click Move Chart in Location Group on Design Tab o Choose Either “New Sheet” or “Object In” to Move Chart  Choose Chart Options  Notice We Now Have Design, Layout, & Format Tabs (p. 99)

 Add Graphic o In Illustrations Section of Insert Tab, Select Where Graphic Will Come From o Search for and Insert Graphic o Size and Move Graphic on Chart as Desired  Change Chart Location and Size  To Move Around Worksheet, Click and Drag Chart  To Change Size, Click and Drag Sizing Handles o Modifying Charts  Change Chart Elements  Can Change Titles and Axes  Can Also Format Text  Format Chart  Can Either Go to Format Tab, or Right Click Chart for Formatting Options  Add Data Labels  Name of a Data Point  Select Chart, Then Click “Data Labels” in Labels Group on Layout Tab  Add Title  Chart Title -> Above Chart  Add Axis Labels  Axis Titles -> Use Any Option for Both Horizontal and Vertical  ALL CHARTS WILL NEED TITLE AND AXIS LABELS UNLESS TOLD OTHERWISE o Embedding Charts  Export to Other Applications  We Can Add Excel Objects into Other Applications  Select Chart & Click Copy (Right Click or Clipboard Group in Home Tab)  Select Appropriate Document and Click Paste  Changes in Data Will Update in New Application, Formatting Changes Will Not o Trend Lines  Used to Predict Future Values  To Create Trend Line, Select Trend Line in Analysis Group of Layout Tab  Good Trend Line Should Match Data and Predict Reasonable Value  Trend Line Properties  Chapter 4: Tables o Creating Tables  Select Range of Cells  Insert -> Table