MS Excel How do you display current date and time in MS Excel ? Date () Today () Time() Now () Date () Today () Time() Now () ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? 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 Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the End key Shift key Ctrl key Esc key End key Shift key Ctrl key Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Pmt Sum Max Average Pmt Sum Max 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
EXAMIANS