Kips Class 7 IT Beans Chapter 3 Formulas and Functions

Chapter 3 Formulas and Functions

Brain Developers
A. Fill in the blanks:
1. Formulas are used to perform calculations.
2. A formula always begins with an = (equal sign) sign.
3. The cell address in a formula is also called cell reference.
4. The cell address in a formula that does not change on copying is considered as absolute reference.
5. To use the Sheet reference, you need to enter sheet number, exclamation mark and cell address.
6. Arguments are input to functions, which accept values as number or text.
7. A function must be followed by opening and closing parenthesis.

B. State True or False:
1. Formulas must begin with? sign. (False)
Correct Answer: Formulas must begin with = sign.
2. In Absolute Referencing, the relative position of rows and columns changes where you copy a formula. (False)
Correct Answer: In Absolute Referencing, the relative position of rows and columns doesn't change where you copy a formula.
3. Combined Reference is a type of cell reference. (False)
Correct Answer: Mixed Reference is a type of cell reference.
4. In Absolute Referencing, '$' sign is used before the cell co-ordinates. (True)
5. A range can be used in a formula. (True)
6. Sheet tab cannot be renamed. (False)
Correct Answer: Sheet tab can be renamed.
7. SUM function is used to find sum of values. (True)

C. Application Based Question:
1. A Sports teacher has measured the height of the students in a class. Saumya has been given the assignment to find the maximum and minimum height of the students. Suggest the function, which she should use to accomplish the task.
Answer: Saumya can use MAX() function to find the maximum height and MIN() function to find the minimum height.

2. Ms Priya and her friends got a raise of 10% in their salaries. Find the total amount if the present salary is ₹15,000. Calculate the salary by using the formula.
Answer: 15,000 + (15,000 x 10 / 100) = 16,500

D. Multiple Choice Questions:
1. To use the Sheet reference, which address is appropriate out of the following options.
a) D4! Sheet1
b) Sheet1, D4
c) Sheet1! D4
Answer: c) Sheet1! D4

2. Which key combination is used to get total of adjacent cells?
a) SUM ()
b) Ctrl + '
c) Alt + =
Answer: c) Alt + =

3. Which function finds the largest number in a range?
a) Average ()
b) Count ()
c) Max ()
Answer: c) Max ()

4. Which function returns the remainder after a number is divided by the divisor?
a) MOD
b) POWER
c) SUM
Answer: a) MOD

5. Which of the given cell reference can be included in relative reference?
a) $D6
b) A3
c)A$1
Answer: b) A3

E. Answer the following:
1. What is a formula? Explain with the help of examples.
Answer: A formula is an expression that can include cell address numbers, arithmetic operations and parenthesis. We can perform simple as well as complex calculations using formulas. Example: A1 + B1 + C1.

2. What is Cell Reference? Mention its types.
Answer: The cell address in the formula is known as cell reference. There are 3 types of cell reference.
1. Relative reference
2. Absolute reference
3. Mixed reference

3. What do you know about absolute reference? Explain with the help of an example.
Answer: Absolute reference is used when we don't want to change the address of the cell on copying the formula to the another cell. To make absolute reference of a formula, add dollar ($) sign before the column name and row name. Example: $A$1 + $A$2

4. How will you rename a Sheet tab?
Answer: Right click on the sheet tab in a worksheet. A shortcut menu will appear. Click on rename option. Cursor will appear in the selected sheet tab. Type the desired name and press enter key.

5. What is a range?
Answer: Range is a collective of adjacent cell.

6. What do you mean by Function? Name some of the function.
Answer: Function are predefined formulas in Excel to perform simple and complex calculations.
Example: SUM (), AVERAGE (), MAX (), MIN (), TODAY () etc.

7. What are rules to enter a function?
Answer: The rules to enter a function are:
1. All function should begin with = sign.
2. Function name must be excel name.
3. Function name must be followed by opening and closing parenthesis.
4. Parenthesis contains arguments with in it.