Computer Science, asked by bhawrasaalefiya, 2 months ago

What do you mean by cell -referencing and what are the difference between
Absolute cell referencing and Mixed cell referencing?​

Answers

Answered by 1984premakumari
1

Answer:

Cell, in biology, the basic membrane-bound unit that contains the fundamental molecules of life and of which all living things are composed. ... A single cell is often a complete organism in itself, such as a bacterium or yeast. Other cells acquire specialized functions as they mature.

hope it is helpful

mark me as brainlist

Attachments:
Answered by shannu134613a6
0

Answer:

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. Data contained in different areas of a worksheet.

i)Absolute Cell References. Situations arise in which the cell reference must remain the same when copied or when using AutoFill. Dollar signs are used to hold a column and/or row reference constant.

example:-=SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell

ii)A mixed cell reference is either an absolute column and relative row or absolute row and relative column. For example, $A1 is absolute for column A and relative for row 1, and A$1 is absolute for row 1 and relative for column A.

pls mark as brainlist

Explanation:

Similar questions