inst11 1 - Class 11.1: Tables and Graphs within Excel...

Info iconThis preview shows pages 1–16. Sign up to view the full content.

View Full Document Right Arrow Icon
Class 11.1: Tables and Graphs  within Excel Solving Problems Using Graphical Analysis
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Learning Objectives Learn some new Excel tricks Be able to edit graphs
Background image of page 2
Excel Tricks – Split Screen Usage: If you have a large column and want to simultaneously see the top and bottom. (Note: Also works with large rows of numbers.) Put the cursor here. It will turn into a double line. Left click and pull down.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Tricks – Split Screen Note the break. Independent sliders.
Background image of page 4
Excel Tricks – Jumping Rows Select first column: Cursor at top of 1 st column Shift-Ctrl-Down Arrow
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Tricks – Jumping Rows Press Ctrl Then select the next column Cursor at top of next column Shift-Ctrl-Down Arrow
Background image of page 6
The graph at  right shows  only y=5x.  I  would like to  add y=10x. Excel Tricks – Adding graph to an  existing graph 
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Select the  chart to  which you  wish to  add data. Excel Tricks – Adding data to an  existing graph 
Background image of page 8
Select  Chart  Source Excel Tricks – Adding data to an  existing graph 
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Tricks – Adding data to an  existing graph  =Sheet1!$C$1 =Sheet1!$A$2:$A$301 =Sheet1!$C$2:$C$301 The following automatically appear to describe the existing graph: Range
Background image of page 10
Excel Tricks – Adding data to an  existing graph  Left click Add
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Tricks – Adding data to an  existing graph  =Sheet1!$d$1 =Sheet1!$a$2:$a$301 =Sheet1!$d$2:$d$301 Enter the following: Left click OK.
Background image of page 12
Excel Tricks – Adding data to an  existing graph  The added data are graphed.
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Example Excel Problem Two-Dimensional  Projectile Motion with Drag
Background image of page 14
Learning Objectives Know the equation to compute the drag force on  an object due to air friction Apply Newton's Second Law and the relationship 
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 16
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/01/2009 for the course PSYC 300 taught by Professor Cambron during the Spring '08 term at Texas A&M.

Page1 / 40

inst11 1 - Class 11.1: Tables and Graphs within Excel...

This preview shows document pages 1 - 16. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online