MS EXCEL FOR CLASS 7 ( Ch.- 2)

DATE ;   26 /5/ 2025

CLASS     7th 

CHAPTER  02 

Formulas and functions  in Excel 

 

Checkpoint (Pg. 31)

Write T for True and F for False.

1. F

2. T

3. F

Exercises (Pgs. 41-43)

A. Tick (✓) the correct answers.

1. c

2. b

3. a

4. a

5. a

B. Fill in the blanks.

1. equals (=)

2. ampersand (&)

3. mixed

4. AVERAGE

5. DIV/0!

C. Write T for True and F for False.

1. T

2. F

3. T

4. T

5. F

A     Answer the following questions in short 

Q. 1    What are formulas in excel ?

Ans    Formulas in excel are sets of instructions given by the user to perform  calculations, just like in mathematics .

Q. 2    What are operators in excel ?

Ans    Operators  are the symbols use to perform calculations such as " + " for addition " - ' for subtraction " * ' for multiplication and " / " for division .

Q.3    Explain the rules of writing formula in MS Excel? With examples

 

 Ans    Start with an equal sign ( = ) 

Example=    ("=5+3")

Q. 4    What is the full from of BIDMAS ?

 Ans    The full from of BIDMAS is   Brackets ,  Indices , division and multiplication , addition and subtraction

B.     Answer the following questions in Long.

Q.1    What are the different types of cell references in Excel ? Explain with example .

Ans:- There are three types of cell references in a formula: Relative, Absolute, and Mixed.

 Relative Cell Reference: A Relative cell reference is the most common type of reference in Excel. It is the default reference used when you create a formula. When you copy a formula that uses relative cell references to another cell, the references (both the row and column) change automatically based on the new location of the formula. This makes relative references especially useful when performing similar calculations across multiple cells.

Absolute Cell Reference: An Absolute cell reference does not change when you copy the formula to another cell. It is fixed to a specific cell. This is useful when you always want to refer to the same cell, no matter where the formula is copied. Absolute references are written with a dollar sign ($) in front of the column letter and row number. For example, $B$2 is an absolute reference.

Mixed Cell Reference: A Mixed cell reference is a combination of both Relative and Absolute cell references. In this type of reference, one part of the cell address is relative, and the other is absolute. This means that either the column reference is relative, while the row reference is absolute, or vice versa.

Q.2    What are functions in excel ? Example 

Ans:-     Functions are pre-defined formulas that help you perform specific calculations quickly and easily. These functions can be used for both simple and complex operations.

Example :- SUM functions is used to automatically calculate the total . 

Q.3    How can you prevent errors such as #DIV/0! , #REF! , and #NAME? when working with Excel formulas ?

 Ans:- You can prevent these errors by using the following methods:

• #DIV/0!: This error occurs when a number is divided by zero. To avoid this, you can use an IFERROR or IF function to check for zero before performing the division. For example, =IF(B1=0, “Error”, A1/B1) will return “Error” if B1 is zero.

• #REF! :- This error happens when a formula refers to an invalid cell, often caused by deleting a referenced cell. To avoid this, make sure not to delete cells that are being used in formulas or use absolute references when necessary.

• #NAME? :-  This error indicated that there is a problem with the formula's syntax such as an unknown function name or type in reference . 

Q.4   Explain about Simple formula and compound formula ? 

Ans:-  Simple formula :- A simple formula contains only one operator . We can use + sign to add the numeric value example:- 5+3 or  A1+ A2 , here we used one operator so this is simple formula. 

Compound formula :-  A compound formula is used when you need more than one operator to perform a calculation . For example :- Average Marks = Total marks /number of terms and unit test , Here We used + sign for total and division sign for division, so we used two operators so this is compound formula.

Chapter :- 3