MS Excel Which of the following is the oldest spreadsheet package? Lotus 1-2-3 VisiCalc StarCalc Excel Lotus 1-2-3 VisiCalc StarCalc Excel ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values Multiplication and division, positive and negative values, addition and subtraction None of the listed here Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 5430 6.8 5436.80 5436.8 5430 6.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Smart cell Lotus 1-2-3 Word Excel Smart cell Lotus 1-2-3 Word Excel ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS