MS Excel
You can merge the main document with data source in Excel. In mail merge operation, Word is usually

Client
Server
Source
None of these

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

Double click the Format Painter and then press Esc key in keyboard
Click on Remove Formatting tool on Standard Toolbar
From Edit menu choose Delete
From Edit menu choose Clear and then Formats

ANSWER DOWNLOAD EXAMIANS APP

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

You can add more than one condition to check
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
You can apply Font, border and pattern formats that meets the specified conditions

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which of the following is invalid statement?

Some picture can be applied as a background of a sheet
Sheet tabs can be colored
The width of a row and be specified manually or fit automatically
You can set the column width automatically fit the amount of text

ANSWER DOWNLOAD EXAMIANS APP