Page 37 - ThinkGPT_V2.1_C6_Flipbook
P. 37

Information Literacy
                       byte Quest                                                     Critical Thinking


                      Write the output of the following:

                      1. =MIN(5,7,8)
                      2. =LEFT("Computer", 4)
                      3. =AVERAGE(12,3,6)

                      4. =LEN("Touch")
                      5. =COUNT(4,8,12)





                       REFRESH


                       Excel allows users to create custom formulas to perform calculations on their data.
                       A cell reference is a cell address that can be used in a formula to denote a specific cell.
                       The equal to sign (=) tells Excel that the succeeding characters constitute a formula.
                       A group of selected cells is called a range.
                       Excel also contains built-in formulas called functions that make it easy to perform common calculations
                      on data.





                                                  TeCh Ready



                 A.  Tick ( ) the correct option.
                    1.  Which of the following cell references can be included in the relative reference?

                         (i)  A3                                          (ii)  A$1
                        (iii)  $A$4                                      (iv)  $D6

                    2.  Which of the following function is used to calculate the average of a range of values?
                         (i)  AVERAGE                                     (ii)  AVG

                        (iii)  SUM                                       (iv)  MAX

                    3.  What is a group of selected cells called?
                         (i)  Selection                                   (ii)  Cell range

                        (iii)  Combination                               (iv)  Value

                    4.  What does the NOW() function display?
                         (i)  Date                                        (ii)  Time

                        (iii)  Both (i) and (ii)                         (iv)  None of these






                                                                              Formulas and Functions in Excel  35
   32   33   34   35   36   37   38   39   40   41   42