Excel Activity 03

Post date: Oct 6, 2016 3:46:43 PM

  • Essential Questions:How can learning spreadsheet software help you be successful in the future?

Lesson Essential Question:

  • How can spreadsheets be used to communicate data effectively?

Household Electrical Use

Spreadsheets can be used like calculators to manipulate numerical data. Cells in a spreadsheet can be programmed to automatically perform mathematical calculations. This is how many businesses track inventory and sales. People use this feature to organize budgets. You will use this spreadsheet to track electrical use in a typical house. Tables like this help people evaluate information and make changes and not perform additional math.

Directions

1. Open a new workbook document in Excel.

2. Click on cell A1 and begin entering the information shown in the chart below. You will need to make the columns wider as you enter the data.

3. Save As – First and Last Name Electrical Use.

4. Select cells A1 through F1. Use the Bold button in the font section on the ribbon to bold your categories.

5. With A1 through F1 still selected, go to Alignment and center.

Now we will enter our formulas.

6. Click in cell D2. Enter the following equation to decide the Watt Hours. As you type or click the cells, notice the color change.

=B2*C2

7. Continue the equation through cell D11. You should have numbers in the D column that show the Watt-hours. Use your multiplication skills to double check that you did it right.

8. Next click in cell E2 to enter the equation to calculate the Kilowatt Hours. The equation is:

=D2/1000

Cell E3 should have the equation =D3/1000

Continue this equation until you have completed through E11.

9. Click in cell F2. Now we need to calculate the cost. The cost will vary from state to state and by the time of day. We will use $0.14. The formula in cell F2 is

=E2*0.14

Cell F3 should have the equation à =E3*0.14

Continue this equation through cell F11.

10. Select cells F2 through F12 and change to Currency. Readjust the width of the cell if needed.

11. Click in cell B12, click on the auto sum button. Be sure the equation is =SUM(B2:B11)

12. Click in cell C12. Use the AutoSum button and the equation should be =SUM(C2:C11)

13. Total the columns D12, E12, and F12 using the AutoSum Button. The equation should be similar to the ones in B12 and C12.

14. Make sure you adjust cells if the information does not fit.

Save once again and Hand into Haiku.