Page 43 - 2611_SmartGPT Pro V(5.0) C-5

d. How do you select an entire row in Excel?
_______________________________________________________________________________

_______________________________________________________________________________

e. Why is the Autofill feature of Excel useful?

_______________________________________________________________________________
_______________________________________________________________________________

f. Describe the process to select a range of cells using the keyboard.
_______________________________________________________________________________

_______________________________________________________________________________

21 st
5. Competency-based/Application-based questions. Century #Technology Literacy
Skills
a. Your friend Riya is working on an Excel workbook with several sheets, and she need to add
a new sheet for extra information. Which option should you suggest her to insert a new
worksheet into existing workbook?

b. Kazim is arranging students details by roll numbers from 1 to 50. How can he fill this num-
ber sequence without manual entry?

SDG Activity

You are planning a big birthday party for your best friend. You have a limited
budget to buy decorations, snacks, and gifts. You want to make the party
as eco-friendly as possible ensuring there is no wastage of any resource.
Make a list of supplies and their respective quantities you will need in Excel.

21 st
LAB ACTIVITY Century #Technology Literacy
#Information Literacy
Skills
▶ Start MS Excel and click on Blank workbook.
(a) Write the names of all your friends in Column A.
(b) Now, write all of your friends’ birthdays in Column B.
(c) Add another worksheet to this workbook by left-clicking on the ‘+’ sign at the
bottom of the screen.
(d) Now, select and copy all the names of your friends from the first worksheet and
paste them into the second worksheet.
(e) In the second worksheet, write the addresses of all your friends in Column B.
( f ) Save the workbook and exit Excel.

Excel 2021 41