Question

* Define cell reference and it's types.
* Write the rules to enter a function.​

Answer 1

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: ... Data on other worksheets in the same workbook.

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) .

Answer 2

Answer:

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.

For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.

For example, the range A1:C2 includes 6 cells from A1 through C2.