MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar None Both ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Divide Percentage Square Goal seek Divide Percentage Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. View File Insert Tools View File Insert Tools ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS