USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cell A2 contains the following e-mail address:support@excel-skills.comCell B2 contains the following formula:=MID(A2, FIND(“@”, A2)+1, LEN(A2)-FIND(“@”, A2)+1)What is the result of the formula in cell B2?
|
|
@
|
|
|
excel-skills.com
|
|
|
support
|
|
|
#VALUE
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -The Go To Special Function[1] in Excel allows you to quickly select all cells that meet certain criteria, such as cells containing: Formulas (numbers, text, logicals, errors)
Detailed explanation-3: -For example, start typing SUMPRODUCT. Click the box next to array1, and then on the sheet, select cells B2 through B7 (the values in the Price Per Unit column).
There is 1 question to complete.