MS Excel Which of the following option is not available in paste Special dialog box ? Subtract Add Divide SQRT Subtract Add Divide SQRT ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you want to insert a blank embedded excel object in a word document you can Click the import excel command on the file menu Click the create worksheet button on the formatting toolbar Click the object command on the insert menu Click the office links button on the standard toolbar Click the import excel command on the file menu Click the create worksheet button on the formatting toolbar Click the object command on the insert menu Click the office links button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address 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
MS Excel A numeric value can be treated as label value if ___ precedes it. Exclamation (!) Apostrophe (') Hash (#) Tilde (~) Exclamation (!) Apostrophe (') Hash (#) Tilde (~) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Referencing Updating Functioning Accessing Referencing Updating Functioning Accessing ANSWER DOWNLOAD EXAMIANS APP