Page 85 - 2622_Delhi Police Public School_C-6

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.

Charts, Formulas & Functions in Excel 83