MS Excel When a row of data is to be converted into columns 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 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Files created with Lotus 1-2-3 have an extension WK1 Doc XLS 123 WK1 Doc XLS 123 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet None of above Select the sheet then choose Format > Sheet > Hide Both of above Select the sheet, then choose Edit > Delete Sheet None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Clicking the formula bar Pressing the F2 key Double clicking the cell Press the Alt key Clicking the formula bar Pressing the F2 key Double clicking the cell Press the Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column name on column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column left border of column header Double clicking on the column name on column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column left border of column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 16384 1024 256 128 16384 1024 256 128 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS