Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    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

| 38 39 40 41 42 43 44 45 46 47 48 |