Formula & Functions- Year 5

Q.3 _______ operators is used to perform mathematical calculations.

• Comparison

• Reference

• Arithmetic

• Logical

Q.4 All formula begin with ________ sign in Excel.

• +

• &

• /

• =

Q.5 _________ is a sequence of cell reference and operators to do calculations.

• Reference

• Formula

• Value

• Variable

An Excel spreadsheet is primarily used for calculating which of the following options

• A. Data

• B. Finances

• C. Numbers

• D. All of the above

Which of the following option is a formula?

• A. =SUM(A1:A5)

• B. Add A1 - A5

• C. Subtract the numbers

• D. A1 = A5

Which button do you click to add up a series of numbers?

• a. The autosum button

• b. The Formula button

• c. The quicktotal button

• d. The total button

Which of the following is not a function of MS - Excel?

• a. AVERAGE

• b. ADD

• C.MIN

• d. MAX

What are predefined formulae in MS - Excel called?

• a.Range

• b.Parentheses

• c.Operators

• d.Function

If you selected (A1:B5) what is this called?

• row

• column

• cell range

• cell grouping

Which are the three essential elements to enter a function?

• Equal sign, function name and cell reference.

• Function name, data and cell reference.

• Equal sign, cell reference and formula.