Microsoft Excel

Iniziamo. È gratuito!
o registrati con il tuo indirizzo email
Microsoft Excel da Mind Map: Microsoft Excel

1. ingredient

1.1. Title Bar

1.1.1. This is the section that shows the program name. And the list of files has been enabled.

1.2. Quick Access

1.2.1. It is used to display frequently used commands.

1.3. File

1.3.1. It is used to store commands in the program.

1.4. Ribbon

1.4.1. This is a list of commands.

1.5. Status Bar

1.5.1. Part of the page. And the number of characters used in the document.

1.6. Name Box

1.6.1. This is the channel used to display the name of the active at that time.

1.7. Formula Bar

1.7.1. It is used to display the use of various calculation formulas.

1.8. Cell

1.8.1. The table field is used to store the data, each cell box is named after the row. And columns showing the position of the cell.

1.9. Column

1.9.1. Is a vertical cell of the worksheet (Worksheet)

1.10. Row

1.10.1. A horizontal cell slice of the worksheet.

1.11. Sheet Tab

1.11.1. A bar that shows the number of sheets opened.

2. benefit

2.1. Create summary reports in various views, such as sales summary tables. Product summary table, summary of production plan, summary of information, lack of staff line, etc.

2.2. Create graphs of various types of information. Whether it's a bar graph, a pie chart, 2D and 3D dots, there are many variations.

2.3. Create a document that needs to be computed. Link Formula

2.4. Create a worksheet Beautiful table In various ways

2.5. Initial data storage of up to 1 million rows

3. Limits

3.1. 1,048,576 rows by 16,384 columns

3.2. Number of Sheets in Workbook = Unlimited

3.3. The list will be in the dropdown = 10,000.

3.4. Stacking function = 64

3.5. Maximum Variable Function = 255 Variable

3.6. Number of people open simultaneously = 256

3.7. Steps of Undo = 100 steps

3.8. Number of columns in Pivot = 16,384

3.9. จำนวน แถว ใน Pivot = 1,048,576