MS Excel How do you rearrange the data in ascending or descending order? Data, Sort Data, Form Data, Table Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Both of above Cut and Paste None of above Paste Special > Transpose Both of above Cut and Paste None of above Paste Special > Transpose ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes the content of a cell Deletes the comment of cell Deletes Formats of cell Deletes selected cells Deletes the content of a cell Deletes the comment of cell Deletes Formats of cell Deletes selected cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Date/Time Label Character Number Date/Time Label Character Number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing spacebar Pressing enter Pressing any arrow key on the keyboard Clicking the Enter button on the Formula bar Pressing spacebar Pressing enter ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS