DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Combines cells into one large cell but deletes all contents except the first (Upper Left) cell of the group.
|
|
Multiple Lines of Text
|
|
|
Merge Cells
|
|
|
Move Text
|
|
|
Autofill Series
|
Explanation:
Detailed explanation-1: -When you merge cells, only the value or formula in the top left cell of the range is preserved and displayed in the resulting merged cell. Any other values or formulas are discarded. The above example shows two merged cells in B2:C2 and D2:F2 which indicates the category of information in the columns below.
There is 1 question to complete.