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 Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction ANSWER DOWNLOAD EXAMIANS APP
MS Excel To center worksheet titles across a range of cells, you must Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered Format the cells with the comma style Widen the columns Select the cells containing the title text plus the range over which the title text is to be enfettered Select the cells containing the title text plus the range over which the title text is to be centered Format the cells with the comma style ANSWER DOWNLOAD EXAMIANS APP
MS Excel An excel workbook is a collection of Worksheets Worksheets and charts Workbooks Charts Worksheets Worksheets and charts Workbooks Charts ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Max Average Pmt Sum Max Average Pmt Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS