is a fact that is inserted directly into a cell. It may be a number, a date or time, or text. NUMBERS
To enter characters can include numbers and special characters 0,1,2,3,4,5,6,7,8,9 + - () /% E e. Pts
signs (+) before the numbers are ignored, and to write a negative number it must be preceded by the sign (-).
When writing a number in parentheses, Excel interprets it as a negative number, which is typical in accounting.
The character E or e is interpreted as scientific notation. For example, 3E5 is equivalent to 300000 (3 10 to 5).
can include thousand points in the numbers entered as constants.
When a number has a comma is treated as a decimal.
if after a number is written Pts, Excel assigns the number and currency format and will be in the cell, but in the formula bar that symbol will disappear.
If we introduce the symbol% \u200b\u200bat the end of a number, Excel sees it as a percentage symbol.
If you enter fractions such as 1 / 4, 6 / 89, you must first enter a zero for any confusion with date numbers.
If a number does not fit in his cell as a first step it automatically switches to scientific notation.
By default the numbers appear right aligned in the cell. DATE OR TIME
To enter a date or time, simply to type the way we want it to appear.
As the numbers (as they really are), the dates and times also appear right aligned in the cell.
When you enter a date between 1929 and 2029, only need to enter the last two digits of the year, but for those dates do not fall within this range, we necessarily enter the full year.
Examples:
01/12/1999 2:30 PM 01/12/1999 12/07/2031 14:30 01/12/1999 14:30
TEXT
To enter text as a constant, select a cell and enter text. The text can contain letters, digits and special characters that can be played in the printer. A cell can contain up to 16,000 characters of text.
If a text does not fit in the cell can use all that are blank adjacent to the right to display, however the text is stored only on the first cell.
The text is by default left aligned in the cell.
Formulas.
is a sequence consisting of: constant values, references to other cells, names, functions, or operators.
A formula is a basic technique for data analysis. You can perform various operations with data from spreadsheets as *,+,-, Sen, Cos, etc ...
in a formula can be mixed constants, names, references to other cells, operators and functions. The formula is written in the formula bar and should always start with the sign =.
The different types of operators are: ARITHMETIC
used to produce numerical results. Example: + - * /% ^
TEXT is used to concatenate cells containing text. Example:
RELATIONAL to compare values \u200b\u200band provide a logical value (true or false) as a result of the comparison. Example: < > = <= > REFERENCE = <>
indicates that the value produced in the cell referenced should be used in the formula. In Excel include: Operator
range indicated by a colon (:), is used to indicate a range of cells. Example: A1: G5
Union operator indicated by a comma (,), joins the values \u200b\u200bof two or more cells. Example: A1, G5
For information on the precedence of operators: .
FUNCTIONS A function is a special formula written in advance and that takes a value or values, performs some calculations and returns a result.
All functions must follow syntax and if it is not respected Excel will display an error message.
1) If the function goes to the beginning of a formula must begin with the sign =.
2) The arguments or input values \u200b\u200bare provided in parentheses. Do not leave spaces before or after each parentheses.
3) The arguments can be constant values \u200b\u200b(number or text), formulas or functions.
4) The arguments must be separated by ";".
Example:
= SUM (A1: B3), this function is equivalent to = A1 + A2 + A3 + B1 + B2 + B3
