Excel英文版.docVIP

PAGE 3 Excel 2002 Definition Excel is a Microsoft Office suite is an important component, it can be a variety of data processing, statistical analysis and decision support operations, is widely used in management, statistics financial, monetary and many other fields. A large number of formulas can be applied to select the function can be achieved in many convenient features to the user convenience. Overview MICR0S0FT EXCEL once came, it was recognized as the worlds most powerful, most technologically advanced and easiest to use spreadsheet software. At present all of foreign teaching, research and design departments in the use of this system in routine data processing, drawing the chart work; also have applications in many sectors of the system on specific issues involved in the study as long as there is a clear mathematical expression, can using the system to achieve all of the calculations. Topics 1. System Introduction EXCEL size of the screen there are two windows, in which the window is MICR0S0FT EXCEL application window, including the file (F), editor (E), Windows (V), insertion (I), format (O), tools (T), Data (D), window (W), help (H) and other times a window; but also includes general toolbar, such as document management, printing and preview, cut and copy, the function guides, charts, guides, graphics and text , operation guides. A small window called the workbook window title BOOK (file name). The so-called workbook refers to EXCEL for the preservation and processing of data files. A workbook with 16 worksheets. Each worksheet includes 16384 * 256 cells. In other words, a file can store 67,108,864 items of data, or formula, characters, and even graphics, sound, etc.. Each cell has a fixed address, for example, B5 in SHEET1 said first sheet first column 5th row B cells that can be invoked in any cell of the cell content (such as data, formulas, etc. ); Each cell can accept up to 255 characters, due to width restrictions, the general use of overflow and