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: _______________________________________

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

     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!!!

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) ___________________________.

Report this document

For any questions or suggestions please email
cust-service@docsford.com