MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F8 F10 F9 F11 F8 F10 F9 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 None of the listed here Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many characters can be typed in a single cell in Excel? 65535 256 1024 32767 65535 256 1024 32767 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can apply Font, border and pattern formats that meets the specified conditions You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? % $ * & % $ * & ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS