MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) 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 None of the listed here Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation None of the listed here Multiplication and division, positive and negative values, addition and subtraction ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following you can paste selectively using Paste Special command? Formats Formulas All of above Validation Formats Formulas All of above Validation ANSWER DOWNLOAD EXAMIANS APP
MS Excel When the formula bar is active, you can see The edit formula button All of these The enter button The cancel button The edit formula button All of these The enter button The cancel button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Macro sheet Data sheet Chart sheet Work sheet Macro sheet Data sheet Chart sheet Work sheet ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS