inst11 1

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

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

Class 11.1: Tables and Graphs  within Excel Solving Problems Using Graphical Analysis

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

View Full Document
Learning Objectives Learn some new Excel tricks Be able to edit graphs
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.

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

View Full Document
Excel Tricks – Split Screen Note the break. Independent sliders.
Excel Tricks – Jumping Rows Select first column: Cursor at top of 1 st column Shift-Ctrl-Down Arrow

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

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

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

View Full Document
Select the  chart to  which you  wish to  add data. Excel Tricks – Adding data to an  existing graph
Select  Chart  Source Excel Tricks – Adding data to an  existing graph

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

View Full Document
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
Excel Tricks – Adding data to an  existing graph  Left click Add

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

View Full Document
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.
Excel Tricks – Adding data to an  existing graph  The added data are graphed.

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

View Full Document
Example Excel Problem Two-Dimensional  Projectile Motion with Drag
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

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

View Full Document
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
Ask a homework question - tutors are online