Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 40 - ClickGPT V4.0 C-5
P. 40

    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?

                     38     Premium Edition-V

| 35 36 37 38 39 40 41 42 43 44 45 |