MS Excel Which of the following is not true about Find and Replace in Excel You can search in formula too You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not You can search in formula too You can search by rows or columns or sheets You can search for bold and replace with italics You can decide whether to look for the whole word or not ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? MOD ( ) ROUND ( ) Div ( ) FACT ( ) MOD ( ) ROUND ( ) Div ( ) FACT ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not information you can specify using the solver? Target cell Input cells Constraints Changing cells Target cell Input cells Constraints Changing cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? All of the listed here Edit > Delete Edit > Clear > Contents Edit > Clear >All All of the listed here Edit > Delete Edit > Clear > Contents Edit > Clear >All ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? 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 Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the 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 Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu ANSWER DOWNLOAD EXAMIANS APP