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 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 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 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 Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel The first cell in EXCEL worksheet is labeled as A1 A0 Aa AA A1 A0 Aa AA ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can move a sheet from one workbook into new book by From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move of Copy then choose (Move to end) and click OK None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing spacebar Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing enter Pressing spacebar Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Line Chart Column Chart XY Chart Pie Chart Line Chart Column Chart XY Chart Pie Chart ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS