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

Data, Form
Data Subtotals
Data, Sort
Data, Table

ANSWER DOWNLOAD EXAMIANS APP

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

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

MS Excel
Where can you set the shading color for a range of cells in Excel?

Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Drawing toolbar
All of above
Choose required color on Fill Color tool in Formatting toolbar

ANSWER DOWNLOAD EXAMIANS APP