Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 21 - 2612 Digimind C6
P. 21

    c.   Find the issue with the formula =VLOOKUP("value", A1:A10, 2, FALSE) when the second argument
                          range is incorrect.

                         ______________________________________________________________________________________

                        d.  Spot the error in =SUM(A1:A5) * % when a percentage symbol is incorrectly used.
                         ______________________________________________________________________________________
                        e.  Identify the error in =DATE("2021", "01", "01") with incorrect data types.

                         ______________________________________________________________________________________

                     4.  Write ‘T’ for true and ‘F’ for false.

                        a.  Formulas are used to perform mathematical calculations in Excel.

                        b.  The IF function returns different values based on a condition.

                        c.  The address of a cell range uses a comma between starting and ending cells.

                        d.  In operator precedence, addition is performed before multiplication.

                        e.  References, operators and constants are elements of a formula.

                     5. Fill in the blanks.

                                            Invalid, Cell range, Cell reference, Colon, Function

                        a.  A __________ is a predefined formula in Excel.
                        b.  The range operator in Excel is represented by a __________.

                        c.  A cell address used in a formula is known as a __________.
                        d.  A __________ is used to perform a calculation on multiple cells.
                        e.  The error #NUM! appears when the formula contains __________ numeric values.

                     6.  Think and answer.

                        a.  What is a cell reference in Excel?
                         ______________________________________________________________________________________

                        b.  Write the purpose of the SUM function in Excel.
                         ______________________________________________________________________________________

                        c.  How do you enter a formula directly into a cell?
                         ______________________________________________________________________________________

                         ______________________________________________________________________________________

                        d.  Summarise the use of the CONCATENATE function.
                         ______________________________________________________________________________________

                         ______________________________________________________________________________________

                                                                                     Formulas and Functions in Excel 2021  19

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