MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 6.8 5436.8 5436.80 5430 6.8 5436.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Pie Area Line All of the listed here Pie Area Line All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Border Copy handle Fill handle Insert handle Border Copy handle Fill handle Insert handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS