MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 Sheet3.A10 Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 Sheet3!A10 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 The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? All of above Formulas Validation Formats All of above Formulas Validation Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 65535 32767 256 1024 65535 32767 256 1024 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Objects Scenarios Contents All of the listed here Objects Scenarios Contents All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ * % & $ * % & ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS