I. know Excel 2010

1. Introduction to Excel software

1: Microsoft Excel is a spreadsheet software written by Microsoft for Windows and Apple Macintosh operating systems. May 1982. Microsoft withdrew from its first electronic tabulation software, Multiplan, and achieved great success in the CP/M system, but on the MS-DOS system, multiplan was defeated by Lotus 1-2-3 (the workbook software released by Lotus software in 1983, which was widely used by PC users during the DOS period ). This incident prompted the birth of Excel, just as the Excel R & D code Doug klunder: What Lotus 1-2-3 can do, and it can do better. In 1985, the first Excel was born. It was only used for MAC systems. In November 1987, the first Excel for Windows systems was also generated (directly bound to the Windows environment, with the Mac version 2.0 ). Lotus 1-2-3 was delayed and could not be applied to Windows systems. By 1988, Excel sales surpassed Lotus 1-2-3, leading PC software vendors.

Excel supports compatibility with Lotus 1-2-3 (Excel options -- Advanced -- Lotus 1-2-3 compatibility settings)

After selecting the Lotus 1-2-3 formula, you do not need to add =

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/4C/BD/wKiom1REtw6Aqvk0AACKaGWdOLI248.jpg "Title =" qq201511551534.png "alt =" wkiom1retw6aqvk0aackagwdoli248.jpg "/>

2: Functions of Microsoft Excel

Data storage-data processing-data analysis-data presentation

3: Excel 2010 page

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M00/4C/BE/wKiom1REvWDzuiFhAAKDcasKLag938.jpg "Title =" qq 41020153453.jpg "alt =" wkiom1revwdzuifhaakdcasklag938.jpg "/>

Ii. Concepts of Excel

1: Excel files

XLS/XLSX thin file type

Xlw workspace file type (xlw files are similar to shortcuts and do not save file data)

Settings of excel2010 thin window arrangement:

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M01/4C/BE/wKiom1REvsSD4LQRAAAjEjEuRYA444.jpg "Title =" qq2015115454834.png "alt =" wkiom1revssd4lqraaajeurya444.jpg "/>

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M02/4C/BF/wKioL1REwRHw3iTOAAAO-a9WKiw635.jpg "Title =" qqpicture 2015115520..jpg "alt =" wKioL1REwRHw3iTOAAAO-a9WKiw635.jpg "/>

2: Work thin, worksheet, cell

Workbook: In Excel, files used to save data information are called workbooks. In a workbook, You can have multiple worksheets of different types. By default, an Excel worksheet has three worksheets.

Worksheet: a worksheet is a table displayed in a thin window. A worksheet can consist of 65536 rows and 256 columns.

Cell: a cell is the intersection of rows and columns in a table. It is the smallest unit of a table and can be split or merged. Input and modification of a single data are performed in cells.

A: Create a worksheet and change the worksheet name and tag color (delete)

Worksheet tab bar -- insert a worksheet -- Right-click a worksheet tag -- rename; worksheet tag color; Delete

650) This. width = 650; "src =" http://s3.51cto.com/wyfs02/M01/4C/BF/wKiom1REyenQJlR7AAEwdTo45sc944.jpg "Title =" qq201511663616.png "alt =" wkiom1reyenqjlr7aaewdto45sc944.jpg "/>

B: insert/delete multiple worksheets

I. know Excel 2010