REVIEW OF MICROSOFT EXCEL

Label the following parts of the Microsoft Excel Window

A: . B: .

C: . D: .

E: . F: .

G: . H: .

I: . J: .

K: . L: .

M: . N: .

O: . P: .

Q: . R: .

Use the HELP feature of Microsoft Excel to find out how to do the following :

  1. Create a new Worksheet: .
  2. Open an existing Worksheet: .
  3. Close a Worksheet: .
  4. Save a Worksheet: .
  5. Save a Worksheet with a new name: .
  6. Print a Worksheet .
  7. Print Preview a Worksheet .
  8. Enter Data into a Worksheet: .
  9. Spell Check a Worksheet: .
  10. Clear contents of a cell: .
  11. Change Font: .
  12. Change Font Size: .
  13. Add a Header or Footer: .
  14. Centre a cells contents: .

EXCEL SPREADSHEET ASSIGNMENT #1

1) ENTER THE COLUMN TITLES IN ROW 1

a. Point to cell Al and click once to select it, if it is not already selected. Type Name and click on the Enter button. Cell Al now contains the label Name. Note that the Entry bar displays the currently selected cell's contents.

b. Select cell B1 and type Test 1.

c. Press the right-arrow key to move the cell cursor to cell C1, then type Test 2.

d. Press the Tab key. The label is entered and the cell cursor moved to the next cell in

the row, DI.

e. Continue this procedure to place the headings Test 3 in cell DI and Test 4 in cell El.

2) ENTER THE TEST DATES

a. Select cell B2 and type the date 9/11/00. Click on the Enter button. Excel right aligns date when entered into a cell.

b. Select cell C2 and type the date 10/8/98. Press the Tab key. The cell cursor is moved to the next cell in the row, D2.

c. Enter the date 11l/12/00 in cell D2 and the date 12/10/00 in cell E2.

3) ENTER THE STUDENT NAMES AND GRADES

Enter the following labels and values starting in cell A3:

B. Alban 64 87 55 73

Y. Salto 80 90 78 82

S. Cruz 93 96 92 90

R. Kim 71 87 52 70

P. Quinn 87 73 49 82

H. Toro 81 77 73 80

4) CREATE A HEADER AND FOOTER

  1. From the File menu, select Page Setup. The Page Setup dialog box is displayed.
  2. Select the Header/Footer tab if those options are not already displayed.
  3. Select the Custom Header button. The Header dialog box is displayed.
  4. Click the pointer in the Center section entry box to place the cursor.
  5. Click on the Date button. The code &[Date] is placed in the box. Select OK.
  6. Select the Custom Footer button. The Footer dialog box is displayed.
  7. Place the cursor in the Right section entry box then type your name. Select OK.
  8. Select OK to remove the Page Setup dialog box.

5) PREVIEW THE. SPREADSHEET

a. From the File menu, select Print Preview. The print preview window is displayed with the portion of the spreadsheet containing data. Note the header and footer. However, also notice how it is hard to read a row in the spreadsheet because there are no gridlines or row and column headings.

b. Select Close to return to the spreadsheet window.

c. From the File menu, select Page Setup. The Page Setup dialog box is displayed.

d. Select the Sheet tab if those options are not already displayed.

e. Select the Gridlines and Row and column headings options. Select OK.

f. Print preview the spreadsheet. Notice how much easier the spreadsheet is to read.

g. Select Close to return to the spreadsheet window.

6) SAVE, PRINT, AND CLOSE THE SPREADSHEET

  1. From the File menu, select Save. The Save As dialog box is displayed.
  2. In the Save in entry box select the appropriate folder.
  3. In the File name entry box, type Grades. Select Save. DO NOT PRINT!

d. From the File menu, select Close. The Grades spreadsheet is closed.

 1