Assignment # 8 Working with a Spreadsheet

Synopsis - Samples - Tips - Tutorials

Synopsis:

Create a survey and build a chart (Sample: favorite candy) using Microsoft Excel or another spreadsheet.

Complete the Picnic Activity using formulas to add, subtract, and multiply.

Use Excel or a spreadsheet to complete this.
Objective: Learn the basics of a spreadsheet.

 

Samples:

 

 

 

 

 

Tips: Think logically, try a few simple sum formulas.  Don't forget the fill right, left, and down option, saves time.

 

Tutorials:

Concept 1: Spreadsheets do math, they add, subtract, multiply and divide.

Concept 2: Spreadsheets can use words too.

Concept 3: Spreadsheets can perform math functions automatically by using formulas.

Concept 4: Spreadsheets can make graphs and charts.

Spreadsheets are made up of cells.  
The columns across the top are letters, the rows down the side are numbers.  
Cells are referred to by the letter followed by the number, ex: A1, C4.

The Basics:

1. Cells can be resized - Format Menu>Row Height or Column Width

Select the cells you want to act on by clicking and dragging on them.

2. Cells can have text - Click in the cell and type, your words will appear in a box like the one below which will be above the cell grid.

3. Cells can have raw data or numbers - Click in the cell and type, your numbers will appear in the formula box l

4. Cells can have formulas, formulas start with an equals sign.   Here are some examples

=SUM(B3:K3) This would add the numbers in cell B3 through cell K3.

=(B3+C3+D3+E3+F3+G3+H3+I3+J3+K3) This would do the same thing.

=(L3/10))   This would take the total in Cell L3 and divide it by 10, the slash is division.

=(E2*E3) This would multiply the number in cell E2 times the number in E3)

+ = addition

- = subtraction

/ = division

* = multiplication

Advanced :   If you have a formula in one cell and you want the same formula in all the cells below it, but you want it to change relative to the cell location, do this: Click in the cell that has the formula and drag across the cells you want to add the formula to, release.   Click on the Edit Menu , drag down to Fill , and choose Across or Down , depending on where you want it to go.

You can also format the numbers in a cell to show currency, percentages, decimal places, etc... Click and drag on the cells you want to work on, release, click on the Format Menu, drag to Cells and investigate the next window's options.