Page 65 - Computer Class 07

2. * is used to ____________ numbers.

a) multiply b) subtract
c) divide d) ????
3. What do we call the pre-defined formula?

a) Function b) Chart
c) Cell references d) None of them

4. How many ways of editing the formula are there?

a) One b) Two
c) Three d) Four

5. Which operator is used to find out number that is not equal to the condition?
a) <> b) ()

c) >< d) =<

B. Write True or False .
1. Formulas begin with an equal to sign (=).

2. You cannot type formula in any active cell of the worksheet.

3. Copying a formula in Excel worksheet is not allowed.
4. The order in which you insert a function is important.

5. Function is a built-in formula that can be directly used on the data to
perform calculations.

6. Each function has a specific order called syntax.

C. Fill in the blanks.

1. Formula must begin with = symbol followed by the cell __________ and __________ .
2. Excel 2016 displays the formula in the __________ and in the active cell.

3. In order to use functions correctly, you will need to understand the different parts of a
__________.

4. Arguments are typically presented in __________ following the function.
Descriptive Type Questions

A. Define the following functions. You can take help of your teachers.
1. SUMIF : ________________________________________________________

_______________________________________________________________________
2. RANK : ________________________________________________________

_______________________________________________________________________

Computer-7 65