{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

inst09.1

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

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

Class 9.1: Introduction to Excel Spread Sheet Graphs Solver

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

View Full Document
RAT 1 Open Book
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

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

View Full Document
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
The Basics

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

View Full Document
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.
Spreadsheets can contain many types of data. Numbers Text Dates Charts Equations Pictures Data Types

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

View Full Document
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.
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

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

View Full Document
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
Formulas The formula can perform mathematical operations using data from other cells.

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

View Full Document
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
Mathematical Operators + addition - subtraction * multiplication / division ^ exponentiation ( ) group operations MANY, MANY built-in (intrinsic) functions: pi, sin, cos, abs, sqrt, mean, median, mode, stdev, . . . . . .

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

View Full Document
Fill Down Pointing the mouse pointer to the lower right hand handle of a selected cell and dragging down address.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online