working with excel

Post on 10-Feb-2016

25 Views

Category:

Documents

1 Downloads

Preview:

Click to see full reader

DESCRIPTION

Working With Excel. Coin Density. Calculate Density. We are going to select the data you need to use. From the data table, copy and paste the lines that you need into a new spread sheet. PAY ATTENTION TO THE DATES!! MAKE SURE TO COPY THE ENTIRE LINE!! COPY THE CATEGORIES TOO!!. - PowerPoint PPT Presentation

TRANSCRIPT

Working With Excel

Coin Density

Calculate Density

• We are going to select the data you need to use. – From the data table, copy

and paste the lines that you need into a new spread sheet. • PAY ATTENTION TO THE

DATES!!• MAKE SURE TO COPY THE

ENTIRE LINE!!• COPY THE CATEGORIES

TOO!!

• Add title for Column ‘E’

• What are the units?

• We’re going to enter the equation for Density

• Use the format: =C2/D2• Press ‘enter’ • The box should now

show a number value

• Raise your hand if this hasn’t worked

• Click on lower right side of the box you just entered the equation in.

• Drag down while holding down the mouse button.

What do we do with our chart?

• Now we know the density of the pennies that we’re using in the project.

• You are going to use these tables in your reports. – You will copy and paste them into your written

papers.

Copy from Excel, paste into Word

top related