DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
format cell
|
|
merge & center
|
|
wrap text
|
|
format as table
|
|
number
|
Detailed explanation-1: -Step 1: Highlight all the cells you want to merge within the row. Step 2: Under the Home tab, click the ‘Merge’ icon and choose ‘Merge Across. ‘ Step 3: The cells merge across the entire highlighted area.
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: -Merging cells in Excel helps the user catalog multiple strands of data in a uniform format. It allows you to merge both horizontal and vertical cells. By doing that, the spreadsheet displays data in one large cell rather than multiple columns.
Detailed explanation-4: -You can use the CONCATENATE function or the & (ampersand) to combine these cells.