Computer Science, asked by aryangupta78901234in, 1 year ago

what is ment by cell reference in excel?

Answers

Answered by aryangupta78901

6

Each cell in the worksheet has a unique address formed by the combination of its intersection of row and column. when a cell address is referred to in a formula, it is called cell reference.

Answered by MrsBadger

0

Cell reference refers to a cell or a range of cells on a worksheet of MS Excel. It can be used to copy the formula of one cell to others, find the total of the numbers in all the selected cells, etc.

Examples: A1:D5 - this cell reference means that all the cells between A1 and D5 will be selected. The selected cells will be A1, A2, A3, A4, A5, B1, B2, B3, B4, B5, C1, C2, C3, C4, C5, D1, D2, D3, D4, and D5.

kallabalal: NO..... COMMENTS SECTION IS NOT THIS

kallabalal: Rant on b*tch..why did you stop?Did your balls roll away?

MrsBadger: What do I have to say?

MrsBadger: It's stupid to change stupid people's mentality

kallabalal: Your BS

MrsBadger: Yes. B = beautiful and S = soul

MrsBadger: my soul is indeed beautiful

kallabalal: Yeah ... im overwhelmed with beauty

MrsBadger: Yes, I can certainly see that.

MrsBadger: ;)

Previous Question

Next Question

Similar questions

Computer Science, 7 months ago

Mrs. Rani is very weight conscious. She calculates her BMI (Body Mass Index) every week to check whether her weight is in control. Mrs. Rani gets fed up calculating every time using the formula, so she comes to you for help. You decide to develop an application that will help her. H...

Geography, 7 months ago

Difference between depositional plains and erosional plains and comment on importance of plains...

Computer Science, 7 months ago

Difference between control unit and arithmetic logic...

Biology, 1 year ago

how many ATP molecules are formed during aerobic respiration and anaerobic respiration. no unnecessary answers and no need of definition only number of molecules.

Chemistry, 1 year ago

Hi Friends .... Good Morning.... can you please answer this question :- For the reaction H2(g) + I2 (g) <-------> 2HI (g) Equilibrium constant , Kc = 49 . What would be the value of the equilibrium constant for 1/2 H2 (g) + 1/2 I2 (g) <--------> HI(g) . UUnder the same conditions ? Thank You , ^_^...

Environmental Sciences, 1 year ago

The world’s population in 1985 was approximately 5 billion people. With a consistent rate of growth, the total population was expected to reach 10 billion in about 35 years - year 2020. The period of 35 years is known as A. Demographic transition rate B. Life expectancy C. Natural increase rate D. Doubling time...

Environmental Sciences, 1 year ago

Given the population size of two points in time, one can compute the rate of population change by the following indicators: A. Arithmetic rate of population growth B. Geometric rate of population growth C. Exponential rate of population growth...

Environmental Sciences, 1 year ago

Which 'E' country has the highest population? A. Ethiopia B. Eritrea C. Egypt D. East Timor...