- Microsoft Excel elements and functions
- 1- Toolbar
- 2- Ribbon
- 3- Columns
- 4-Row
- 5- Cells
- 6- Formula bar
- 7- Sheet label
- 8- Name box
- References
The elements of Excel are a series of tools and buttons that facilitate work when analyzing and organizing the data presented on the screen.
These elements include various bars, boxes, labels, rows and columns. Excel is a spreadsheet creation program created by Microsoft.
Excel is currently one of the most popular spreadsheet programs in the world, both in the office and at home.
It works by means of rows and columns that form cells in which monetary data, dates, inventories and dates can be included.
Microsoft Excel elements and functions
In Excel you can work with formulas, charts and program directly in lines of code. Among the greatest advantages and comforts of using the program is its formula bar, which allows you to use predetermined equations (such as summation) or create them comfortably.
When a formula is applied, the program "replicates" it in all the cells that are required, which saves an enormous amount of time, since only the data has to be entered and the results read.
1- Toolbar
Excel is an application of the Microsoft Office suite, so the use of its toolbar is quite standardized.
It includes basic commands for handling files such as saving, printing, opening or previewing.
2- Ribbon
It is located on the spreadsheet and spans the entire screen horizontally. On the ribbon you will find practically all the tools you need to work in Excel. It is divided into tabs for better organization of functions.
From the ribbon, you can edit the fonts and colors of the sheet, check the spelling, insert and import rows, columns or formulas, modify the view of the file or protect it against changes and edits.
3- Columns
Along with rows, columns are the fundamental part of how Excel works. They are arranged horizontally and identified with capital letters from A to Z.
The latest version of the program supports up to 16 thousand columns.
4-Row
They are a set of numerical elements organized vertically. The intersection of a row and a column is called a cell and is identified by a combination of letters and numbers (for example B14).
The latest version of Excel supports a little over a million rows.
5- Cells
They are each of the squared spaces on the spreadsheet. It corresponds to the cross between a row and a column, and is identified by a combination of the names of both.
6- Formula bar
It is an edit rectangle where the data in the cells can be modified. It is also possible to carry out mathematical operations such as addition, subtraction, multiplication, division, powers, and trigonometric functions.
Its use is very simple and it is normally used so that a cell automatically shows the value of an operation carried out among others. For example, cell B14 can show the result of the sum between cells A11 and B2.
7- Sheet label
It is located in the lower left and allows you to switch between several separate worksheets.
The number of sheets that can be handled at the same time depends on the amount of memory available and the power of the computer.
8- Name box
It is located next to the formula bar and indicates the cell in which you are working.
References
- Ted French (April 24, 2017). Excel Screen Elements. Retrieved on December 12, 2017, from ThoughtCo.
- Excel Elements (February 1, 2011). Retrieved on December 12, 2017, from Using Excel.
- Lisa Bass (nd). Elements of Microsoft Excel. Retrieved on December 12, 2017, from Techlandia.
- Megaguide: Excel for beginners (nd). Retrieved on December 12, 2017, from Ayuda Excel.
- Basic elements of excel (January 31, 2016). Retrieved on December 12, 2017, from Excelitz.