Question

explain relative cell reference by example​

Answer 1

Answer:

By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.

Answer 2

Bʏ ᴅᴇғᴀᴜʟᴛ, ᴀʟʟ ᴄᴇʟʟ ʀᴇғᴇʀᴇɴᴄᴇs ᴀʀᴇ ʀᴇʟᴀᴛɪᴠᴇ ʀᴇғᴇʀᴇɴᴄᴇs. Wʜᴇɴ ᴄᴏᴘɪᴇᴅ ᴀᴄʀᴏss ᴍᴜʟᴛɪᴘʟᴇ ᴄᴇʟʟs, ᴛʜᴇʏ ᴄʜᴀɴɢᴇ ʙᴀsᴇᴅ ᴏɴ ᴛʜᴇ ʀᴇʟᴀᴛɪᴠᴇ ᴘᴏsɪᴛɪᴏɴ ᴏғ ʀᴏᴡs ᴀɴᴅ ᴄᴏʟᴜᴍɴs. Fᴏʀ ᴇxᴀᴍᴘʟᴇ, ɪғ ʏᴏᴜ ᴄᴏᴘʏ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ =A1+B1 ғʀᴏᴍ ʀᴏᴡ 1 ᴛᴏ ʀᴏᴡ 2, ᴛʜᴇ ғᴏʀᴍᴜʟᴀ ᴡɪʟʟ ʙᴇᴄᴏᴍᴇ =A2+B2.

THANK U