MS Excel Rounding errors can occur Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 5436.8 6.8 5436.80 5430 5436.8 6.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel All worksheet formula Manipulate values Return a formula result Manipulate labels Use the addition operator Manipulate values Return a formula result Manipulate labels Use the addition operator ANSWER DOWNLOAD EXAMIANS APP
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 set condition to look for Bold and apply Italics on them You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried 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 add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes the content of a cell Deletes Formats of cell Deletes selected cells Deletes the comment of cell Deletes the content of a cell Deletes Formats of cell Deletes selected cells Deletes the comment of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Multiple calculations can be made in a single formula using ___ Array formula Smart Formula Standard Formulas Complex Formulas Array formula Smart Formula Standard Formulas Complex Formulas ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS