MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 Sheet1!A10 Sheet3.A10 Sheet3!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
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 An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Use the word menu bar and toolbars Linked Hyperlinked placed in a word table Embedded Use the word menu bar and toolbars Linked Hyperlinked placed in a word table Embedded ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Exclamation (!) Apostrophe (') Hash (#) Tilde (~) Exclamation (!) Apostrophe (') Hash (#) Tilde (~) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Select the column heading you want to delete and select the Delete Row button on the standard toolbar Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the 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 Right click the column heading you want to delete and select delete from the shortcut menu Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Insert > Find from the menu Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Insert > Find from the menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS