MS Excel What does COUNTA () function do? Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a worksheet design criterion? Efficiency Aditibility Description Clarity Efficiency Aditibility Description Clarity ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following Excel screen components can NOT be turned on or off ? Status Bar None Formula Bar Tool Bar Status Bar None Formula Bar Tool Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? 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 Multiplication and division exponentiation positive and negative values ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS