BHARATIYA VIDYA BHAVAN’S
SMT. M. K. PATEL SCHOOL, NARSANDA
CH.6 . Formulas and Functions
CLASS. : VI
Section - A
A. Fill in the blanks:
1. Calculations 2. Equal to (=) 3. Cell reference 4. Absolute reference
5. Concatenation 6. Arguments 7. Parenthesis 8. &
B. State True or False:
1. False 2. False 3. False 4. True 5. True 6. False 7. True 8. False
C. Application Based Questions:
1. She should use the Max() and Min() function. 2. Formula to be used: 10/100 * Salary + Salary
Section B
A. Multiple Choice Questions:
1. c. Sheet1! D4 2. c. Alt + = 3. c. Max () 4. a. MOD 5. b. A3 6. a. Count ()
B. Answer the following:
1. Formulas are used to perform calculations involving addition, subtraction, division, and
multiplication. It is an expression that can include cell addresses, numbers, arithmetic operators, and
parenthesis. For example, to find Average of four values, you can use the formula: (value 1 + value 2 +
value 3 + value 4)/4.
[Link] cell address in a formula is known as the cell reference. References help in finding the values or
data in a worksheet, that you want to use in formula. There are three types of cell references: Relative
reference, Absolute reference, and Mixed reference.
3. Two ways of entering a cell reference in a formula:
a. Relative reference: In this method, reference to a cell is based on the position relative to the cell.
Example: A3=A1+A2
b. Mixed reference: In this type of reference, either row or column is fixed by placing a dollar sign ($)
before it. Example: A3=$A1+AS2
The difference between the two ways becomes visible when the formula is copied to other cells. In case
of relative reference, the cell reference automatically gets changed whereas the fixed column or row
remains unchanged in case of mixed reference.
4. Absolute reference is used when it is required to keep the address of the cell fixed while copying the
formula to another cell. To use absolute reference in a formula, dollar sign ($) is used before the
column and row number. Example: =$A$1+$AS2
5. Function Library provides an insight into the names and functionality of the different functions
defined in Excel. The functions can be accessed by selecting the Formula tab and clicking on an
appropriate category under the Function Library group.
6. Circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly.
For example, if the formula =A1+A2*3 is entered in cell A2, it signifies the occurrence of circular
reference and results in a warning message.
7. Functions are the pre-designed formulas in Excel to perform both simple and complex calculations.
Functions save time and eliminate the chance to write wrong formulas. Some examples are: SUM,
AVERAGE, ODD, ROUND, etc.
8. Rules to enter a function are given below:
• All Excel functions must begin with = sign.
• Function name must be a valid Excel name, followed by an opening and closing parenthesis.
• Arguments are enclosed in the parenthesis.
9. We can calculate the GCD of three numbers by using the GCD function available in the Function
Library. To access it, click on the Math & Trig drop-down button in the Function Library group on the
Formulas tab and choose GCD from the displayed list of optio ns.