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 Copy the cells in row, select the same number of cells in row and paste 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The spelling dialog box can be involved by choosing spelling from ________ menu. Tools File View Insert Tools File View Insert ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Page Orientation Headers and Footers Margins Page Break Preview Page Orientation Headers and Footers Margins Page Break Preview ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the Ctrl key as you click anywhere in the column Hold down the shift key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Hold down the shift key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Freeze panes command on the window menu Split command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Split command on the window menu Unfreeze panes command on the window menu Hold titles command on the edit menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Contents All of the listed here Objects Scenarios Contents All of the listed here Objects Scenarios ANSWER DOWNLOAD EXAMIANS APP