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.

24 comments:

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

    ReplyDelete
    Replies
    1. Hi Somyadhawni,

      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.

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

    ReplyDelete
    Replies
    1. Hi Somyadhawni,

      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.

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

    ReplyDelete
    Replies
    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.

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

    ReplyDelete
    Replies
    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.

      Delete
  5. Thanks for give this solution.

    ReplyDelete
    Replies
    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...

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

    ReplyDelete
    Replies
    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...

      Delete
  7. thankyou for this sheet sir, very helpful

    ReplyDelete
    Replies
    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!

      Delete
  8. Replies
    1. Thanks! Do recommend our website to your friends if you found our website helpful...

      Delete
  9. 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πŸ™

    ReplyDelete
    Replies
    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...

      Delete

Also read!

Class 6 Solutions

• Class 7

Class 7 Computer Kips Solutions
Class 7 Gul Mohar English Solutions
English Grammar Class 7
English Writing Skills Class 7
Class 7 Map Pointing Solutions
Class 7 NCERT Civics Solutions
Class 7 NCERT Civics Notes
Class 7 NCERT Civics Extra Questions
Class 7 NCERT Geography Solutions
Class 7 NCERT Geography Notes
Class 7 NCERT Geography Extra Questions
Class 7 NCERT History Solutions
Class 7 NCERT History Notes
Class 7 NCERT History Extra Questions
Class 7 NCERT Maths Solutions
Class 7 NCERT Science Solutions
Class 7 NCERT Science Notes
Class 7 NCERT Science Extra Questions

• Class 8

Class 8 Kips Artificial Intelligence Solutions
Class 8 Gul Mohar English Solutions
English Grammar Class 8
English Writing Skills Class 8
Class 8 Map Pointing Solutions
Class 8 NCERT Civics Solutions
Class 8 NCERT Civics Notes
Class 8 NCERT Civics Extra Questions
Class 8 NCERT Geography Solutions
Class 8 NCERT Geography Notes
Class 8 NCERT Geography Extra Questions
Class 8 NCERT History Solutions
Class 8 NCERT History Notes
Class 8 NCERT History Extra Questions
Class 8 NCERT Maths Solutions
Class 8 NCERT Science Solutions
Class 8 NCERT Science Notes
Class 8 NCERT Science Extra Questions
Class 8 NCERT Science Exemplar
Class 8 NCERT Science MCQs

Class 9 Solutions

• Class 10

Class 10 Kips Artificial Intelligence Solutions
Class 10 NCERT English Solutions
→ Class 10 Map Pointing Solutions
Class 10 NCERT Civics Solutions
Class 10 NCERT Civics Notes
Class 10 NCERT Civics Extra Questions
Class 10 NCERT Geography Solutions
Class 10 NCERT Geography Notes
Class 10 NCERT Geography Extra Questions
Class 10 NCERT History Solutions
→ Class 10 NCERT History Notes
Class 10 NCERT History Extra Questions
Class 10 NCERT Maths Solutions
Class 10 NCERT Science Solutions
Class 10 NCERT Science Notes
Class 10 NCERT Science Extra Questions

• Computer languages
Python Basics

• Extra Activities
Extra Activities

• Extra Knowledge
Extra Information
General Knowledge
Historical Places in India
Latest technology
Physical Sciences
Facts

• Mathematics quick links
Mathematical Terms
Maths Tricks

CONTACT US