MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The status bar does not display the cell address An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Worksheets Group of Rows Group of Workbooks Group of Columns Group of Worksheets Group of Rows Group of Workbooks Group of Columns ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Click Save on the Windows Start button Click the save button on the standard toolbar from the menu Select Edit > Save Press Ctrl+ F5 Click Save on the Windows Start button Click the save button on the standard toolbar from the menu Select Edit > Save Press Ctrl+ F5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column numbers and row letters Column letters and row numbers Cell names Cell locator coordinates Column numbers and row letters Column letters and row numbers Cell names Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP