Question

Define following terms

a) Merge and centre

b) Wrap Text

c) Cell Reference

d) Auto sum​

Answer 1

ᴀ. ᴍᴇʀɢᴇ & ᴄᴇɴᴛᴇʀ ɪs ᴀ ғᴇᴀᴛᴜʀᴇ ɪɴ ᴇxᴄᴇʟ ᴛʜᴀᴛ ᴄᴏᴍʙɪɴᴇs ᴍᴜʟᴛɪᴘʟᴇ ᴄᴇʟʟs ᴀɴᴅ ᴄᴇɴᴛᴇʀs ᴛʜᴇ ᴄᴏɴᴛᴇɴᴛs ᴏғ ᴛʜᴇ ғɪʀsᴛ ᴄᴇʟʟ. ... ᴛʜɪs ɪs ᴜsᴇᴅ ᴛᴏ ᴄᴏᴍʙɪɴᴇ ᴍᴜʟᴛɪᴘʟᴇ ᴄᴇʟʟs ɪɴᴛᴏ ᴀ sɪɴɢʟᴇ ᴄᴇʟʟ ᴀɴᴅ ᴄʀᴇᴀᴛᴇ ᴛʜᴇ ᴍᴀɪɴ ʜᴇᴀᴅᴇʀs ғᴏʀ ᴇxᴄᴇʟ ᴅᴀsʜʙᴏᴀʀᴅs ɪɴ ᴍɪᴄʀᴏsᴏғᴛ ᴇxᴄᴇʟ.

ʙ. In Microsoft Excel and other spreadsheet programs, Wrap Text is a feature that shows all information in a cell, even if it overflows the cell boundary. For example, the image shows that cell G2 has text that is cut off because the adjacent cell H2 has text.

C. ᴀ ᴄᴇʟʟ ʀᴇғᴇʀᴇɴᴄᴇ ʀᴇғᴇʀs ᴛᴏ ᴀ ᴄᴇʟʟ ᴏʀ ᴀ ʀᴀɴɢᴇ ᴏғ ᴄᴇʟʟs ᴏɴ ᴀ ᴡᴏʀᴋsʜᴇᴇᴛ ᴀɴᴅ ᴄᴀɴ ʙᴇ ᴜsᴇᴅ ɪɴ ᴀ ғᴏʀᴍᴜʟᴀ sᴏ ᴛʜᴀᴛ ᴍɪᴄʀᴏsᴏғᴛ ᴏғғɪᴄᴇ ᴇxᴄᴇʟ ᴄᴀɴ ғɪɴᴅ ᴛʜᴇ ᴠᴀʟᴜᴇs ᴏʀ ᴅᴀᴛᴀ ᴛʜᴀᴛ ʏᴏᴜ ᴡᴀɴᴛ ᴛʜᴀᴛ ғᴏʀᴍᴜʟᴀ ᴛᴏ ᴄᴀʟᴄᴜʟᴀᴛᴇ.

ᴅ. ɪғ ʏᴏᴜ ɴᴇᴇᴅ ᴛᴏ sᴜᴍ ᴀ ᴄᴏʟᴜᴍɴ ᴏʀ ʀᴏᴡ ᴏғ ɴᴜᴍʙᴇʀs, ʟᴇᴛ ᴇxᴄᴇʟ ᴅᴏ ᴛʜᴇ ᴍᴀᴛʜ ғᴏʀ ʏᴏᴜ. sᴇʟᴇᴄᴛ ᴀ ᴄᴇʟʟ ɴᴇxᴛ ᴛᴏ ᴛʜᴇ ɴᴜᴍʙᴇʀs ʏᴏᴜ ᴡᴀɴᴛ ᴛᴏ sᴜᴍ, ᴄʟɪᴄᴋ ᴀᴜᴛᴏsᴜᴍ ᴏɴ ᴛʜᴇ ʜᴏᴍᴇ ᴛᴀʙ, ᴘʀᴇss ᴇɴᴛᴇʀ, ᴀɴᴅ ʏᴏᴜ'ʀᴇ ᴅᴏɴᴇ. ᴡʜᴇɴ ʏᴏᴜ ᴄʟɪᴄᴋ ᴀᴜᴛᴏsᴜᴍ, ᴇxᴄᴇʟ ᴀᴜᴛᴏᴍᴀᴛɪᴄᴀʟʟʏ ᴇɴᴛᴇʀs ᴀ ғᴏʀᴍᴜʟᴀ (ᴛʜᴀᴛ ᴜsᴇs ᴛʜᴇ sᴜᴍ ғᴜɴᴄᴛɪᴏɴ) ᴛᴏ sᴜᴍ ᴛʜᴇ ɴᴜᴍʙᴇʀs. ʜᴇʀᴇ's ᴀɴ ᴇxᴀᴍᴘʟᴇ.

Answer 2

Explanation:

merge

Merge cell is a function in database programming that enables different nearby cells to be joined into a single larger cell.

warp text

Wrap Text is a feature that shows all information in a cell,

cell reference

cell reference refers to a cell or a range of cells on a worksheet

auto sum

A function in a spreadsheet program that inserts a formula in the selected cell that adds the numbers in the column above it. is known as auto som