Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 22 - 2612 Digimind C6
P. 22

    e.  How do you select a range of cells using the mouse in Excel?
                          ______________________________________________________________________________________

                          ______________________________________________________________________________________

                          ______________________________________________________________________________________

                      7.  Differentiate between the following:

                         a.  Relative Cell Referencing                         Absolute Cell Referencing
                         ______________________________________                ______________________________________

                         ______________________________________                ______________________________________
                         b.  Comparison Operators                              Reference Operators
                         ______________________________________                ______________________________________

                         ______________________________________                ______________________________________

                                                                                                     21 st
                      8.  Competency-based/Application-based questions.                            Century   #Technology Literacy
                                                                                                     Skills
                         a.   Adhyay entered a ten-digit number in Excel. He now wants to extract the last three digits of this
                            number. Which function should he use for this? Also write the syntax.

                         b.   Gaurav wants to compare the values of two different columns. He wants to check whether the values
                            are equal or not. Which operator should he use? Give the symbol for that operator.

                                                                                             21 st   #Technology Literacy
                         LAB ACTIVITY                                                     Century   #Productivity & Accountability
                                                                                            Skills

                        Visit your computer lab and perform the following actions:
                        ▶  Enter the following data in Excel, then perform the tasks in the cells listed below:

                          a.   C2- =(A2*B2)                       b.  C3- =(A5=B3)

                          c.  C4- =(A2:A6)                        d.  E2- =AVERAGE (A2:A6)
                          e.  E3- =(D2&D4)                         f.  E4- =MID(D5, 4, 3)

                          g.  C5- =(A3<>B5)                       h.  C6- =(B6^2)
                          i.  E5- =MAX(A2:B6)                      j.  E6- =COUNT(A2:B5)

                       20   Premium Edition-VI

| 17 18 19 20 21 22 23 24 25 26 27 |