This is for Jackline86

Student ID: 22357317

Exam: 038236RR - Integrating Word with Access and Excel

When you have completed your exam and reviewed your answers, click Submit Exam. Answers will not be recorded until you hit Submit Exam. If you need to exit before completing the exam, click Cancel Exam.

Questions 1 to 20: Select the best answer to each question. Note that a question and its answers may be split across a page break, so be sure that you have seen the entire question and all the answers before choosing an answer.

1. What Microsoft Office applications can you use to create a database mail merge? A. Access

B. Excel, Word, and Access

C. Word and Excel

D. PowerPoint, Publisher, Excel, and Word

2. Computer user A wants the Excel worksheet in a Word document to automatically update when she makes changes to the Excel worksheet so she’ll embed the worksheet into the Word document. Computer user B says to link the worksheet to the Word document. Which computer user is using the correct process? A. Neither is correct.

B. Computer user A is correct.

C. Computer user B is correct.

D. Both are correct.

3. What feature or attribute will be applied if you select some text and click on the button shown above? A. Boldface

B. Italic

C. Underscore

D. Center

4. How should you save the edited Excel worksheet that has been embedded in a Word document? A. Click on Start, select Programs, and click the icon for the Excel program.

B. Click the Home tab, click on Select All, and press Alt + Shift + S.

C. Click the Save button in the upper-left corner of Word.

D. Press Alt and S at the same time.

5. What tells a database where to insert information in the main document? A. Field

B. Placeholder

C. Object

D. Handle

6. All of the following operations will move you from cell A1 to cell B1 of an embedded worksheet except A. clicking on cell B1.

B. pressing the Tab key.

C. pressing the Enter key.

D. pressing the Right Arrow key.

7. Robert just finished his Word document with an embedded spreadsheet. What is the easiest way to check the overall layout? A. Use the Print Review

B. Zoom up to 100%

C. Under the View tab, switch to Normal View

D. Under the View tab, switch to Form View

8. The Mail Merge wizard is located in A. Excel.

B. Word.

C. PowerPoint.

D. Access.

9. Lucy needs to insert a certain date format into her Word document. How do you insert an Automatic Date into a Word document with a certain date format? A. Right-click on the Word document and select embed Excel worksheet.

B. Start typing the date, and Word automatically shows tooltip of full date.

C. Click Insert tab, click on Date & Time, choose a date format, and click OK.

D. Write a macro to your specifications for the Date & Time method.

10. Hank is working on his embedded Excel spreadsheet in a Word document. Before he can edit the worksheet that’s embedded in his Word document, he must A. recalculate the Excel spreadsheet.

B. save the Word document.

C. copy the Excel spreadsheet into Excel.

D. double-click on the embedded worksheet to activate Excel.

11. Robin has populated a database table in Access with customer names, addresses and phone numbers. She now needs to create a form to display the customer information. How does Robin create a Database Form in Microsoft Access? A. Open Access and select the New icon.

B. Select the Form button, and click Create.

C. Select the Create tab in the Ribbon and then click the Form button.

D. Right-click the open Access database and select Form.

12. Brian has a list of customers that needs to be entered into a new database. Before Brian can begin entering records into a database, he must first A. enter information into an Excel spreadsheet.

B. create a table.

C. create a form to display the customer’s information.

D. create objects for the database.

13. Bobby just inputted annual costs for January (A1) thru December (L1) in his embedded Excel spreadsheet that’s integrated into a Word document. Now he must make sure the inputted costs have the dollar symbol and have two decimals after each projected month. How can Bobby add the dollar symbol multiple times for January (A1) thru December’s (L1) annual costs? A. Select the Formula tab and click on the Accounting Number Format button.

B. Go to each cell A1 through L1 and click on the Accounting Number Format button.

C. Highlight A1 through L1, right-click, and select Dollar sign.

D. Select cells A1 through L1, click on cell A1, hold the Shift key down and drag to L1, and click on Accounting Number Format button.

14. What does the first field or column in an Access form or table do? A. It identifies integrated files.

B. It updates changes in linked objects.

C. It assigns a number to each record in a database.

D. It sorts database records by selected fields.

15. When you’re in the Mail Merge option dialog box, you have the ability to A. create a list of addresses.

B. create a form.

C. rename the Word document.

D. create e-mails.

16. What are the steps to embed an Excel worksheet into a Word document? A. Select the Insert tab, click Table, and select Excel Spreadsheet.

B. Right-click on the Word document and select embed Excel worksheet.

C. Select the Embed tab, and click on the Excel worksheet option.

D. Go into Excel Spread, create table, copy, and then paste into Word document.

17. What button in the Excel toolbar gives you the automatic sum of certain highlighted columns? A. Select Formulas tab, and click on the Financial option menu.

B. On the main home menu, select the Greek symbol used for AutoSum.

C. Select Formulas tab, click on Math & Trig option, and select Sum.

D. Click on Show Formulas, under the Formulas tab.

18. To select the range of cells A2:D12, first click on cell A2. Then click on D12 while you hold the _______ key.

End of exam

A. Shift

B. Ctrl

C. Tab

D. Alt

19. If you wish to display your database file one record at a time, you should create a A. datasheet.

B. form.

C. table.

D. frame.

20. Charles and Ann want to preview their letters merged with their mailing list. Charles will click Next: Preview Your Letters. Ann will click Next: Preview Your Letters and then click the double arrow in the Mail Merge pane. Who is correct? A. Only Ann is correct.

B. Only Charles is correct.

C. Both are correct.

D. Neither is correct.