filmov
tv
CLASS 8 CH-2 SPREADSHEET- FORMULAS AND FUNCTIONS Part-1
Показать описание
ICSE CLASS 8 SPREADSHEET FORMULAS AND FUNCTIONS, WHAT IS FORMULA IN EXCEL, FUNCTIONS IN MS EXCEL, CREATING A BASIC FORMULA, CREATING A COMPOUND FORMULA, USING FORMULA ON TEXT, CONCATENATION.
Question/Answers of Ch-2 SPREADSHEET- FORMULAS AND FUNCTIONS.
Q.1.What is a Formula? Explain with the help of an example.
Ans.1. 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 formulas.
It must begin with = symbol followed by cell references and
operators.
For example: =A2+B2*C4-SUM(E3:E5)
Q.2.What is Cell Reference? Mention its types.
Ans.2.The cell address that we use in the formula is known as the cell Reference.
Types of cell reference are :
1. Relative Reference
2. Absolute Reference
3. 3. Mixed Reference
Q.3.What do you know about Absolute Reference? Explain with the
help of an example.
Ans.3. Absolute reference is a cell reference method used in the condition 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:
You have to add dollar ($) sign before the column and row
Number.
For example =$A$1+$A$2
Q.4.Explain circular reference with an example.
Ans.4. A circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly.
For example: If we enter the formula =A1+A2*A3 in cell A2, we are making the formula to refer to its own cell value, which is not possible. Excel returns a 0(Zero) if you accept this circular reference.
Q.5.What do you mean by a Function? Name some of the functions.
Ans.5. Functions are pre-designed formulas in Excel to perform simple
and complex calculations.
They accept the Arguments and Return values.
Functions save time and eliminate the chance to write wrong formulas.
Some of the commonly used function are:
SUM(), AVERAGE(), MAX(), MIN(), TODAY() etc.
Q.6.What are the rules to enter a Function?
Ans.6. Rules to enter a function are:
Rule1. All Excel functions must begin with a ‘=’ sign.
Rule2. Function name must be a valid Excel name, e.g., SUM, Average.
Rule3. Function name must be followed by opening and closing
parenthesis.
Rule4. Parenthesis contain arguments within it.
For example: =SUM (A1:A5)
Rule5. If there are more than one argument, then they should be separated by comma.
For example: =SUM(A1,A2,A3,A4,A5)
Q.7. What is a Chart?
Ans.7. Chart is an effective way to display data in a pictorial form.
Charts make it easier to draw comparison and analyse the growth, relationship and trends among the values in a range.
A Chart provides more accurate analysis of information.
Question/Answers of Ch-2 SPREADSHEET- FORMULAS AND FUNCTIONS.
Q.1.What is a Formula? Explain with the help of an example.
Ans.1. 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 formulas.
It must begin with = symbol followed by cell references and
operators.
For example: =A2+B2*C4-SUM(E3:E5)
Q.2.What is Cell Reference? Mention its types.
Ans.2.The cell address that we use in the formula is known as the cell Reference.
Types of cell reference are :
1. Relative Reference
2. Absolute Reference
3. 3. Mixed Reference
Q.3.What do you know about Absolute Reference? Explain with the
help of an example.
Ans.3. Absolute reference is a cell reference method used in the condition 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:
You have to add dollar ($) sign before the column and row
Number.
For example =$A$1+$A$2
Q.4.Explain circular reference with an example.
Ans.4. A circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly.
For example: If we enter the formula =A1+A2*A3 in cell A2, we are making the formula to refer to its own cell value, which is not possible. Excel returns a 0(Zero) if you accept this circular reference.
Q.5.What do you mean by a Function? Name some of the functions.
Ans.5. Functions are pre-designed formulas in Excel to perform simple
and complex calculations.
They accept the Arguments and Return values.
Functions save time and eliminate the chance to write wrong formulas.
Some of the commonly used function are:
SUM(), AVERAGE(), MAX(), MIN(), TODAY() etc.
Q.6.What are the rules to enter a Function?
Ans.6. Rules to enter a function are:
Rule1. All Excel functions must begin with a ‘=’ sign.
Rule2. Function name must be a valid Excel name, e.g., SUM, Average.
Rule3. Function name must be followed by opening and closing
parenthesis.
Rule4. Parenthesis contain arguments within it.
For example: =SUM (A1:A5)
Rule5. If there are more than one argument, then they should be separated by comma.
For example: =SUM(A1,A2,A3,A4,A5)
Q.7. What is a Chart?
Ans.7. Chart is an effective way to display data in a pictorial form.
Charts make it easier to draw comparison and analyse the growth, relationship and trends among the values in a range.
A Chart provides more accurate analysis of information.
Комментарии