MS Excel Where can you change automatic or manual calculation mode in Excel? Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here Both Excel does not have option to match case for find You can Find and Replace within the sheet or workbook None of the listed here ANSWER DOWNLOAD EXAMIANS APP