FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What does it mean to merge cells?
A
Apply a border around a set of cells
B
Center the contents of the cell
C
split a single cell into 2 or more cells
D
Combine 2 or more cells into a single cell
Explanation: 

Detailed explanation-1: -Merging combines two or more cells to create a new, larger cell. This is a great way to create a label that spans several columns. For example, here cells A1, B1, and C1 were merged to create the label “Monthly Sales” to describe the information in rows 2 through 7.

Detailed explanation-2: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

Detailed explanation-3: -Combining of two or more cells into a single cell is called Merge.

There is 1 question to complete.