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

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
All of above

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When you copy a formula

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To center worksheet titles across a range of cells, you must

Format the cells with the comma style
Select the cells containing the title text plus the range over which the title text is to be centered
Select the cells containing the title text plus the range over which the title text is to be enfettered
Widen the columns

ANSWER DOWNLOAD EXAMIANS APP