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 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Reference tabs Position tabs Sheet tabs Location tabs Reference tabs Position tabs Sheet tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B It is the formula bar Is defined by a bold border around the cell Receives the data the user enters Only A and B It is the formula bar Is defined by a bold border around the cell Receives the data the user enters 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 To center worksheet titles across a range of cells, you must Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered Widen the columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Return ASCII values of characters Concatenate and manipulate text Replace cell references Show formula error value Return ASCII values of characters Concatenate and manipulate text Replace cell references Show formula error value ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS