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 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 Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number 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 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 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
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics ANSWER DOWNLOAD EXAMIANS APP