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 set Page Border in Excel from From Border tool in Formatting toolbar From Line style tool in Drawing toolbar You can not set Page Border in Excel From Border tab in Farmat cells dialog box From Border tool in Formatting toolbar From Line style tool in Drawing toolbar You can not set Page Border in Excel From Border tab in Farmat cells dialog box ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Save workbook Copy the worksheet Enter text and data Modifiy the worksheet Save workbook Copy the worksheet Enter text and data Modifiy the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Esc key Ctrl key End key Shift key Esc key Ctrl key End key Shift key ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments Formatting options Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Cell comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Reference tabs Position tabs Location tabs Sheet tabs Reference tabs Position tabs Location tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS