Activity 1: Creating
a worksheet and adding text
Open Microsoft Excel. A new workbook opens.
At the top of the worksheet, right-click the B (column
header) and click Format Cells.
On the Number tab in the Category box,
click Text and then click OK. This keeps the
student numbers in this column exactly as you type them.
Click cell A3. Type High Score. Click cell A4.
Type a student name, last name first (for example, Adams,
John). The list of student names is found in the blue
section below. The words may not be entirely visible in the
selected cell. The information is still there, and later, you
will format the column so you can see all of the information.
Click cell B4 or press TAB.
Type in the student’s ID number. (Begin with 300 and go up to
Click cell A5.
Type the next student’s name, press the right arrow, and type
the student ID number.
10. Continue to type each of the names and student numbers for
the students in one class.
11. Save your workbook as "Attendance Sheet"