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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
A circular reference is

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Replace cell references

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which of the following is not true regarding Conditional Formatting?

You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
You can set condition to look for Bold and apply Italics on them
You can add more than one condition to check

ANSWER DOWNLOAD EXAMIANS APP