Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 41 - CodePilot V5.0 C6
P. 41

    21 st
                     COMPETENCY-BASED QUESTIONS                                                    Century   #Critical Thinking
                                                                                                    Skills  #Technology Literacy
                     1.  Jahnvi  has 10 worksheets  in a workbook  named  Sheet1, Sheet2,  … Sheet10.  She finds it hard  to
                        remember the data in each sheet. What should she do to easily identify them?

                     2.  If you have a column with full names (like Anupam Ghosh) and you want only the first
                        names  (like  Anupam)  in  the  next  column,  which Excel  feature  will help  you  do  this
                        automatically?

                                 LAB LEARNING                                              21 st
                                                                                          Century   #Creativity
                                                                                           Skills  #Technology Literacy
                            Create a monthly expenses sheet for your family and follow these instructions:
                            (a)  In Column A, list  the  names  of different  expense
                                 categories.
                            (b)  In Columns B and C, write the expenses for January and
                                 February.
                            (c)  Insert a row below row 5 to add a new expense category.
                            (d)  Use the Auto Fill feature to extend months from January
                                 to December across the top row.
                            (e)  Write the expenses for the months from March to December.
                            (f)  Save the workbook as Monthly_Expenses.xlsx.

                                       CODE CHECK                                                   Century   #Critical Thinking
                                                                                                     21 st
                                                                                                     Skills
                        1.  One lab assistant can set up a computer lab in 6 hours, while another can set up the same lab
                            in 3 hours. If both lab assistants work together, how long will it take them to set up the lab?
                        2.  If CAT = DBU and DOG = EPH, what is LION in this code?

                          JOB JUNCTION
                            People who are experts in Excel may pursue careers as Financial Analysts, Business Analysts,
                            Data Scientists, Accountants, Operations Managers, etc.

                      PEDAGOGY PATHWAYS

                       «    Explain the difference between Auto Fill and Flash Fill with examples.
                       «   Demonstrate the process of adding, renaming and deleting worksheets.

                                                                                                                      39
                                                                                                         Explore Excel

| 36 37 38 39 40 41 42 43 44 45 46 |