The list is the best data validation that you should use if you want to restrict the values to a specific set.
<h3>What is data validation in a spreadsheet?</h3>
This is a feature in a spreadsheet such as excel that helps to control the entries that the users are allowed to input in a cell.
You can use this excel feature to ensure that a value is a number that is between 1 and 5.
<u />
<u>Complete question:</u>
You want to restrict the values entered in a cell to a specified set, such as hop, skip, jump. Which type of data validation should you use?
database
list
input range
custom
Read more on data validation here: brainly.com/question/25895973
To find the maximum and minimum (5,-9)
