MS Excel You can use the formula palette to Create and edit formula containing functions Enter assumptions data Format cells containing numbers Copy a range of cells Create and edit formula containing functions Enter assumptions data Format cells containing numbers Copy a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can activate a cell by Pressing an arrow key Clicking the cell All of these Pressing the Tab key Pressing an arrow key Clicking the cell All of these Pressing the Tab key ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Hash (#) Tilde (~) Exclamation (!) Apostrophe (') Hash (#) Tilde (~) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP