# vs.eyeandcontacts.com

## 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,
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.
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.
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
c) Sheet1! D4

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

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

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

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

1. What is a formula? Explain with the help of examples.
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.
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.
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?
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?
Range is a collective of adjacent cell.

6. What do you mean by Function? Name some of the function.
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?
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.

1. Sir I want computer class 7 cyber apps book notes

1. Currently 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.

2. Sir I want computer class 7 cyber apps book notes

1. Currently 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.

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

1. Sorry, 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.

4. Hello Sir,
Can you mail me important questions of this whole book
Thanks

1. Hi,

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

5. sir see this hi

1. Hi, hope you're safe during this pandemic...

6. Thanks for give this solution.

1. Welcome! We're also providing NCERT correct solutions of Maths, 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...

7. thankyou sir, this helped a lot i am very thankfull now i am sure i am gonna ace my test.

1. Welcome! We're also providing NCERT correct solutions of Maths, 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...

2. 3. 8. thankyou for this sheet sir, very helpful

1. Welcome 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!

9. 1. Thanks! Do recommend our website to your friends if you found our website helpful...

10. Dear sir,
My 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🙏

1. Hello,

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

11. Thanks a lot

1. HomeSearchTop