Exam 3: Integrating Word and Excel

Be sure to click the Excel button in the Export & Link group when transferring data from Excel into Access.

You can ____ an entire file that you create in one Office program in a document created in another Office program.

PowerPoint imports all text formatted with the Heading 1 style as a(n) ____.

You use a(n) embed option from the Paste Special dialog box to create a link between selected data in two files.

Explain how to link an Access table to Excel and Word.

Microsoft Internet Explorer 8 and FireFox are two examples of home pages.

When you add data from one table to an existing table, you need to make sure that the number of records is the same in both tables.

Internet Explorer's Help system lets you search for a specific word or phrase, or enter a keyword, then request a list of topics containing that keyword.

A block of text that is formatted with a heading style in Word is not included when it is imported into a PowerPoint presentation.

The Menu bar displays information about your connection process, notifies you when you connect to another Web site, and identifies the percentage of information transferred from the Web server to your browser.

The ____________________ bar displays information about your connection progress whenever you open a new Web page.

If you need to create sales charts, order new products, complete purchase orders, and produce proposals to obtain new contracts, you can use ____ techniques in the Office suite to accomplish your tasks.

You can edit a(n) embedded file by double-clicking it in the destination program to open the source program.

After importing Excel data into Access without links, any changes you make to the Excel source data will be reflected in the Access table.

You cannot move or resize an object that has been copied from Excel and pasted into PowerPoint as a link.

If you want to review a Web page before printing it, such as the number of copies to print, you should click the Print frames option on the Web page.

You link an object to a PowerPoint slide when you always want your object to include the latest information.

A workbook that you plan to export from Excel into Access should only contain the ____ that you want to appear in the Access table.

To embed an object in a PowerPoint presentation, you use the ____ command in the Text group on the Insert tab.

What is the difference between linking and embedding an object?