MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel In a worksheet you can select All of these The entire worksheet Columns Rows All of these The entire worksheet Columns Rows 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 Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Unfreeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Divide Square Percentage Goal seek Divide Square Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a term of MS-Excel? Rows Columns Document Cells Rows Columns Document Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because 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 It can contain text and data It can contain many sheets including worksheets and chart sheets ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS