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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Sort Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals Data, Form Data, Table ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Headers and Footers Page Orientation Margins Page Break Preview Headers and Footers Page Orientation Margins Page Break Preview ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of worksheets A command used for data modeling A range of values such as from 23 to 234 A group of cells A group of worksheets A command used for data modeling A range of values such as from 23 to 234 A group of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Files created with Lotus 1-2-3 have an extension Doc WK1 XLS 123 Doc WK1 XLS 123 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Max Sum Pmt Average Max Sum Pmt ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS