Page 80 - Trackpad_V1_Book 5_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

