Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 36 - 2632_CodeMind
P. 36

    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

| 31 32 33 34 35 36 37 38 39 40 41 |