Part 3: Identify the Parts of a Spreadsheet
2a 1 2
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: _______________________________________
Spreadsheets Name: _________________
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
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
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!!!
Part 2: Short Answer
Directions: Answer the following questions
1. Name two uses of a spreadsheet?
2. What makes a spreadsheet so great? (It’s advantages)
3. The text on a spreadsheet that tells us what the numbers mean is called a ____________________.
4. Draw a picture of the symbol used on a spreadsheet for each mathematical operation below.
Add: _____ Subtract: _____ Multiply: _____ Divide: _____
5. Every function or formula in a spreadsheet must begin with a(n) ___________________________.