Question

what is difference between relative cell and absolute cell​

Answer 1

Answer:

ᴛʜᴇʀᴇ ᴀʀᴇ ᴛᴡᴏ ᴛʏᴘᴇs ᴏғ ᴄᴇʟʟ ʀᴇғᴇʀᴇɴᴄᴇs: ʀᴇʟᴀᴛɪᴠᴇ ᴀɴᴅ ᴀʙsᴏʟᴜᴛᴇ. ʀᴇʟᴀᴛɪᴠᴇ ᴀɴᴅ ᴀʙsᴏʟᴜᴛᴇ ʀᴇғᴇʀᴇɴᴄᴇs ʙᴇʜᴀᴠᴇ ᴅɪғғᴇʀᴇɴᴛʟʏ ᴡʜᴇɴ ᴄᴏᴘɪᴇᴅ ᴀɴᴅ ғɪʟʟᴇᴅ ᴛᴏ ᴏᴛʜᴇʀ ᴄᴇʟʟs. ʀᴇʟᴀᴛɪᴠᴇ ʀᴇғᴇʀᴇɴᴄᴇs ᴄʜᴀɴɢᴇ ᴡʜᴇɴ ᴀ ғᴏʀᴍᴜʟᴀ ɪs ᴄᴏᴘɪᴇᴅ ᴛᴏ ᴀɴᴏᴛʜᴇʀ ᴄᴇʟʟ. ᴀʙsᴏʟᴜᴛᴇ ʀᴇғᴇʀᴇɴᴄᴇs, ᴏɴ ᴛʜᴇ ᴏᴛʜᴇʀ ʜᴀɴᴅ, ʀᴇᴍᴀɪɴ ᴄᴏɴsᴛᴀɴᴛ ɴᴏ ᴍᴀᴛᴛᴇʀ ᴡʜᴇʀᴇ ᴛʜᴇʏ ᴀʀᴇ ᴄᴏᴘɪᴇᴅ.

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

Step-by-step explanation:

$hope \: this \: will \: help \: you$

:)