1
is a useful tool to identify patterns or trends in a spreadsheet.
2
Search or replace text and numbers in a spreadsheet. Use the Search and Replace features in Excel to search for items in your book, such as a particular number or string. On the Home tab in the Edit group, click
3
Load and activate the Tools for analysis. Click on the File tab, choose Options and then click on the Add-ons category.
4
one of the text functions, to join two or more strings of text into one.
5
which format is used to identify patterns or trends in a spreadsheet.
6
To summarize the results of separate spreadsheets and report with them, you can consolidate data from each of them into a master spreadsheet.
7
is part of the group of logical functions and allows us to evaluate a condition to determine if it is false or true. The SI function is of great help in making decisions based on the result obtained in the logical test.
8
Set of technical knowledge that deals with the automatic processing of information through computers.
9
The Excel Page Layout menu tab is a horizontal bar that is part of the Excel ribbon and allows you to change margins, size
10
In a spreadsheet in the source book, click the cell in which you want to create a hyperlink. You can also select an object, such as an image or an element of a graphic, that you want to use to represent the hyperlink
11
performs the "function" of adding.
12
que tipo de tabla nos permite crear reportes sin la necesidad de emplear fórmulas en su creación.
13
Excel filters facilitate the search of a subset of data within a range to be able to work with it.
14
Set page margins before printing a spreadsheet.
15
is an equation that calculates a new value from the existing values. The result will be assigned to the cell in which the formula is entered.
16
A graph is the representation of data, generally numerical, by lines, surfaces or symbols, to see the relationship that these data have with each other and facilitate their interpretation.
17
are those that are identified by letters in an excel book
18
A cell can contain text, numbers, date, instructions, functions or other data. You can also combine the calculation with data or instructions
19
A table in Excel is a set of data organized in rows or registers, in which the first row contains the headers of the columns (the names of the fields), and the other rows contain the stored data.
20
corresponde a la información que se almacena en las celdas de la hoja de cálculo.
