FUNDAMENTALS OF COMPUTER

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 ____
A
Table
B
Formula
C
Wrap text
D
Format Cells
E
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.