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

Goal seek
Divide
Square
Percentage

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box click on Merge Cells check box
Click on Merge and Center tool on formatting toolbar
From Format Cells dialog box choose Merge and Center check box
From Format Cells dialog box select the Centered alignment

ANSWER DOWNLOAD EXAMIANS APP

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

ANSWER DOWNLOAD EXAMIANS APP