MS Excel
A circular reference is

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

All of above
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When you copy a formula

Excel adjusts absolute cell references
Excel edits cell references in the newly copied formula
Excel doesn’t adjust relative cell references
Excel erases the original copy of the formula

ANSWER DOWNLOAD EXAMIANS APP