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 Copy the cells then go to Cells then on Alignment tab click Transpose check box and click 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 in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + C Ctrl + Space Bar Ctrl + Page Up Ctrl + Enter Ctrl + C Ctrl + Space Bar Ctrl + Page Up ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a term of MS-Excel? Rows Document Cells Columns Rows Document Cells Columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Worksheets Group of Workbooks Group of Rows Group of Columns Group of Worksheets Group of Workbooks Group of Rows Group of Columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel Documentation should include Source of input data Information on the purpose of the workbook Destination and users of the output data All of these Source of input data Information on the purpose of the workbook Destination and users of the output data All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Scenario Manager Solver All of above Goal seek Scenario Manager Solver All of above Goal seek ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS