Computer Science, asked by rajnishukla699, 4 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
Hindi, 2 months ago
ङ) जवाब नहीं पता Clear selection 13. एक कार में 6 किलोमीटर 250 मीटर रास्ता पार करने में 50 मिनट लगते हैं। कार की प्रति घंटे औसत गति क्या होगी?​
Math, 2 months ago
10,7,4,7, 3, 2,3,5,7 mode of the given data is​...
Hindi, 2 months ago
साथी हाथ बढ़ाना कविता में सीने और बाँहों को फौलादी क्यों कहा गया है?
Computer Science, 4 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, 4 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, 10 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, 10 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, 10 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...