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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The autosum button The quicktotal button The Formula button The total button The autosum button The quicktotal button The Formula button The total button ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Now () Date () Time () Today () Now () Date () Time () Today () ANSWER DOWNLOAD EXAMIANS APP
MS Excel You cannot link excel worksheet data to a word document With the copy and paste buttons on the standard toolbar With the copy and paste special commands With the right drag method With a hyperlink With the copy and paste buttons on the standard toolbar With the copy and paste special commands With the right drag method With a hyperlink 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 Edit Formula button 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 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 Double clicking the cell Press the Alt key Pressing the F2 key Clicking the formula bar Double clicking the cell Press the Alt key Pressing the F2 key ANSWER DOWNLOAD EXAMIANS APP