MS Excel When a row of data is to be converted into columns 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 Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Data can be arranged in a worksheet in a easy to understand manner using Auto formatting Changing fonts Applying styles All of the listed here Auto formatting Changing fonts Applying styles All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The edit formula button All of these The cancel button The enter button The edit formula button All of these The cancel button The enter button ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Increase the column width Shorten the label Adjust the row height Decrease the column width Increase the column width Shorten the label Adjust the row height Decrease the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Date/Time Character Label Number Date/Time Character Label Number ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 3 none of above 255 8 3 none of above 255 8 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS