Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 65 - 2607_Trackpad_Pro_5.1_flipbook_C5
P. 65

    21 st
                     5.  Competency-based/Application-based questions.                         Century   #Technology Literacy
                                                                                                 Skills
                        a.   Your friend Rohan is using Excel 2021 to do some calculations and wants to see
                            the formula he has entered for a cell. Which part of the Excel window would you
                            suggest he look at to view or edit the formula he is using?
                            ______________________________________________________________________________

                        b.   You are working with cells in Excel and need to identify the address of a particular cell,
                            which is formed by combining  specific  information  about  the cell. What does  a cell's
                            address consist of in Excel?
                            ______________________________________________________________________________

                                                                                                21 st
                        LAB ACTIVITY                                                          Century   #Technology Literacy
                                                                                                   #Information Literacy
                                                                                               Skills
                         Visit your computer lab and perform the following actions:
                         ▶ When you visit the Computer Lab, perform the following tasks:
                           (a)  Start MS Excel and click on Blank workbook.
                           (b)  Write the names of all your friends in Column A.

                           (c)  Now, write all of your friends’ birthdays in Column B.
                           (d)   Add another worksheet to this workbook by left-clicking on the ‘+’ sign at the
                                bottom of the screen.

                           (e)   Now, select and copy all the names of your friends from the first worksheet and
                                paste them into the second worksheet.
                           (f)  In the second worksheet, write the addresses of all your friends in Column B.

                           (g)  Save the workbook and exit Excel.

                             COding Zone       COding Zone     {}      =     COding Zone
                                    {C ding z ne}
                                                                                             21 st
                                                                                                #Critical Thinking
                                                                                           Century
                                                                             </>
                                                                                            Skills
                                                                                                        COding Zone
                         Open Excel and use the Fill Color option present in the font group to fill colour in the
                         following cells:
                         I5, I6, I7, I8, I9, I10, I11, I12, I13, I14, I15, J13, J14, J15, K13, K14, K15, L13, L14, L15.
                         Identify the letter formed.

                           CAREER HERE
                     People who are experts in Excel 2021 may pursue their careers as Data Analysts.

                       FOR THE TEACHER
                       1.   Demonstration of all the steps taught in the chapter to work in Excel would be helpful to aid the students
                          in following the instructions properly.
                       2. Give students adequate practice time to get familiar with the different components of the Excel window.

                                                                                             Excel 2021—An Introduction  63

| 60 61 62 63 64 65 66 67 68 69 70 |