Page 62 - 2611_SmartGPT Pro V(5.0) C-5

1. Tick ( ) the correct option.

a. Sohan has created a worksheet in Excel to store the marks of students in his class. He
wants to display the data from the sheet in pictorial form. Which of the following features
of Excel will help him to do so?
(i) Chart (ii) Formula

(iii) Text (iv) Operator

b. Which of the following statements is incorrect about formulas in Excel?
(i) They are mathematical expressions.

(ii) They are used to perform calculations.

(iii) They always begin with = sign.

(iv) They cannot be copied from one cell to another.

c. Which of the following is not an example of a cell range?
(i) A2:A9 (ii) B2:B9

(iii) C2/C9 (iv) D2:D9

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

(i) 40 (ii) 4

(iii) 8 (iv) 12
e. Which of the following functions joins two or more text strings together?

(i) TEXT() (ii) CONCATENATE()

(iii) LEN() (iv) RIGHT()

2. Fill in the blanks using the words from the help box.

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

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

b. C1 + D1 + E1 is an example of a .
c. The selected cells should be in continuation to form a .

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

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

60 Computer Science (V5.0)-V