MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the 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 Freeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Linked Hyperlinked placed in a word table Embedded Use the word menu bar and toolbars Linked Hyperlinked placed in a word table Embedded Use the word menu bar and toolbars ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following series type is not valid for Fill Series dialog box ? Linear Time Autofill Growth Linear Time Autofill Growth ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP