DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
One can create a table in Ms. Excel by combining several cells according to the required format. The menu used to combine multiple cells into columns or rows is called ____
|
Table
|
|
Formula
|
|
Wrap text
|
|
Format Cells
|
|
Merge and Center
|
Explanation:
Detailed explanation-1: -You can combine two or more table cells located in the same row or column into a single cell. For example, you can merge several cells horizontally to create a table heading that spans several columns. 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: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.
Detailed explanation-3: -Right-click the selected cells and click Merge Cells.
Detailed explanation-4: -The correct answer is Merge Cells.
There is 1 question to complete.