MS Excel
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

Divide
Goal seek
Square
Percentage

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
Apply Conditional Formatting command on Format menu
Use =if() function to format the required numbers red

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To create a formula, you first:

Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu

ANSWER DOWNLOAD EXAMIANS APP