1
is used so that depending on the value of the cell, Excel applies a format special or not about that cell
2
s very similar to the conditional format, except that this feature has a very specific function and is to validate the contents of a cell; can even show a message of error or warning should the case arise.
3
is activated by clicking on the button the formula bar
4
merges several text elements into one
5
Returns TRUE if all its arguments are TRUE.
6
check if a condition is met and qualify as TRUE or FALSE
7
To form the conditions that we will use
8
technical and scientific knowledge to deal with information by computers
9
represent visually by one or more lines or geometric figures expressing the existing numerical data in a spreadsheet.
10
It includes the icons corresponding to the most used operations, they allow faster access since you do not have to display the menus
11
Obtain the average of the values found in a given column (field), considering Only those rows that meet a certain condition of a column or list that meet the established criteria.
12
Contains the address or name of the cell active in the spreadsheet.
13
is a grouping of cells that are grouped vertically from top to bottom of the workbook.
14
Use this function to return a value or reference to a value from a table or range.
15
It is each of the folios of a workbook.
16
software that allows to handle numeric and alphanumeric data arranged as a table and apply simple formulas and complex, allows arithmetic operations of different complexity, elaborations statistics, data generation, etc
17
is represented by letters and number, for example C4
18
It is the document in process of elaboration in Excel, and to which assigns xls extension. Each workbook can contain multiple leaves, by default usually appears with three.
19
Obtain the sum of the values found in a given column (field), considering Only the rows that meet a certain condition.
20
is a group of cells that are grouped horizontally from left to right of the workbook.
