DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
adjust column width
|
|
|
merge
|
|
|
wrap text
|
|
|
None of the above
|
Detailed explanation-1: -Merge cells Select the cells that you want to merge. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.
Detailed explanation-2: -The formula for this function is =CONCATENATE(Cell reference 1, Cell reference 2). So, for example, you can input “=CONCATENATE (A1, B1)” into cell C1 to combine the values of A1 and B1 into that cell.
Detailed explanation-3: -For this, choose the cells which we need to combine. Go to the cell where we want to see the outcome. Now press the equal sign and select both the cells separated by the ampersand (“&”) sign. For example, if we want to combine cell A1 and A2, then the combine cell formula will look like ”=A1&A2”.
Detailed explanation-4: -Using the Merge & Center Option In this case, we want to merge the cells A1, B1, and C1. After selecting the cells, navigate to Home. Under the Alignment Column, select Merge & Center. You can either select the option directly or click on the dropdown and select any merging option to merge the cells.