Page 21 - Code Craft Computer-7

Try It Out #Information Literacy

What is the use of:
1. SUM (range) ___________________________________________________________
2. DAY (date) ___________________________________________________________

Flashback Time

¨ Formulas are the user-defined instructions to perform calculations; whereas, functions are the
pre-defined or inbuilt formulas that are there in Excel, by default.
¨ Formulas are used to perform calculations, such as addition, subtraction, division, and
multiplication. A formula establishes a relationship between two or more cells.
¨ A formula must begin with an equals to (=) symbol, followed by cell references and operators.

¨ While using a function or formula, references to a cell or cell ranges are usually based on the
position relative to the cell. When you copy the formula to the other cells, the reference cell
automatically gets changed.
¨ Absolute reference is used when you do not want to change the address of the cell while
copying the formula to the other cell.

Knowledge Check

A. Mark the correct response.
OMR Sheet
1. The cell reference _________ can be included in relative
reference. Use only blue/black ball
pen to fill the circles. It
a. $B8 b. B8 should be darkened
completely and properly.
c. $B$8 d. B$8
Wrong methods
2. An error _________ occurs when the number is divided by 0.
Correct method
a. #### b. #NAME?
c. # DIV/0! d. #VALUE

3. _________ function finds the largest number in a range. 1. a b c d
a. Greatest b. Largest
2. a b c d
c. Max d. None of these
3. a b c d
4. Formulas always start with _________.
a. + b. - 4. a b c d
c. = d. /

B. Gap-fill exercise.
1. A ______ in Excel can be defined as a group of selected cells.
2. Addition of two or more text values is called _________.

3. There are _______ types of cell references.
4. A ________ establishes a relationship between two or more cells.

21