电脑软件应用(国外英语资料).docVIP

电脑软件应用(国外英语资料) Excel.excel2003 electronic form (1) 2 hours To teach The eye of Learn the main features of Excel2003 spreadsheets Work table, row, column, cell operation, data editing To teach The basic operations of reordering worksheets, rows, columns, cells, and workbooks To teach The difficult cell area is programmed to write the date On November 8, 11 years Teaching content and teaching process tips and supplements One, Excel 2003 main function Table making functions Graphics and graphics Data processing and data analysis List features: Excel2003 adds functionality, similar to the filtering feature, which users can use to sort, filter, aggregate, average, and so on Second, start and exit Exit: the right side of the title bar and the idle button, the button icon double-click, the control menu is idled, the file menu exit The composition of Excel 2003 window Title bar, menu bar, toolbar, status bar Open menu items (mouse, keyboard operation) Edit menu, insert menu, format menu, data menu Work table editing area: 1) edit column: name box, tool button, edit area The name of the cell, the representation of the cell area, and the selection of the cell region 2) the working table editor area 256 rows 65536 columns 3) worksheet labels Rename, insert, delete, copy and move the worksheet, and set the color of the worksheet label 4) task pane Perhaps the view menu opens, displaying the items in hyperlinks The concepts of work books, worksheets, cells, and cell areas A workbook (book) : an excel file is a file that stores data, data algorithms, and data formatting. (file extension:.doc), workbooks consist of worksheets, and a workbook can contain multiple worksheets. Worksheet (sheet) : two dimensional tables, arranged by rows and columns, used for organizing and analyzing data. The worksheet cannot be stored separately. The worksheet can consist of 256 columns and 65536 rows. 3. The system default open new worksheet in the workbook is number three, can change the number: t