MS Excel
A circular reference is

Geometric modeling tool
Always erroneous
A formula that either directly or indirectly depends on itself
A cell that points to a drawing object

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

Concatenate and manipulate text
Replace cell references
Show formula error value
Return ASCII values of characters

ANSWER DOWNLOAD EXAMIANS APP