MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Max Average Sum Pmt Max Average Sum 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client Source None of these Server Client Source None of these Server ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: 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 Multiply the selection by a copied value Formatting options Cell comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? Add Divide SQRT Subtract Add Divide SQRT Subtract ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS