Getting to Know the Microsoft Excel Menu Sections and Their Functions

Microsoft Excel is world's most popular data processor. This software is used by various groups, from students, university students, to office workers because it is very effectively used to solve various problems related to data and numbers.

Microsoft Excel has been equipped with various formulas or formulas that make it easier for us to process data. With these formulas, we can solve various administrative problems, such as making financial reports, making data analysis, making various kinds of graphs, and so on.

So, here are the parts of the Microsoft Excel menu and their functions that Daily Social has summarized for you!

Microsoft Excel Functions

Microsoft Excel is popular enough to be used by many people because of the functions it has. Some of the functions of Microsoft Excel, among others:

1. To create, edit, sort, analyze to summarize data.
2. Help solve logic and math problems.
3. Make a list of attendance and list of grades.
4. Perform calculations to find out the results of a study.
5. Conduct price analysis and research.
6. Calculate and manage investments, loans, sales, inventory and more.
7. Perform mathematical and statistical calculations.
8. Create various kinds of graphs and diagrams.
9. Make financial records, budgets and prepare financial reports.
10. Perform currency conversion.

Sections in the Microsoft Excel Menu

Files Menu

1. New: Command to create a new worksheet.
2. Open: Command to open a document.
3. Close: Command to close the workbook window.
4. Save: Command to save data.
5. Save As: Command to save data that does not have a name.
6. Save As WebPage: Command to save into a web page.
7. Save Workspace: Command to save as a workspace file.
8. Search files: Command to search for workbook files.
9. Permission: Command to see what will be set in the data management page.
10. Web Page Preview: Command to view worksheets to be printed.
11. Page Setup: Command to set page settings.
12. PrintArea: Command to specify the worksheet to be printed.
13. Print Preview: Command to view worksheets to be printed.
14. Print: Command to print data.
15. Send To: Command to send files.
16. Properties: Command to Create a summary of the active file.
17. Exit: Command to close the Microsoft Excel program.

Edit menu

1. Normal: Command to display the worksheet in the normal position.
2. Page Break Preview: Command to view the cropped worksheet pages.
3. Task panel: Command to open the command view.
4. Toolbars: Command to display the toolbar.
5. Formula Bars: Command to display the formula row.
6. Status Bar: Command to bring up the status bar.
7. Header and Footer: Command to create headers and footers.
8. Comments: Command to bring up the comment toolbar and worksheet reviewing.
9. Custom Views: Command to save the print area of ​​the workbook.
10. Full Screen: Command to display the layer in full.
11. Zoom: Command to change the size of the worksheet.

Home menu

Insert Menu

1. Cell: Command to insert cells.
2. Rows: Command to add a row of cells.
3. Columns: Command to add a column.
4. spreadsheet: Command to insert a worksheet.
5. Chart: Command to create a graph.
6. Symbol: Command to insert symbol.
7. Page Break: Command to create truncated pages.
8. Function: Command to enter a logical function formula.
9. Name: Command to name the data range.
10. How: Command to make notes on the worksheet.
11. Picture: Command to insert a picture.
12. Diagram: Command to create diagrams.
13. Object: Command to insert an image.
14. Hyperlink: Command to link files with files.

Page Layout Menu

Tools menu

1. Spelling: Command to check the data.
2. Research: Command to search for files.
3. Error Checking: Command to check for errors.
4. track changes: Command to view changes by others.
5. Compare and Merge Workbooks: Command to merge multiple workbooks.
6. Protection: Command to secure data.
7. Online Collaboration: Commands to organize meetings and their scheduling.
8. GoalSeek: Command to change the value of the formula.
9. Scenarios: Command to make a summary in Microsoft Excel.
10. Auditing Formulas: Command to put the formula using the value in the active cell, set the cell and put the data into the formula.
11. Makro: Command to run the macro program.
12. Add-Ins: Command to activate or deactivate add – ins.
13. Autocorrect Option: Command to display the auto scratch command.
14. customisation: Commands for setting toolbars.
15. Options: Command to open menus and tabulations.

View menu

1. Normal: Command to display the worksheet in the normal position.
2. Page Break Preview: Command to view the cropped worksheet pages.
3. Task panel: Command to open the command view.
4. Toolbars: Command to display the toolbar.
5. Formula Bars: Command to display the formula row.
6. Status Bar: Command to bring up the status bar.
7. Header and Footer: Command to create headers and footers.
8. Comments: Command to bring up the comment toolbar and worksheet reviewing.
9. Custom Views: Command to save the print area of ​​the workbook.
10. Full Screen: Command to display the layer in full.
11. Zoom: Command to change the size of the worksheet.

Format Menu

1. Cell: Command to make the cell format.
2. low: Command to set the line height.
3. Column: Command to set column sheets.
4. Sheet: Command to format sheet.
5. AutoFormat: Command to create a table format.
6. Conditional Formatting: Command to format cell data values.
7. Style: Command to change the data on the worksheet.

Data Menu

1. Shorts: Command to sort data.
2. Filter: Command to filter data.
3. Form: Commands to add or remove data.
4. Subtotal: Command to calculate sub totals.
5. Validation: Command to limit the type of data entered.
6. Tables: Command to create a table.
7. Text to Columns: Command to make text script columnar.
8. Consolidate: Commands to consolidate data.
9. Groups and Outlines: Command to merge data.
10. Pivot Tables and Pivot Chart Reports: Commands for creating pivot tables and charts.
11. Import External Data: Command to import external data.
12. Refresh Data: Command to refresh data from outside.

So, those are the parts of the Microsoft Excel menu and their functions. Hope this article is useful for you!