Knowledge Base Exercise

Apple:

What ipod games are authored by Apple?

  • Vortex
    • Texas Hold'em
    • iQuiz (iQuiz is also known as iPod Quiz in some countries)
    • Kaplan SAT Prep 2008 (SAT Prep Math 2008, SAT Prep Reading 2008, SAT Prep Writing 2008)

http://docs.info.apple.com/article.html?artnum=304281#faq1

Microsoft:

How do you create a table of contents?

The easiest way to create a table of contents is to use the built-in outline-level (outline level: Paragraph formatting you can use to assign a hierarchical level (Level 1 through Level 9) to paragraphs in your document. For example, after you assign outline levels, you can work with the document in outline view or in the Document Map.) formats or heading styles (heading style: Formatting applied to a heading. Microsoft Word has nine different built-in styles: Heading 1 through Heading 9.). If you are already using outline-level formats or built-in heading styles, follow these steps:

1. Click where you want to insert the table of contents.
2. On the Insert menu, point to Reference, and click Index and Tables.
3. Click the Table of Contents tab.
4. To use one of the available designs, click a design in the Formats box.
5. Select any other table of contents options you want.

If you aren't currently using outline levels or built-in styles, do one of the following:

Create a table of contents from outline levels

1. On the View menu, point to Toolbars, and click Outlining.
2. Select the first heading that you want to appear in the table of contents.
3. On the Outlining toolbar, select the outline level that you want to associate with the selected paragraph.
4. Repeat steps 2 and 3 for each heading that you want to include in the table of contents.
5. Click where you want to insert the table of contents.
6. On the Insert menu, point to Reference, and click Index and Tables.
7. Click the Table of Contents tab.
8. To use one of the available designs, click a design in the Formats box.
9. Select any other table of contents options you want.

Create a table of contents from custom styles

If you've already applied custom styles to your headings, you can specify the style settings you want Microsoft Word to use when it builds the table of contents.

1. Click where you want to insert the table of contents.
2. On the Insert menu, point to References, and click Index and Tables.
3. Click the Table of Contents tab.
4. Click Options.
5. Under Available styles, find a style you've applied to headings in your document.
6. Under TOC level, to the right of the style name, enter a number from 1 to 9 to indicate the level you want that heading style to represent.

Note If you want to use only custom styles, remove the TOC level numbers for the built-in styles, such as Heading 1.
7. Repeat steps 5 and 6 for each heading style you want to include in the table of contents.
8. Click OK.
9. To use one of the available designs, click a design in the Formats box.
10. Select any other table of contents options you want.

Create a table of contents from entries you mark yourself

Use the Mark Table of Contents box to insert TOC fields (field: A set of codes that instructs Microsoft Word to insert text, graphics, page numbers, and other material into a document automatically. For example, the DATE field inserts the current date.) into your document.

1. Select the first portion of text that you want to include in your table of contents.
2. Press ALT+SHIFT+O.
3. In the Level box, select the level and click Mark.
4. To mark additional entries, select the text, click in the Entry box, and click Mark. When you have finished adding entries, click Close.
5. Click where you want to insert the table of contents.
6. On the Insert menu, point to Reference, and click Index and Tables.
7. Click the Table of Contents tab.
8. Click the Options button.
9. In the Table of Contents Options box, select the Table entry fields check box.
10. Clear the Styles and Outline levels check boxes.

Notes

* To create a table of contents for a Web frame (frames: The named subwindow of a frames page. The frame appears in a Web browser as one of a number of window regions in which pages can be displayed. The frame can be scrollable and resizable, and it can have a border.), point to Frames on the Format menu, and click Table of Contents in Frame. A table of contents in a Web frame can only be created from built-in heading styles.
* If you're working with a master document, click Expand Subdocuments Button image on the Outlining toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) before you build or update the table of contents.

http://office.microsoft.com/en-us/word/HP051892931033.aspx

How to link data between Excel and other programs?

OLE (Object Linking and Embedding) is supported by many different programs, and is used to make content created in one program available in another. For example, you can insert a Microsoft Word document into Microsoft Excel. To see what types of content you can insert, click Object on the Insert menu. Only programs that are installed on your computer and that support OLE (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) objects appear in the Object type box.

