Page 80 - TrackpadV1.0_C5_Flipbook
P. 80
LAB ACTIVITY Subject Enrichment
Visit your computer lab and perform the following actions:
▶ Open Excel and enter the following data:
▶ Add a column to the right of Sr. No. and enter the following entries:
▶ Now, add a row above the fourth row and enter the following entries:
▶ Lastly, correct the Sr. No. of the fifth and sixth rows.
▶ Create the following worksheet in Excel:
(a) Set the height of Row 1 to 35.
(b) Set the column width of B to 12, C to 15 and D to 12.
(c) Use the AutoFill feature to enter the employee numbers.
(d) After you are done entering the data, find out the total, average, lowest and highest
values, and write them in their respective cells.
78 Trackpad (Version 1.0)-V

