Page 50 - C_GPT _V4 _class_6
P. 50

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?






                 48     CodeGPT (Ver. 4.0)-VI
   45   46   47   48   49   50   51   52   53   54   55