Page 80 - Trackpad v5 class 5
P. 80
21 st
LAB ACTIVITY Century #Technology Literacy
Skills
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 Pro (Ver. 5.0)-V

