Integrating Word and Excel Test #1

By fault, an Excel spreadsheet that you create in Word is formatted with the

Default theme

A hyperlink is

a text element or graphic that you click to display another place in a file

You can create hyperlinks to

access data from other documents and programs

The Excel spreadsheet object is

an embedded object in the Word file

You use the Links dialog box to

change link sources and then update links

You can change the color assigned to a followed hyperlink by

clicking the Design tab, then clicking the Colors button and clicking Customize Colors

From here, you can change the colors assigned to text in the theme

currently being used in the document

When an object is embedded, you edit it by

double-clicking it and using the source program tools

You can still view different worksheets in your Excel document while

editing it in the Word document

You often create hyperlinks between two files that you plan to send

electronically

You can change the source of any link that you create between two files,

even when the files are created in different source programs

The first step to insert a hyperlink that will connect a word in Word to an Excel document is to

highlight the word that will be the link between the two

But when you click a hyperlink from a source file to a location in a destination file,

the destination file opens

When you create a file in one program and embed it into another program,

the formatting of the original file is retained

When you embed a Word file in an Excel spreadsheet,

the original Word formatting is retained

The Excel ribbon and tabs replace the Word ones; however,

the title bar shows that you are still working in the Word document and using Excel tools only to modify the embedded Excel file

You can include text in a ScreenTip that appears

when users point to the hyperlink

When you copy, paste, and link data between programs,

you actually bring the data into the destination file

Instead of combining all the information into one file in one program,

you can create two documents, such as a letter or other document in word and a spreadsheet showing calculations in Excel, and insert a hyperlink in one document that opens the other document

When you don't need to store spreadsheet data in a separate Excel file,

you can use the table command to create an Excel spreadsheet in Word and then use Excel tools to enter labels and values and make calculation

To modify it,

you double click it and then use Excel tools that become available inside of the Word program window