Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 25 - 2617_JSSPS_C-6
P. 25

    2.  Which of the following statements is incorrect about formulas in Excel?

                                      a. They are mathematical expressions.       b. They are used to perform calculations.

                                      c. They always begin with = sign.           d. They cannot be copied from one cell to another.

                            3.  Which of the following is not an example of a cell range?
                                      a. A2:A9                                    b. B2:B9

                                      c. C2/C9                                    d. D2:D9

                            4.  What will be the output of the following function?
                                =SUM(4, 8, 12, 16)
                                      a. 40                                       b. 4

                                      c. 8                                        d. 12
                            5.  Which of the following functions joins two or more text strings together?

                                      a. TEXT()                                   b. CONCATENATE()

                                      c. LEN()                                    d. RIGHT()

                            Tick ( ) the correct statements and cross ( ) the wrong ones.

                            1.  The X-axis is the horizontal axis of the chart, which is also called the category axis.

                            2.  In an Excel worksheet, text is aligned on the right side of a cell.

                            3.  Excel calculates expressions within parentheses (... , ...) first.

                            4.  The @ sign is used to form an absolute cell reference.

                            5.  =MINUTE(NOW()) will return minutes from a current time.

                            Fill in the blanks with the correct words.

                                                Hints  Formula, Range, PRODUCT(), Chart Title, Logical

                            1.                 describes the main aim and content of the chart.

                            2.  C1 + D1 + E1 is an example of a            .

                            3.  The selected cells should be in continuation to form a         .

                            4.  The                function multiplies the values in a range of cells.

                            5.  The IF() function is an example of            functions.

                      Q     Answer the following questions:
                        A
                            1.  What are gridlines in a chart?

                                                                                 Charts, Formulas & Functions in Excel  23

| 20 21 22 23 24 25 26 27 28 29 30 |