CLASS OBJECTIVE
Create and customize Google Sheets charts, by adjusting the fonts and colors of its elements, to highlight important information as well as the contribution that the use of data validation gives.
DATA VALIDATION
Data validation in Google Sheets is a feature that allows you to verify and ensure the accuracy of information entered into spreadsheets, reducing errors and facilitating consistent data management. Drop-down list: Limits the options available in a cell to specific items from a predefined list. Valid numbers: Restricts entry to certain numerical ranges or specific values. Valid dates: Ensures that only valid dates are entered according to a set format.
How to apply?
Click and drag to select the cells you want to apply validation to.
Access the data validation menu: Go to the menu bar at the top and select “Data”.
Choose “Data Validation”.
Then the validation options panel will appear to activate the desired options.
By having multiple options we will modify only one example and in subsequent classes or activities we will make and apply more examples.
