OBJECTIVE OF THE CLASS
Identify the types of data that can be entered into cells to work with data of different types as requested or needed.
TYPE OF DATA
In spreadsheets, large amounts of data can be manipulated, so it is very important to know what type of data is being represented or used when creating our own content, that is, it is necessary to know if the format and appearance of the data is correct. To identify the types of data I recommend you remember the following:
The data that can be entered into the cells can be…
- Number. They are combinations of digits. It can be used to include numbers, dates, times, etc. In the case of dates and times, they must be entered with a specific date format.
- formulas. They are expressions that always begin with the equal sign, =, and contain operators or functions involving references to other cells.
- Text. They are sequences of characters (letters or symbols) that are not or are not identified as numbers or formulas.
It is important to recognize what type of data you are going to use both to recognize what the content of the table is about and to avoid errors when using formulas and/or functions.
To modify the type of data that you enter in a cell (and be sure that it is the correct type) we can use the "More formats" icon
in which we can select the different types of formats that you can use, you can also select from the FORMAT menu in the NUMBER option directly the type of data to manipulate.
ACTIVITY 01
We will carry out a couple of short examples together to understand how and when to use some of the data types, try creating this small table and after completing the class notes, carry out the activity that will be published in the classroom
CLASS NOTES
Write as always in your notebook the title of the class, the objective, write down the most relevant of the class taking note of what is published in the blog and what the teacher shared with you and at the end answer the following questions with your own words:
What is a data type in the spreadsheet?
Why do we consider it important to enter the data in a table correctly?
Which error(s) can appear if you use an incorrect data type?
