Excel Activity 03

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?

1. Open New Microsoft Excel Document.

2. Save the File as Activity 3

3. Enter the text as it appears below. You will have to stretch out the columns so the text will fit.

4. Merge Cells A1, B1, C1, D1, E1, F1, and G1. Also, merge A2, B2, C2, D2, E2, F2 and G2. This combines the cells to make one large one.

5. Change the formatting of Row 1 and 2 to 14-point Verdana Italic.Just like in Microsoft Word, you are changing the font.

6. Merge Cells A4, B4, C4, D4, E4, F4, and G4. Change the font to Bold and Underline. Once again making one large cell.

7. Change cell formatting for all numbers to currency with NO decimal places. There is a button you can use to move the decimal point to the left and the right. Use this to move the decimal.

8. Enter formulas for cells F7:F13 as well as G7:G13. Remember auto sum? Make sure you are selecting the right cells.

9. Enter formulas for cells B15, C15, D15, E15, F15, as well as B16, C16, D16, E16. Remember sum? Make sure you are selecting the right cells.

10. Put a double bottom border on cells B13, C13, D13, E13. This button is in the font section.

11. Put a single bottom border on Cells A6, B6, C6, D6, E6, F6 and G6.

12. Save as activity 3 and submit to Edmodo.