You can use Excel 2000 worksheets to collect and analyze information, including student records, lesson notes, school activity budgets, and professional organization information, and data. Students may use Excel 2000 for scientific data, weather journals, financial reports, nutritional diaries, or legislative voting records. Each worksheet can be easily customized and enhanced with graphics and artistic additions. This lesson teaches you to build a workbook containing a worksheet for student attendance and a worksheet for grades.

TO CREATE THE WORKBOOK

1. If necessary, open Microsoft Excel 2000.

2. On the File menu, click New.

3. On the General tab, double-click Workbook to open a new one.

4. Click cell B2 and then type Student List.

5. Save your work.

PASSWORD PROTECTING THE WORKBOOK

Because this workbook contains sensitive information, you can add a password to the document. When a workbook is password-protected, no one can read or change information in it without using the password.

Password Protect the Workbook

1. On the File menu, click Save As.

2. In the Save As dialog box, on the Tools menu, click General Options.

3. In the Password to open box, type a password and then click OK.

4. In the Reenter password to proceed box, type your password again and then click OK.

5. Click Save.

6. If prompted, click Yes to replace the existing file.

ADDING AN ATTENDANCE WORKSHEET

In this section, you add the attendance worksheet that you already created. The attendance worksheet is the first worksheet in the book you created previously.

COPY A WORKSHEET INTO A WORKBOOK

1. Open the Attendance worksheet you already created.

2. On the Edit menu, click Move or Copy Sheet.

3. In the To book dialog box, click (new book).

4. Click OK.

5. Close the file. You do not need to save.