Charts in MS Excel

Formulas in MS Excel.

Cells addressing in MS Excel.

Programs for tables processing.

Macros in MS Word

Creating a table of contents in MS Word

To create a table of contents that’s easy to keep up-to-date, first apply heading styles – Heading 1 and Heading 2, for example – to the text that you want to include in the table of contents. For information on heading styles, see Add a heading.

Word finds those headings and uses them to build the table of contents and can update the table of contents anytime you change the heading text, sequence, or level.

1.Click where you want to insert the table of contents – usually near the beginning of a document.

2.Click References > Table of Contents and then choose an Automatic Table from the gallery of styles.

If you choose Manual Table, Word will insert placeholder text that creates the look of a table of contents. A Manual Table does not update automatically.

You can customize the way a table of contents appears. For example, you can change the font, how many heading levels to show, and whether to show dotted lines between the entries and the page numbers. To learn how, see Format a table of contents.

A macro is a series of commands and instructions that you group together as a single command to accomplish a task automatically. In Microsoft Office Word 2007, you can automate frequently used tasks by creating and running macros.

To speed up routine editing and formatting.

To combine multiple commands — for example, to insert a table with a specific size and borders, and with a specific number of rows and columns.

To make an option in a dialog box more accessible. To automate a complex series of tasks.

• SuperCalc

•QuattroPro

•Lotus 1-2-3

•Excel

Each cell in the table has its own unique address, which will be used in formulas. The figures show the number of the row and column number of letters.

Formulas in spreadsheet programs such as Excel are used to perform calculations.

Formulas can range from basic mathematical operations - such as addition and subtraction - to complex engineering and statistical calculations.

Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data. To create a chart in Excel, you start by entering the numeric data for the chart on a worksheet. Then you can plot that data into a chart by selecting the chart type that you want to use on the Insert tab, in the Charts group.

35. Programs for creating presentation.

Дата добавления: 2014-12-16