IT Beans solution class 7

Q 1:What is a Formula? Explain with the help of examples.
Ans:FORMULAS are used to perform calculations involving addition,subtraction,division and multiplication. It establishes a relationship between two or more cells. For example: A3=A1+A2

Q 2:What is a cell reference? Mention its types.
Ans:The cell address in the formula is known as the cell reference.
There are 3 Types of cell references:
1:Relative Reference.
2:Absolute Reference.
3:Mixed reference.

Q 3:What do you know about Absolute Reference? Explain with the help of an example.
Ans:Absolute reference is used when we do not want to change the address of the cell on copying the formula to other cell. To make absolute reference of a formula, add dollar ($) before the column and row number.

Q 4:How will you rename a sheet tab?
Ans:Follow the steps given below:
1.Right-click on the sheet in the worksheet
2.A short cut menu will appear.Click on rename option.
3.The cursor will appear in sheet tab type "KIPS" and press enter key.
4.Note that sheet 2 has been changed to"KIPS"

Q 5:What is a Range?
Ans:A Range is a group or block of a cell that have been selected or highlighted.

Q 6:What do you mean by Function? Name some of the Functions.
Ans:Functions are pre-designed formulas in Excel to perform both simple and complex calculations.

Q 7:What are the rules to enter a function?
Ans:Rules to enter a function are:
1.All Excel functions must begin with = sign .
2.Functions name must be a valid Excel name.For example:SUM,AVERAGE.
3.Function name must be followed by opening and closing parenthesis.
4.Parenthesis contain arguments within it.For example:=SUM(A1:A5)