MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address The sheet tab is changed An absolute cell address is created Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select Insert Delete from the menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel In help menu of Excel, which of the following tabs are found? All of these Contents tab Index tab Answer Wizard tab All of these Contents tab Index tab Answer Wizard tab ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? $A$1 #a#1 !A!1 A1 $A$1 #a#1 !A!1 A1 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS