Question 1

Question 1What is a Formula? Explain with the help of an example.

Accepted Answer

A Formula is a user defined instruction to perform calculations. It is an expression that can include cell addresses, numbers, arithmetic operators and parenthesis. It begins with equal to (=) symbol, followed by cell references and operators. For example:=A2+B2*5-SUM(E3:E5)

Question 2

Question 2What is Cell Reference? Mention its types.

Accepted Answer

The cell address that we use in the formula is known as the cell reference. The address of the cell consists of the column letter followed by the row number. For example, cell address A1 denotes the column name as A and the row number as 1. The different types of cell references are Relative reference, Absolute reference and Mixed reference.

Question 3

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

Accepted Answer

Absolute reference is used when we do not want to change the address of the cell while copying the formula to another cell. To use absolute reference in a cell, you need to add dollar ($) sign before the column and row number. For example: =$A$1+$A$2

Question 4

Question 4Explain circular reference with an example.

Accepted Answer

A circular reference occurs when a formula in a cell refers to its own cell value directly or indirectly. For example, if you enter the formula =A1+A2*3 in cell A2, you are making the formula to refer to its own cell value, which creates a circular reference.

Question 5

Question 5What do you mean by a Function? Name some of the Functions.

Accepted Answer

Functions are the pre-designed formulas in Excel to perform both simple and complex calculations. Functions begin with the equal to (=) sign followed by the function name and then the list of arguments separated by comma within the parenthesis. For example, =Function name (argument1, argument2....). Some of the commonly used functions are:SUM(range)AVERAGE(range)MAX(range)MIN(range)SQRT(number)

Question 6

Question 6What are the rules to enter a Function?

Accepted Answer

The rules to enter a Function are: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 an opening and closing parenthesis.Arguments are enclosed in the parenthesis. For example, =SUM (A1:A5).

Spreadsheet - Formulas and Functions