inst09.1 - Class 9.1: Introduction to Excel Spread Sheet...

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

View Full Document Right Arrow Icon
Class 9.1: Introduction to Excel Spread Sheet Graphs Solver
Background image of page 1

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

View Full DocumentRight Arrow Icon
RAT 1 Open Book
Background image of page 2
Learning Objectives Learn how to enter data into Excel Learn how to copy and fill Learn to enter and use formulas Understand the difference between absolute and relative addresses
Background image of page 3

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

View Full DocumentRight Arrow Icon
Learning Objectives Prepare x-y scatter graphs in Excel Be able to set title, label axes, and prepare legends for graphs Be able to edit graphs and figures Learn to solve problems using Goal Seek and Solver
Background image of page 4
The Basics
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 as a Spreadsheet Definition: A spreadsheet is a computer program that organizes data into rows and columns, for computing desired calculations and making overall adjustments based on new data.
Background image of page 6
Spreadsheets can contain many types of data. Numbers Text Dates Charts Equations Pictures Data Types
Background image of page 7

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

View Full DocumentRight Arrow Icon
Automatic Update Numerical data is dynamically linked. Therefore, changing the value of one cell propagates the changes throughout the spreadsheet. Notice the effect of changing one cell on the spreadsheet.
Background image of page 8
Addressing Columns are designated by alphabetical values such as A, B, C …. Rows are designated by 1, 2, 3 …. Individual cells are designated by ordered pairs containing the row and column designation such as A1,C2, B15 …. C2
Background image of page 9

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

View Full DocumentRight Arrow Icon
Entering Data To enter data, move the mouse pointer to the cell into which you would like to enter data. Left click the mouse Enter the data
Background image of page 10
Formulas The formula can perform mathematical operations using data from other cells.
Background image of page 11

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

View Full DocumentRight Arrow Icon
Entering Formulas To enter a formula into a cell: Select the cell Type an equal sign(=) Followed by the formula. Formula may include values in other cells. These are referenced by the cell address
Background image of page 12
Mathematical Operators + addition - subtraction * multiplication / division ^ exponentiation ( ) group operations MANY, MANY built-in (intrinsic) functions: pi, sin, cos, abs, sqrt, mean, median, mode, stdev, . . . . . .
Background image of page 13

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

View Full DocumentRight Arrow Icon
Fill Down Pointing the mouse pointer to the lower right hand handle of a selected cell and dragging down address.
Background image of page 14
Image of page 15
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 / 57

inst09.1 - Class 9.1: Introduction to Excel Spread Sheet...

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

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