USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If cell A1 has Bob and A2 contains Jones, which of these will result in “Jones, Bob”?A) =CONCATENATE(A1, “ “, A2)B) =CONCATENATE(A2, “, “, A1)C) =CONCATENATE(A2, “ “, A1)D) =CONCATENATE(A2, “, “, A1)
|
|
A
|
|
|
B
|
|
|
C
|
|
|
D
|
Explanation:
Detailed explanation-1: -The ampersand (&) calculation operator lets you join text items without having to use a function. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1).
Detailed explanation-2: -For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-3: -Answer: Cell A2 contains the value 8 and cell B2 is empty. Cells can be merged and unmerged. Although you can’t split a single cell, you can make it appear like it has been split by combining the cells above it.
There is 1 question to complete.