DATABASE FUNDAMENTALS
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: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.
There is 1 question to complete.