Office automation

1. Office automation Office automation refers to the varied computer machinery and software used to digitally create, collect, store, manipulate, and relay office information needed for accomplishing basic tasks. Raw data storage, electronic transfer, and the management of electronic business information comprise the basic activities of an office automation system.[1] Office automation helps in optimizing or automating existing office procedures. The backbone of office automation is a LAN, which allows users to transmit data, mail and even voice across the network. All office functions, including dictation, typing, filing, copying, fax, Telex, microfilm and records management, telephone and telephone switchboard operations, fall into this category. Office automation was a popular term in the 1970s and 1980s as the desktop computer exploded onto the scene.[2]

2. Microsoft Word • Microsoft Word is a proprietary word processor designed by Microsoft. It was first released in 1983 under the name Multi-Tool Word for Xenix systems.[1][2][3] Subsequent versions were later written for several other platforms including IBM PCs running DOS (1983), the Apple Macintosh (1984), the AT&T Unix PC (1985), Atari ST (1986), SCO UNIX, OS/2, and Microsoft Windows (1989). It is a component of the Microsoft Office software system; it is also sold as a standalone product and included in Microsoft Works Suite. The current versions are Microsoft Office Word 2010 for Windows and Microsoft Office Word 2011 for Mac.

3. Word Processing • Using a computer to create, edit, and print documents. Of all computer applications, word processing is the most common. To perform word processing, you need a computer, a special program called a word processor, and a printer. A word processor enables you to create a document, store it electronically on a disk, display it on a screen, modify it by entering commands and characters from the keyboard, and print it on a printer.

4. File Management • layout • macros: • spell checker • WYSIWYG(what you see is what you get): • windows

5. FILE MENU • A collection of data or information that has a name, called the filename. Almost all information stored in a computer must be in a file. There are many different types of files: datafiles, text files , program files, directory files, and so on. Different types of files store different types of information. For example, program files store programs, whereas text files store text.

6. EDIT MENU • The Edit menu is a menu found in most computer programs that handle files, text or images. It is often the second menu in the menu bar, next to the file menu. • It most commonly contains commands relating to the handling of information, i.e. cut and paste and selection commands. In addition, it may also be home to the undo and redo commands, especially in word processors. It may also contain commands for locating information, e.g. find commands. In graphics-oriented programs, it often contains commands relating to the manipulation of images, for example the crop command.

7. VIEW MENU • The view menu allows you access to many Paint Shop Pro features that will make your work easier and more efficient. The main features on this menu are View options such as full screen and zoom and alignment assists such as grids and guides. The following graphic illustrates the menu choices. This menu also contains a feature new to Paint Shop Pro 7, Preview in Web Browser

8. Examples • Full Screen Edit • Full Screen Preview • Normal Viewing • Zoom Out/Zoom In • Preview in Web Browser • Rulers • Grid • Change Grid and Guide Properties • View Guides

9. Insert Menu • The Insert menu is Figure 4-11 The Insert menu.The menu choices are grouped into the following groups: 1 Insert into workbook. These menu items alter the cells available in a workbook. Cells... — The Cells... menu item opens a dialog asking the user how the sheet should be altered when new cells are inserted. The dialog lists four choices. The user can choose one of these by clicking the mouse pointer on one of the four dots. Only one choice is possible and the currently selected choice has a black dot in front.

10. The Shift cells right will insert a region of new cells of the size of the current selection. Cells which are on the same row as the selection and within or to the right of the selection will shift over to the right to accommodate the new cells. The Shift cells down choice will also insert a region of new cells the same size as the current selection. With this choice, cells which are in the selection or below the selection will move down to accommodate the new cells. The two other choices will act as if the user had chosen to insert rows or columns. These actions are explained above. Columns — The Columns menu item will insert columns to the left of the current selection. The number of columns inserted will equal the number of columns spanned by the current selection. Rows — The Rows menu item will insert rows above the current selection. The number of rows inserted will be equal to the number of rows

11. spanned by the current selection. Sheet — The Sheet menu item allows the user to insert a worksheet immediately following the current sheet. 2 Insert an object into the worksheet or content into the current cell. The menu items insert sheet objects into the worksheet or insert content into the current cell. Graph... — The Graph... menu item will allow a user to insert a graphic plot of data. This menu item will launch the graph druid. Graphing in Gnumeric is explained in Chapter 10 ― Graphs. Image... — The Image... menu item will allow a user to insert a graphic object containing the image from an external

12. file. The use of images in Gnumeric is explained in Section 9.2 ― Images. Function — This menu item opens a dialog to allow the user to enter a mathematical formula into the cell. The function dialog includes the names and a brief explanation of all the available functions. Function Wrapper — Selecting an item from the submenu shown in Figure 4-12 replaces every rectangular region in the current selection with an array function in which the appropriate function is wrapped around an array version of the current content. This can be used to create a self-sorting data region.

13. Figure 4-12 The Function Wrapper submenu.Name... — The Name... menu item opens a dialog (see Figure 4-13) with a list of all defined names that can be pasted into teh current cell. Section 5.2.4.4 ― Names explains names in greater detail. Figure 4-13 The Insert Name dialog.Comment... — This menu item opens a dialog to allow the user to enter a comment to the currently selected cell. A red triangle will appear in the top right corner of the cell to show that the cell has a comment.

14. Hyperlink... — This menu item opens a dialog to allow the user to enter the location of a link. The cell contents will become the text for the link and clicking on the cell will move the user to the new location. The link can point to another area of the worksheet, to another worksheet, or to any location which can be defined with a Universal Resource Locator (URL). If the URL points to a resource accessible over the Internet, Gnumeric will launch the desktop web browser to open that URL. Special — The Special menu item opens a sub-menu which allows the user to insert predefined content into a cell. The current choices are to insert the current date, time or both.