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

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When you link data maintained in an excel workbook to a word document

The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
To center worksheet titles across a range of cells, you must

Widen the columns
Format the cells with the comma style
Select the cells containing the title text plus the range over which the title text is to be enfettered
Select the cells containing the title text plus the range over which the title text is to be centered

ANSWER DOWNLOAD EXAMIANS APP