Using data in Sheets 2022

While working in Google Sheets you will often use a cell value in a formula or another location. Discover how to use absolute mixed and relative cell references in formulas or to extract values from other cells. These cell references will also be useful to create a formula with data from multiple sheets. Lastly learn how to define data ranges for creating different types of menus such as drop-down menus using the data validation tool.