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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Columns Group of Worksheets Group of Rows Group of Workbooks Group of Columns Group of Worksheets Group of Rows Group of Workbooks ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet 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 Go to Tools > Options > View tab and mark or remove the check box named Gridline ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top right corner Towards the top left corner Towards the bottom right corner Towards the bottom left corner Towards the top right corner Towards the top left corner Towards the bottom right corner Towards the bottom left corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Copy a range of cells Create and edit formula containing functions Format cells containing numbers Enter assumptions data Copy a range of cells Create and edit formula containing functions Format cells containing numbers Enter assumptions data ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP