Google Sheets has two types of references, Absolute References and Relative References.

You can combine the IMPORTRANGE function with other functions to analyse data in other Google Sheets files. Here are a couple of examples.

You can create rules to send email notifications when a cell changes in Google Sheets.

Paste Special allows you to copy Conditional formatting, Data validation and more within Google Sheets.

This post will teach you how to insert Google Sheets data into a Google Doc

If you click the advanced options you can change the look of the drop-down list, we have gone for the modern chip look but you can choose...