FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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: -Method #2–CONCATENATE Function The CONCATENATE function. read more combines or concatenates the content of two or more cells. In other words, the values of several cells are joined together in one cell. This function ensures that no data string is lost while merging cell values in excel.

Detailed explanation-5: -The correct answer is Merge Cells.

There is 1 question to complete.
Previous
Next