Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 19 - 2612 Digimind C6
P. 19

    21 st   #Initiative
                                                              Self Reflection                Century   #Leadership & Responsibility
                                                                                               Skills
                        Your mother has been preparing a list of grocery items with their price. She has been manually
                                                              Self Reflection
                        calculating the total amount. Is there any function or formula that can help her make her task
                        easier? Do you think you should be helping people whenever you see an opportunity?

                            Hashtag

                          #Operator: An operator is a symbol that is used to perform calculation
                          #Function: A predefined formula in Excel

                           REVISIT

                       ▶  Any text entered in Excel is called a label.
                       ▶  Any numeric data entered in Excel is called a value.
                       ▶  To perform mathematical calculations, a formula is entered in a cell.
                       ▶  A function is a predefined formula in Excel.
                       ▶  Operators are the symbols that are used to perform calculations.
                       ▶  A group of selected cells is called a cell range.
                       ▶  A cell reference is a cell address that can be used in a formula to denote a specific cell.

                     1.  Tick ( ) the correct option.
                        a.  Riya is creating a student record sheet in Excel. She wants to enter a heading that shows the student’s
                          name as text, not a number or formula. Which of the following should she enter as a label?

                            (i)  123                                       (ii)  A1+B2
                           (iii)  Name                                     (iv)  45.67

                        b.  Arjun wants to calculate the total marks of a student by adding values from two cells in Excel. To
                          ensure Excel recognises his entry as a formula, which symbol should he type first?

                            (i)  $                                         (ii)  @
                           (iii)  #                                        (iv)  =

                                                                                     Formulas and Functions in Excel 2021  17

| 14 15 16 17 18 19 20 21 22 23 24 |