DOC

# Part 3 Identify the Parts of a Spreadsheet

By Stephen Green,2014-11-26 13:32
7 views 0
Part 3 Identify the Parts of a Spreadsheet

Part 3: Identify the Parts of a Spreadsheet

2a 1 2

3

4

5

6

Part 4: Formulas

Instruction: All formulas start with an “=” (equal sign). The variables in a formula are the cell addresses of the cells you want to calculate. For example: If I wanted to add up all of the January temperatures of the spreadsheet above (52, 42, 76, 40) I would simply type the following formula: =B5+C5+D5+E5. B5 is the cell address of the number 52; C5 is the cell address of 42; etc. Perform the following steps using the above spreadsheet.

1. Write a formula that will add up all of the February temperatures: _____________________________

2. Write a formula that will add up Charlotte’s temperatures in January – April: ____________________

3. Write a formula that will add up all of the April temperatures and divide that total by 4 (this will give

you the Average temperature in April) (Be sure to remember order of operation. You may need to use

parenthesis.) : ______________________________________

4. Write a formula that will subtract the temperature in New York in January, from the temperature in

Miami in January: _______________________________________

Identifying Parts and Creating Formulas Period: ________________

Part 1: Writing Formulas Tutorial

Directions: Read and follow the steps below in order to learn how to create formulas in a spreadsheet. Do not skip any steps!!! THIS ASSIGNMENT WILL BE WORTH A QUIZ GRADE!!!

1. Start a blank Spreadsheet in Microsoft Excel

2. Create the spreadsheet below. Be sure to type the data in the correct cells.

A B C D

1 Item Description Number in Stock Price Per Unit Total Value

Hot Dogs 50 \$2.00 2

Hot Dog Buns 30 \$2.50 3

Potato Chips 25 \$3.00 4

Pickles 40 \$1.50 5

6 TOTALS

3. When writing a formula in math you would do the following when adding up the “Number in

Stock” column from the above spreadsheet: 50+30+25+40=145

4. In a spreadsheet, instead of using the actual values in our formulas, we would use the cell

addresses of where those values are located. For example: the value 50 (above) is in cell B2, the

value 30 is in cell B3, the value 25 is in cell B4, and the value 40 is in cell B5. Therefore, in a

spreadsheet, you would type the following formula: B2+B3+B4+B5

5. You must type the formula in the cell where you want the results to appear and all formulas

in a spreadsheet must begin with an equal sign (=).

6. Type the following formula in cell B6 and press enter: =B2+B3+B4+B5

7. If you typed it in correctly, the number 145 should appear in cell B6

8. Now try typing a formula in cell C6 that will add up all of the “Prices”

9. Move to cell D2 and type the following formula: =B2*C2 (This formula will multiply 50 times

\$2.00)

10. Now complete the spreadsheet by typing formulas in cells D3, D4, and D5

11. Save the spreadsheet as “Picnic Items” *****I WILL BE GIVING YOU ALL A QUIZ

GRADE FOR THIS ASSIGNMENT!!!! BE SURE THAT YOU SAVE IT CORRECTLY!!!

1. Name two uses of a spreadsheet?