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

Data, Sort
Data, Table
Data Subtotals
Data, Form

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can set Page Border in Excel from

From Border tab in Farmat cells dialog box
You can not set Page Border in Excel
From Line style tool in Drawing toolbar
From Border tool in Formatting toolbar

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 choose Merge and Center check box
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
Click on Merge and Center tool on formatting toolbar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
A circular reference is

Geometric modeling tool
Always erroneous
A formula that either directly or indirectly depends on itself
A cell that points to a drawing object

ANSWER DOWNLOAD EXAMIANS APP