Question 1. | Question : | (TCO 8) To import a text file into Excel, click ________ on the File tab. |
| | Student Answer: | | Open | | | | New | | | | Info | | | | Options | | | |
| |
Question 2. | Question : | (TCO 8) To create a connection between the original data source and the imported data in Excel, use the ________ on the Data tab. |
| | Student Answer: | | Data Validation command | | | | Connection command | | | | Edit Links command | | | | Commands in the Get External Data group | | | |
| |
Question 3. | Question : | (TCO 8) The ________ group on the Data tab contains tools to help you manage your external data connections. |
| | Student Answer: | | Get External Data | | | | Data Tools | | | | Analysis | | | | Connections | | | |
| |
Question 4. | Question : | (TCO 8) Text to Columns command splits text in one column into separate ________. |
| | Student Answer: | | columns | | | | rows | | | | worksheets | | | | workbooks | | | |
| |
Question 5. | Question : | (TCO 8) Which of the following is an example of a text string? |
| | Student Answer: | | =B5*B7 | | | | =SUM(A5:A10) | | | | =IF(B3>B4, B3) | | | | John Doe | | | |
| |
Question 6. | Question : | (TCO 8) To change the text string Jack Doe to JACK DOE, use the ________ function. |
| | Student Answer: | | UPPER | | | | LOWER | | | | PROPER | | | | CONCATENATE | | | |
| |
Question 7. | Question : | (TCO 8) Which of the following functions does not change the case or capitalization of text? |
| | Student Answer: | | PROPER | | | | CAPS | | | | UPPER | | | | LOWER | | | |
| |
Question 8. | Question : | (TCO 8) If you want to send a letter to all your customers using Mail Merge, and you already have the customers’ names and addresses stored in an Excel file, you should choose _________ from the Select Recipients menu while performing the merge. |
| | Student Answer: | | Type New List | | | | Use Existing List | | | | Import from Excel | | | | Select from Outlook Contacts | | | |
| |
Question 9. | Question : | (TCO 8) The New Comment command is located on the ________ tab. |
| | Student Answer: | | View | | | | Review | | | | Data | | | | File | | | |
|
Question 10. | Question : | (TCO 8) If first and last names are combined in a single column, you can split them into two separate columns using the ________. |
| | Student Answer: | | Split Names Wizard | | | | PivotTable feature | | | | CONCATENATE function | | | | Convert Text to Columns Wizard | | | |
| |
Question 11. | Question : | (TCO 8) The ________ tab on the Page Setup dialog box provides options for printing comments. |
| | Student Answer: | | Page | | | | Margins | | | | Header/Footer | | | | Sheet | | | |
| |
Question 12. | Question : | (TCO 8) The command to send an Excel workbook by e-mail is located on the ________ tab. |
| | Student Answer: | | File | | | | Home | | | | Insert | | | | View | | | |
| |
Question 13. | Question : | (TCO 8) To display the Properties dialog box, click ________ in the Info section of the Backstage view and select Advanced Properties. |
| | Student Answer: | | Properties | | | | Show All Properties | | | | Permissions | | | | Versions | | | |
| |
Question 14. | Question : | (TCO 8) Which function is similar to the Find and Replace feature? |
| | Student Answer: | | CONCATENATE | | | | SUBSTITUTE | | | | UPPER | | | | PROPER | | | |
| |
Question 15. | Question : | (TCO 8) You can automate the deleting of duplicate rows from your spreadsheet by using the _________ on the Data tab of the Ribbon. |
| | Student Answer: | | Text to Columns command | | | | Remove Duplicates command | | | | Consolidate command | | | | Group command | | | |
| |
|