## Chapter 3 Formulas and Functions

**Brain Developers**

A. Fill in the blanks:

1. Formulas are used to perform

A. Fill in the blanks:

1. Formulas are used to perform

__calculations__

**.**

2. A formula always begins with an

2. A formula always begins with an

__= (equal sign)__

**sign.**

3. The cell address in a formula is also called

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

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,

5. To use the Sheet reference, you need to enter sheet number,

__exclamation mark__

**and**

__cell address__

**.**

6.

6.

__Arguments__

**are input to functions, which accept values as number or text.**

7. A function must be followed by opening and closing

7. A function must be followed by opening and closing

__parenthesis__

**.**

B. State True or False:

1. Formulas must begin with? sign. (False

B. State True or False:

1. Formulas must begin with? sign. (

**)**

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: Formulas must begin with = sign.

2. In Absolute Referencing, the relative position of rows and columns changes where you copy a formula. (

**)**

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: 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. (

**)**

Correct Answer: Mixed Reference is a type of cell reference.

4. In Absolute Referencing, '$' sign is used before the cell co-ordinates. (True

Correct Answer: Mixed Reference is a type of cell reference.

4. In Absolute Referencing, '$' sign is used before the cell co-ordinates. (

**)**

5. A range can be used in a formula. (True

5. A range can be used in a formula. (

**)**

6. Sheet tab cannot be renamed. (False

6. Sheet tab cannot be renamed. (

**)**

Correct Answer: Sheet tab can be renamed.

7. SUM function is used to find sum of values. (True

Correct Answer: Sheet tab can be renamed.

7. SUM function is used to find sum of values. (

**)**

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.

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:

**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

Answer:

**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

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:

**2. Which key combination is used to get total of adjacent cells?**

a) SUM ()

b) Ctrl + '

c) Alt + =

Answer:c) Alt + =

a) SUM ()

b) Ctrl + '

c) Alt + =

Answer:

**3. Which function finds the largest number in a range?**

a) Average ()

b) Count ()

c) Max ()

Answer:c) Max ()

a) Average ()

b) Count ()

c) Max ()

Answer:

**4. Which function returns the remainder after a number is divided by the divisor?**

a) MOD

b) POWER

c) SUM

Answer:a) MOD

a) MOD

b) POWER

c) SUM

Answer:

**5. Which of the given cell reference can be included in relative reference?**

a) $D6

b) A3

c)A$1

Answer:b) A3

a) $D6

b) A3

c)A$1

Answer:

**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.

1. What is a formula? Explain with the help of examples.

Answer:

**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.

Answer:

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

Answer:

**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.

Answer:

**5. What is a range?**

Answer:Range is a collective of adjacent cell.

Answer:

**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.

Answer:

Example: SUM (), AVERAGE (), MAX (), MIN (), TODAY () etc.

**7. What are rules to enter a function?**

Answer:The rules to enter a function are:

Answer:

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.

Sir I want computer class 7 cyber apps book notes

ReplyDeleteHi Somyadhawni,

DeleteCurrently we don't have the Cyber Apps Book notes. But if you're in need of them, you can mail us at vshelpcare@gmail.com providing us the book's pdf, so that we can get back to you.

Sir I want computer class 7 cyber apps book notes

ReplyDeleteHi Somyadhawni,

DeleteCurrently we don't have the Cyber Apps Book notes. But if you're in need of them, you can mail us at vshelpcare@gmail.com providing us the book's pdf, so that we can get back to you.

Please I want class 7 cyber book pdf please can you provide me

ReplyDeleteSorry, but we are not providing any other solutions of Kips except AI and IT Beans... But if you need Question and Answers solution, you can send us the book pdf and the question you need the answer.

DeleteHello Sir,

ReplyDeleteCan you mail me important questions of this whole book

Thanks

Hi,

DeleteAll the questions that are posted by us are important. But if you still feel that these are not important, you can read the chapter so that you're prepared better for extra questions that your teacher asks.

sir see this hi

ReplyDeleteHi, hope you're safe during this pandemic...

DeleteThanks for give this solution.

ReplyDeleteWelcome! We're also providing NCERT correct solutions of

DeleteMaths,Social,Science. So if you feel that our answers are correct and reliable according to your needs, then do refer our NCERT Solutions as in many big websites they have mistakes...thankyou sir, this helped a lot i am very thankfull now i am sure i am gonna ace my test.

ReplyDeleteWelcome! We're also providing NCERT correct solutions of

DeleteMaths,Social,Science. So if you feel that our answers are correct and reliable according to your needs, then do refer our NCERT Solutions as in many big websites they have mistakes...Good

DeleteThanks!

Deletethankyou for this sheet sir, very helpful

ReplyDeleteWelcome Srushti π! If you feel that our answers are correct and reliable according to your needs then please share with your friends in social platforms (like Facebook, Twitter, Instagram etc) so that everybody can excel in their studies!

DeleteSuper

ReplyDeleteThanks! Do recommend our website to your friends if you found our website helpful...

DeleteDear sir,

ReplyDeleteMy school is conducting papar in mcq type and 3,4,5 and six are coming so sir can you please π«πππ send me mcq mock paper of these chapters this is my humble requestπ

Hello,

DeleteActually we haven't prepared any MCQs for the chapters that you've listed. But if you're really in need of them, we can prepare them for you. You can mail us on vshelpcare@gmail.com with your name, so that we can forward the MCQs personally...

Thanks a lot

ReplyDeleteWelcome!

Delete