MS Excel To activate the previous cell in a pre-selected range, press The Alt key The Tab key None of these The Enter key The Alt key The Tab key None of these The Enter key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Both of above None of above Cut and Paste Paste Special > Transpose Both of above None of above Cut and Paste Paste Special > Transpose ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicate that you can move the content to other cell? Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip None of above Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Tool Bar Status Bar None Formula Bar Tool Bar Status Bar None Formula Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Save workbook Copy the worksheet Modifiy the worksheet Enter text and data Save workbook Copy the worksheet Modifiy the worksheet Enter text and data ANSWER DOWNLOAD EXAMIANS APP