MS Excel The active cell: Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters Is defined by a bold border around the cell It is the formula bar Only A and B Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Divide Percentage Square Goal seek Divide Percentage Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which is used to perform what if analysis? Scenario Manager Goal seek All of above Solver Scenario Manager Goal seek All of above Solver ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not an example of a value ? 350 Serial Number 50771 May 10, 2001 0.57 350 Serial Number 50771 May 10, 2001 0.57 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? 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 set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions 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 set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions ANSWER DOWNLOAD EXAMIANS APP