MS Excel Concatenation of text can be done using Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) Hash (#) Ampersand (&) Apostrophe (') Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur 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 When you use addition and subtraction 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 multiplication, division, or exponentiation in a formula When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel While Finding and Replacing some data in Excel, which of the following statement is valid? Both None of the listed here You can Find and Replace within the sheet or workbook Excel does not have option to match case for find Both None of the listed here You can Find and Replace within the sheet or workbook Excel does not have option to match case for find ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press the Enter button Press the Erase key Press the Edit Formula button Press Esc Press the Enter button Press the Erase key Press the Edit Formula button Press Esc ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS