MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data, Sort Data Subtotals Data, Table Data, Form Data, Sort Data Subtotals Data, Table ANSWER DOWNLOAD EXAMIANS APP
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 You can copy data or formulas With the copy, paste and cut commands on the edit menu With commands on the shortcut menu All of these With buttons on the standard toolbars With the copy, paste and cut commands on the edit menu With commands on the shortcut menu All of these With buttons on the standard toolbars ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a 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 Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Delete key of keyboard is assigned to which command in Excel ? Edit > Clear >All Edit > Clear > Contents Edit > Delete All of the listed here Edit > Clear >All Edit > Clear > Contents Edit > Delete All of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5436.8 6.8 5430 5436.80 5436.8 6.8 5430 ANSWER DOWNLOAD EXAMIANS APP