The excel elements are a series of tools and buttons that facilitate work when analyzing and organizing the data presented on the screen. These elements include several bars, boxes, labels, rows and columns.
Excel is a program for creating spreadsheets created by Microsoft. It 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.
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.
Excel is an application of the Microsoft Office suite, so the use of its toolbar is quite standardized.
Includes basic commands for handling files such as saving, printing, opening or previewing.
It is located on the spreadsheet and spans the entire screen horizontally. In the ribbon of options you will find practically all the necessary tools 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.
It consists of the cell window in which you are working. They can be opened as many as you want.
They are each of the squared spaces on the spreadsheet. Corresponds to the cross between a row and a column, and is identified with a combination of the names of both.
Along with rows, columns are the fundamental part of how Excel works. They are organized horizontally and identified with capital letters from A to Z.
The latest version of the program supports up to 16 thousand columns.
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.
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.
It is located in the lower left and allows you to switch between several separate spreadsheets.
The number of sheets that can be worked with at the same time depends on the amount of memory available and the power of the equipment.
It is located next to the formula bar and indicates the cell in which you are working.
It can be selected in the 'View' tab of the ribbon or in the lower right part of the sheet. There are three types of file view in Excel: Normal, Page Layout, and Preview. It is used to arrange the sheets and pages according to the visual needs of the user. Includes zoom to zoom in or out of work.
Once the file has been completed, it is necessary to save the work and export it to the most suitable format for the needs. To do this, in the file panel there is the 'Export' tab, with which you can select if you prefer to convert the Excel file into .txt or .cvs, or in PDF.
Yet No Comments