The main differences between linked objects and embedded objects are where the data is stored and how the object is updated after you place it in the destination file (destination file: The file that a linked or embedded object is inserted into. The source file contains the information that is used to create the object. When you change information in a destination file, the information is not updated in the source file.).

Embedded objects are stored in the workbook they are inserted in, and are not updated. Linked objects remain as separate files, and need to be updated.

Linked and embedded objects in a document

Create a link to an existing document

1. Click in the worksheet where you want to place the linked object (linked object: An object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.).
2. On the Insert menu, click Object.
3. Click the Create from File tab.
4. In the File name box, type the name of the file, or click Browse to select from a list.
5. Select the Link to file check box.
6. To display the content, clear the Display as icon check box.
If you want to display as an icon, select the Display as icon check box.

Note You cannot use the Object command on the Insert menu to insert graphics and certain types of files. To insert a graphic, point to Picture on the Insert menu, and then click From File.

Embed a document

1. Click in the worksheet where you want to place the embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.).
2. On the Insert menu, click Object.
3. If the document does not already exist, click the Create New tab. In the Object type box, click the type of object you want to create.
If the document already exists, click the Create from File tab. In the File name box, type the name of the file, or click Browse to select from a list.
4. Clear the Link to file check box.
5. To display the content, clear the Display as icon check box.
To display as an icon, select the Display as icon check box.

Insert part of an existing document as a linked or embedded object

1. From a program other than Microsoft Excel, select the information you want to copy as a linked (linked object: An object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.) or embedded object (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.).
2. Click Copy Button image.
3. Switch to the worksheet you want to place the information in, and then click where you want the information to appear.
4. On the Edit menu, click Paste Special.
5. To paste the information as a linked object, click Paste link.

To paste the information as an embedded object, click Paste. In the As box, click the entry with the word "object" in its name. For example, if you copied the information from a Microsoft Word document, click Microsoft Word Document Object.

Note You can't paste worksheet cells or a chart as a linked or embedded object in a Microsoft Excel workbook. However, you can use the Copy Picture command (hold down SHIFT and click the Edit menu) to create a link to cells on this or another sheet

http://office.microsoft.com/en-us/excel/HP051995141033.aspx?pid=CH010004921033

What is the difference between linking and embedding?

Linking

The official name for linking is insert a linked object. When you link a file to a presentation, document, or publication, file is inserted and a relationship is created between the file and the destination file. Each time you open the destination file, it checks on the status of the drawing and asks you if you want to display the most current version.

Advantages

* You don't have to remember to update the destination file whenever the original file is updated. This is useful when you've added a file that's updated a lot.

Disadvantages

* If you move the presentation, document, or publication to another computer, you have to remember to move the linked file as well or you won't be able to revise the file.

Note:vInserting a file as a linked object is not the same thing as creating a hyperlink to a drawing. When you link to a file, the file itself appears in your presentation, document, or publication. When you create a hyperlink, only link text appears that you can click to open the drawing.

http://office.microsoft.com/training/training.aspx?AssetID=RP010943071033&CTT=6&Origin=RP010943061033

Embedding:

The official name for embedding is insert an embedded object. When you embed a drawing in a destination file, a copy of the drawing actually becomes part of—is embedded in—that file.

Advantages

* Embedding a drawing is the easiest method to use since it's the one you're used to. If you just copy the drawing in Visio and paste it into the destination file, you've embedded the drawing.
* Because embedding means that a copy of the drawing becomes part of the destination file, you don't have to bring the drawing file along if you move your presentation, document, or publication to another computer.
* Thanks to a technology called OLE (Object Linking and Embedding), you can edit the drawing copy using Visio tools and functionality, without actually leaving the destination file.

As good as embedding a drawing sounds, there are times when it's not the best method to use.

Disadvantages

* When you embed a drawing in a file, you increase the size of the file substantially.
* If you revise the original drawing, you'll have to embed a new copy.
* People who don't have Visio won't be able to revise the drawing in the destination file.

http://office.microsoft.com/training/training.aspx?AssetID=RP010943061033&CTT=6&Origin=RP010943051033

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License