Computer Science, asked by rajnishukla699, 5 months ago

explain all three types of cell reference with examples

Answers

Answered by nisha02345

2

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.

Answered by swanandi01

1

Answer:

A key element of a formula is the cell reference, and there are three types:

Relative.

Absolute.

Mixed.

Explanation:

i know this much only

hope it helps you

Mark me as brainliest

Previous Question

Next Question

Similar questions

Science, 2 months ago

۔ Give excomples to the mixtures .

Science, 2 months ago

filling the blanks the food give the children in school in the afternoon know as the______°...

English, 2 months ago

science is a blessing for us (negative)...

Computer Science, 5 months ago

4. Dictionary dl={1:10,2:25,3:30} is given. Write a code to i) append 4: 40 in the given dictionary ii) Update 2:25 to 2:20 in the given dictionary...

Social Sciences, 5 months ago

fill in the blanks a) ..........is a Microsoft office tool used to make slides and presentations, static and animatic. b) A ............has a pre defined background, font styles, colours and sizes for the placeholders in the slide. c) The slides.........can be controlled automatically by setting up a time. d) ..............veiw show the slides in thumbnail form. e)...

Chemistry, 11 months ago

Decreasing order of reactivity towards nucleophilic addition to carbonyl group among cyclopentanone, 3-pentanone and n-pentanal is (a) 3-pentanone, cyclopentanone, n-pentanal (b) n-pentanal, 3-pentanone, cyclopentanone (c) n-pentanal, cyclopentanone, 3-pentanone (d) cyclopentanone, 3-pentanone, n-pentanal...

Chemistry, 11 months ago

The stability of carbanions in the following : _ (I) RC = C (II) _ _ (III) R₂C = CH (IV) R₃C - CH₂ is in the order of : (a) (I) > (II) > (III) > (IV) (b) (II) > (III) > (IV) > (I) (c) (IV) > (II) > (III) > (I) (d) (I) > (III) > (II) > (IV)...

Chemistry, 11 months ago

Set of isoelectronic species is (a) N₂ , CO₂ , CN , O₂ (b) N₂,H₂S,CO (c) N₂ ,CO,CN⁻ ,O₂⁺² + (d) Ca,Mg,Cl...