ASSIGN-1

 

 

 

February

 

 

 

 

Rent

$240.00

$240.00

$240.00

$240.00

$240.00

Electricity

$50.00

$35.78

$33.00

$30.22

$30.27

Phone

$19.44

$35.88

$20.17

$25.67

$27.99

Water

$33.20

$32.50

$32.10

$33.40

$35.24

Cable

$37.88

$37.88

$37.88

$37.88

$37.88

Garbage

$12.94

$13.07

$13.07

$13.07

$14.20

Household

$18.00

$20.00

$25.00

$15.00

$25.00

Miscellaneous

$12.00

$10.00

$13.00

$15.00

$25.00

 

  1. Select February in cell B1
  2. Move the mouse pointer to the lower right corner of cell B1 until the pointer changes to a black cross. Click and drag right to cell F1 to AutoFill the rest of the months in.
  3. Insert a new row titled Insurance before Household (row 8).
  4. Insert a new column for January before February (column B).
  5. Delete the Household row.
  6. Copy the range C2:C9 to B2:B9 to fill in January's expenses.
  7. Estimate your insurance bill by copying the rent figures (B2:G2) to row 8.
  8. Separate the utility bill information (rows 3 through 5) by moving them to the bottom of the list.
  9. Your insurance bill turns out to be closer to half of the rent. Type the formula =B2/2 in cell B5 and =C2*.5 in cell C5.
  10. Enter the title Utilities Total in cell A11 and fill in cell B11 using the AutoSum button on the toolbar.
  11. Add the title Monthly Total to cell A13 and place the total of the other expenses (not including utilities) in cell B13.
  12. Copy the insurance formula from cell C5 to the rest of the range D5:G5. Select each of the cells D5 through G5 individuall, and notice that Excel was smart enough to change the formula to refer to the right cells for each month (i.e., =F2*.5 in cell F5).
  13. Copy or AutoFill the formulas in B11 and B13 across for each of the other months.
  14. Change the month headings to a bold, 14-point Times Roman font.
  15. Use the Format Painter tool on the toolbar to copy the same formatting to the category headings.
  16. Center the month headings in each column.
  17. Insert a row at the very top of the spreadsheet (row A). Enter Expenses in the new cell A1.
  18. Format A1 to use a bold, italic, 14-point font, and use the Center Across Columns tool on the Formatting toolbar to put this heading in the middle of the range A1:F1

Answer the following questions:

  1. Which of the following is false when working with AutoFill?
    1. selecting cells already containing data to fill by example means Excel overwrites the data in the cells
    2. if Excel can't recognize a pattern from the first two selected cells it uses only the data in the first cell
    3. if you enter April in a cell and fill the next two cells by example, Excel enters May and June in the next two cells.
    4. you can fill only days, months, and dates by example.
  2. Which of the following is not a valid formula?
    1. B3+B4+B5
    2. =SUM(B2:B9)
    3. =B12+C12/A10
    4. =(B12+C12)/A10
  3. Which of the following is a valid cell address?
    1. R12
    2. R:12
    3. R-12
    4. R/12
  4. Which of the following cannot be pasted?
    1. data that has been cut
    2. data that has been cleared
    3. data that has been copied
    4. data you just pasted
  5. Which of the following is not a mathematical operator?
    1. + (plus sign)
    2. ^ (caret)
    3. @ (at sign)
    4. - (hyphen)
  6. Which of the following is not a method of adjusting column width?
    1. Format, Column, Width... command
    2. Edit, Column command
    3. double-clicking the right column border on the worksheet frame
    4. dragging the column border on the worksheet frame
  7. If pound signs (######) fill a cell, it means that
    1. the cell is not active
    2. the formula is impossible
    3. the column is not wide enough
    4. you must recalculate the formula

 

Hosted by www.Geocities.ws

1