MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data, Table Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? A1 $A$1 !A!1 #a#1 A1 $A$1 !A!1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The first cell in EXCEL worksheet is labeled as A0 Aa AA A1 A0 Aa AA A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Shows the location of the previously active cell Appears below the status bar Appears to the left of the formula bar Appears below the menu bar Shows the location of the previously active cell Appears below the status bar Appears to the left of the formula bar Appears below the menu bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS