Thursday, April 26, 2007

Today's Agenda:
1. Warm up (More Practice on MS Excel)
2. Orders of Operation
3. Receipts and formulas
4. Homework

1. Warm up
Create a NEW Spreadsheet workbook.

Part I:
Type up each set of numbers in the columns specified. In ROW #10 of each column, enter a FORMULA that would add up the column. Place a Thick Dark border around each answer.

COLUMN A = 200, (100x31), 300, 123, (251-50), 321, 31.12, 1
COLUMN B = (34110+123+0.24), (0.23x100), 0.3, 8.151, 6.123, 4, 12.75, (1.2-0.9)
COLUMN C = (1682-123), (-321/12), (58*0), (8.231x23), (75x45), (-45x1990), 82, 5
COLUMN D = 751, 752, 753, 754, 1, 2, 3, 4
COLUMN E = 8222, 1, 75, 2.2, 1.1, 8.321, 12.5, 1.375

Part II:

CELL F1: Enter a Formula that would ADD UP all the numbers in ROW1. Fill the CELL with Orange.
CELL F2: Enter a Formula that would ADD UP all the numbers in ROW2. Fill the CELL with Blue.
CELL F3: Enter a Formula that would ADD UP all the numbers in ROW3. Fill the CELL with Green.
CELL F4: Enter a Formula that would ADD UP all the numbers in ROW4. Fill the CELL with Yellow.
CELL F5: Enter a Formula that would ADD UP all the numbers in ROW5. Fill the CELL with Gray.
CELL F6: Enter a Formula that would ADD UP all the numbers in ROW6. Fill the CELL with Purple.
CELL F7: Enter a Formula that would ADD UP all the numbers in ROW7. Fill the CELL with Light Green.
CELL F8: Enter a Formula that would ADD UP all the numbers in ROW8. Fill the CELL with Teal.

Cell F9: Enter a Formula that would add up all the totals in your workbook. Use ARIAL 25PT font.