JustAnswer



Lesson 5Integrating Word, Access, And Excel1. Instead of typing an individual name into a letter that you plan to reuse with multiple people, you should use a _____ to automate the process.A. form letterB. mail mergeC. mailing listD. data source2. Once you’ve connected to a data source, which button would you select to add a first name to your form letter?A. Highlight Merge fields B. Address BlockC. Greeting LineD. Insert Merge Field3. Assume you had a .csv file with data already populated that you wanted to use for a mail merge. Which button would you press to import the text?A. From TextB. From AccessC. From FileD. From Other Sources4. Which of the following statements accurately describes linked data?A. Data can’t be linked between two programs.B. It’s updated if there are changes to the source file.C. It remains static even if the source file changes.D. It’s the area where copied data is stored until it’s pasted.5. A chart object has all the features of ______ when activated.A. an Excel chartB. an Excel worksheetC. AccessD. Word6. When working in an OLE Excel spreadsheet, how do you return to Word?A. Press the ESC keyB. Click anywhereC. Click the Home tab on the Excel ribbonD. Click the Insert tab on the Excel ribbon7. When entering new data into your table, which key should you press to move from one field or cell to the next?A. TabB. BackspaceC. Home D. Insert8. Which button allows you to choose whether to use the destination formats or keep source formats?A. The ClipboardB. EmbedC. Paste OptionsD. Copy9. What does adding a greeting line allow you to add to a letter?A. An addressB. The dateC. An invoice numberD. A recipient’s name10. A data source containsA. numerical characters onlyB. text-based characters onlyC. random data that will then be organizedD. a collection of organized data11. A ______ document is the file containing information to be copied.A. linkedB. embeddedC. destinationD. source12. If you change a column header in your data source, what would you press to ensure that the data is synced as expected?A. Match FieldsB. RulesC. Address BlockD. Update Labels13. Selecting Worksheet Object > Open allows you toA. edit in the spreadsheet windowB. open a new fileC. edit in the Word documentD. change the size of the object14. Which button would you use to quickly add addresses to a mail merge envelope?A. Update LabelsB. Address BlockC. Insert Merged FieldsD. Greeting Line15. What would you select to connect with the Access database as the data source?A. Select Recipients > Using an Existing ListB. Select Recipients > Choose from Outlook ContactsC. Start Mail MergeD. Select Recipients > Type a New List16. If you want to limit the recipients for a mail merge, you shouldA. use the Edit Recipient List button to select the recipients to includeB. complete the mail merge and delete the recipients you want to excludeC. open the data source and delete the recipients you want to excludeD. create a new data source from scratch17. In what format would an Access database object be opened in Word?A. Access fileB. Rich text fileC. Document fileD. Excel file18. A compound document hasA. only one application interfaceB. more than one application interfaceC. a spreadsheet embeddedD. the computing power of a spreadsheet19. How do you change the number of rows and columns displayed by an Excel object?A. Insert a row into Excel and it will automatically enlargeB. Insert a column into Excel and it will automatically enlargeC. Drag a size handle on the active objectD. Click outside the Excel object and drag a size handle20. Assume you’re copying a formula from Excel. When you paste it in Word, you want only the final displayed number. Which paste option should you choose?A. Paste as text onlyB. Use the destination themeC. Paste as pictureD. Keep the source formatting ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download