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 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 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 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 Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can copy data or formulas All of these With buttons on the standard toolbars With commands on the shortcut menu With the copy, paste and cut commands on the edit menu All of these With buttons on the standard toolbars With commands on the shortcut menu With the copy, paste and cut commands on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Aditibility Efficiency Description Clarity Aditibility Efficiency Description Clarity ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the horizontal and vertical scroll bars to View different worksheets View different rows and columns edit the contents of a cell Edit the contents of a cell Split a worksheet into two panes View different worksheets View different rows and columns edit the contents of a cell Edit the contents of a cell Split a worksheet into two panes ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key Ctrl key Shift key End key Esc key Ctrl key Shift key End key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formats Validation All of above Formulas Formats Validation All of above Formulas ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS