Microsoft Excel

[Pages:40]Microsoft Excel

The basics for writing a chemistry lab using Excel 2007 (or whatever is on

this computer)

Overview

? Identifying the basics ? Entering Data ? Analyzing Data ? Other Cool Things ? Examples

EXPLORING THE BASICS

What are the basics of Excel?

? Each box is called a cell ? Cells are identified by a

letter and number ? Cells store data in

different forms

? Text ? Numbers

? Fraction ? Percentage

? Time ? Date

What are the basics of Excel?

? The bar where you type your information is called the formula bar

? Not only can you enter single bits of information, you can enter mathematical formulas

What are the basics of Excel?

? To move through the cells

? [tab] will move you to the right ? [shift][tab] will move you to the left ? [enter] will move you down ? [shift][enter] will move you up

? There are several different sheets in one document. You can use these to organize your data or separate your experiments.

INPUTTING DATA

How do I enter data?

? Simply type in your data as you see on your data tables ? excel will auto format the type of data inputted.

? Data shown is the average amount of money each household spends on the stated item within a region

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download