Kips IT Beans Class 7 Chapter 3 Solutions FORMULAS AND FUNCTIONS

|
TextbookKips IT Beans
Class7
SubjectComputer
Chapter3 FORMULAS AND FUNCTIONS
Other ChaptersChapter 1
Chapter 2
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12

Kips IT Beans Class 7 Chapter 3 Solutions FORMULAS AND FUNCTIONS

Brain Developer

A. Fill in the blanks:

1. Formulas are used to perform Calculations.

2. A formula always begins with an = 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

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

3. Combined Reference is a type of cell reference. – TRUE

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

7. SUM function is used to find sum of values. – TRUE

C. Application Based Questions:

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.

= Max ( ), = Min ( )

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.

= 15000×10% ÷ 100=1500 so, = Present salary + increasal = 15000 + 1500 = 16500.

D. Multiple Choice Questions:

1. To use the Sheet reference, which address is appropriate out of the following options.

  • D4! Sheet1
  • Sheets, D4
  • Sheet1! D4

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

  • SUM ()
  • Ctrl + ‘
  • Alt + =

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

  • Average ()
  • Count ()
  • Max ()

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

  • MOD
  • POWER
  • SUM

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

  • $D6
  • A3
  • A$1

E. Answer the following:

What is a Formula? Explain with the help of examples.

FORMULAS are used to perform calculations involving addition, subtraction, division and multiplication. It establishes a relationship between two or more cells. A formula is an expression that can include cell addresses, numbers, arithmetic operators and parenthesis. We can perform simple as well as complex calculations using functions.
Example – B1+B2+B3+B4+B5.

What is Cell Reference? Mention its types.

The cell address in the formula is known as the cell reference. For example, A1, B6, etc., where A denotes the Column name and 1 denotes the Row number. With references, you can use the data from different parts of the worksheet.
There are three types of cell references:
• Relative Reference
• Absolute Reference
• Mixed Reference

What do you know about Absolute Reference? Explain with the help of an example.

Absolute reference is used when we do not want to change the address of the cell on copying the formula to another cell. To make absolute reference of a formula, add dollar ($) sign before the column and row number =$A$1+$A$2 is an example of Absolute Reference.

How will you rename a Sheet tab?

• Right-click on the Sheet tab in the worksheet.
• A shortcut menu will appear. Click on the Rename option.
• The cursor will appear in the selected Sheet tab. Type the “DesiredName” and press the Enter key.
• Note that the name of the Sheet has been changed to “DesiredName”.

What is a Range?

A Range is a collective of adjacent cell or s group of cell on a worksheet.

What do you mean by Function? Name some of the functions.

Functions are pre-designed formulas in Excel to perform both simple and complex calculations. Functions save time and eliminate the chance to write wrong formulas.
Some of the functions are:
• SUM(range): Gives the sum of a range.
• AVERAGE(range): Finds the average of a range.
• ODD(number): Returns the number rounded up to the nearest odd integer.
• INT(number): Rounds a number to the nearest integer.
• Product(range): Multiplies the values in a range of cells.

What are the rules to enter a function?

• All Excel functions must begin with = sign.
• Function name must be a valid Excel name. For example, SUM, AVERAGE.
• Function name must be followed by opening and closing parenthesis.
• Parenthesis contain arguments within it. For example, =SUM (A1:A5).

Other Chapter Solutions

Leave a comment