MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data Subtotals Data, Sort Data, Table Data, Form Data Subtotals Data, Sort Data, Table ANSWER DOWNLOAD EXAMIANS APP
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 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 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 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 in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain text and data It can contain many sheets including worksheets and chart sheets You have to work hard to create it It can be modified It can contain text and data It can contain many sheets including worksheets and chart sheets You have to work hard to create it It can be modified ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two Format > window View > window > split View > split Window > split Format > window View > window > split View > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS