MS Excel When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when One sheet is selected When no sheet is selected When many sheets are selected None of the listed here One sheet is selected When no sheet is selected When many sheets are selected None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel When integrating word and excel, word is usually the Server Both b and c Client Destination Server Both b and c Client Destination ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press the Enter button Press the Erase key Press Esc Press the Edit Formula button Press the Enter button Press the Erase key Press Esc Press the Edit Formula button ANSWER DOWNLOAD EXAMIANS APP