Page 36 - Viva ICSE Computer Studies 8 : E-book

• Other than addition, none of the arithmetic operations are allowed on the string data type.
• To perform addition among two string values, the ‘ampersand’ symbol ‘&’ is used.
• In relative reference, the formula in the copied cell changes according to the change in the
position of the cell pointer.
• An absolute reference is specifi ed using the $ sign along with the column and row number of
the cell.
• Mixed reference is a combination of relative and absolute reference.
• When a formula in a cell refers to its own cell value, it is called circular reference.
• Excel provides all its functions in the Function Library group of the ‘Formulas’ tab.

A. Name the following.

1. Sign with which a formula begins in Excel _____________
2. Three types of data a formula consists of _____________ _____________ _____________

3. Three relational operators _____________ _____________ _____________
4. Three logical operators _____________ _____________ _____________

5. Two arithmetic operators _____________ _____________

B. Match the columns.

Column A Column B
1. #### (a) Date is not valid.

2. #NAME? (b) Formula contains an invalid operation.
3. #N/A (c) Division by zero is being performed.

4. #VALUE! (d) Column is not enough to display the number.
5. #DIV/0! (e) Excel does not recognise the test in a formula.

C. Fill in the blanks.

1. An absolute reference is specifi ed using ____________ sign along with the ____________
and ____________ number of the cell.

2. ____________ operators perform calculations with only numeric value.
3. ____________ operators are used to compare two or more relational ____________.

4. ____________ and ____________ operators give result in true or false.
5. ____________ formula requires more than one operator to ____________.

24