Post by account_disabled on Dec 23, 2023 9:50:30 GMT
Now the other sheets, let's see what can be done with all of that. How to use a cell correctly It's time to understand how to properly work with a cell. It is essential to work with Excel. A cell can contain information of three different natures: Text (labels): A set of letters and numbers (strings) that serve to identify or order a set. In the example above, B1, C1, D1 and E1 are text cells, just like A2, A3. A4 and A5. Numbers (values): Composed only of number, a "value" contains data that can be understood in various ways, such as number, percentage, date or others. The nature of a value must be declared to prevent Excel from making mistaken interpretations.
For example, the number "100586" can be Special Data understood as: Currency: 100586 is $100,586.00 Date: May 10, 1986 Date: 05/October/0086 And all the information is correct, what they are missing is the context! Formula: is an instruction that tells Excel or the Spreadsheet what to do to occupy that place. All formulas begin with the equal sign (=) and thus transform the content of the other cells. Recording numbers correctly in cells To tell Excel what type of numbers we are giving it, we have to select the cells, click "Format" and then "Number.
Automatic" is the standard, which attempts to guess the type of information, but can be flawed. “Plain text” ignores the number and treats it as neutral information, part of a text, but without any mathematical meaning. Let's go back to our example: I clicked so that each cell was seen with the identifications: B2: “Number”. The number 400 gained decimal houses. B3: “Currency”: The number 1000 gained a dollar sign and also a marker for cents. B4: “Date”: The number 250 was converted to September 6, 1900. (250 days after 01/01/1900) B5: “Scientific” The number 5600 in scientific notation. Ou is 5.6*10^3 (5.6 times 10 cubed) The most important thing now is that you know that, based on the notation given to the program, your number will be understood differently. Therefore, you have to know how to choose them well.
For example, the number "100586" can be Special Data understood as: Currency: 100586 is $100,586.00 Date: May 10, 1986 Date: 05/October/0086 And all the information is correct, what they are missing is the context! Formula: is an instruction that tells Excel or the Spreadsheet what to do to occupy that place. All formulas begin with the equal sign (=) and thus transform the content of the other cells. Recording numbers correctly in cells To tell Excel what type of numbers we are giving it, we have to select the cells, click "Format" and then "Number.
Automatic" is the standard, which attempts to guess the type of information, but can be flawed. “Plain text” ignores the number and treats it as neutral information, part of a text, but without any mathematical meaning. Let's go back to our example: I clicked so that each cell was seen with the identifications: B2: “Number”. The number 400 gained decimal houses. B3: “Currency”: The number 1000 gained a dollar sign and also a marker for cents. B4: “Date”: The number 250 was converted to September 6, 1900. (250 days after 01/01/1900) B5: “Scientific” The number 5600 in scientific notation. Ou is 5.6*10^3 (5.6 times 10 cubed) The most important thing now is that you know that, based on the notation given to the program, your number will be understood differently. Therefore, you have to know how to choose them well.