MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can add more than one condition to check ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 #a#1 A1 $A$1 !A!1 #a#1 A1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The Formula button The autosum button The quicktotal button The total button The Formula button The autosum button The quicktotal button The total button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key Pressing the Tab key Clicking on the formula bar Pressing the Esc key Pressing an arrow key ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following is a correct order of precedence in formula calculation? Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here ANSWER DOWNLOAD EXAMIANS APP