MS Excel
How do you rearrange the data in ascending or descending order?

Data, Sort
Data, Form
Data Subtotals
Data, Table

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which of the following is a correct order of precedence in formula calculation?

Addition and subtraction, positive and negative values, exponentiation
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
None of the listed here

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP