MS Excel
While Finding and Replacing some data in Excel, which of the following statement is valid?

Excel does not have option to match case for find
You can Find and Replace within the sheet or workbook
Both
None of the listed here

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Text formulas:

Concatenate and manipulate text
Show formula error value
Return ASCII values of characters
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 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 add more than one condition to check

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you delete a column?

Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
Select the column heading you want to delete and select the Delete Row button on the standard toolbar

ANSWER DOWNLOAD EXAMIANS APP