MS Excel The Paste Special command lets you copy and paste: Multiply the selection by a copied value Formatting options Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Formatting options Cell comments The resulting values of a formula instead of the actual formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? FACT ( ) ROUND ( ) Div ( ) MOD ( ) FACT ( ) ROUND ( ) Div ( ) MOD ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F9 F10 F8 F11 F9 F10 F8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? 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 Insert Delete from the 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 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 Insert Delete from the 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 8 3 255 none of above 8 3 255 none of above ANSWER DOWNLOAD EXAMIANS APP