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 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 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 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 Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline Both None Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline Both None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Pmt Sum Max Average Pmt Sum Max ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates you that you can make selection? Small thin plus icon Doctor’s symbol (Big Plus) None of above Mouse Pointer with anchor at the tip Small thin plus icon Doctor’s symbol (Big Plus) None of above Mouse Pointer with anchor at the tip ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Calculator Media player Macro Recorder Sound Recorder Calculator Media player Macro Recorder Sound Recorder ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel files have a default extension of in Excel-2003 Xls Wk1 123 Xlw Xls Wk1 123 Xlw ANSWER DOWNLOAD EXAMIANS APP