Creating and testing the data validation
With your data optimized and your named ranges set up, in this task you will set up a data validation to allow a user to select a date from a list.
이 연습은 강의의 일부입니다
Google Sheets로 배우는 데이터 시각화
연습 안내
- In Sheet1, enter in the heading 'SM8 Smart Marine Systems ASX' in cell
A15. - Starting in
A16(through toE16), enter in the column headingsDate,Open,High,LowandClose. - In the same sheet, select the cells
A17:A26and create a data validation using the named rangeDates.- With your cells selected, you can set a new data validation by selecting 'Data' and then 'Data validation' from the menu.
- Be sure to use the 'List from a range' setting, and provide your named range.
- Use the data validation settings to also ensure the following text is available for those who need help: 'Select a date from the list to see Opening and Closing prices'.
