From the course: Introduction to Google Sheets
Join today to access over 24,900 courses taught by industry experts.
Basic functions - Google Sheets Tutorial
From the course: Introduction to Google Sheets
Basic functions
To create a formula, select a cell and type equals to begin. Google Sheets may suggest one or more functions or ranges for the formula based on the data in the sheet once you begin typing. Type equals into cell C11 to show how Google Sheets suggest an appropriate sum formula for the column. This function box will show the functions based on what has been typed, along with a brief explanation of the function's purpose. Type the open parentheses key to begin selecting a range to apply the formula to. A range can be selected by typing the beginning and ending addresses of the cells in the range clicking and dragging to select the cells, or by using the arrow keys on the keyboard of your device. To select cells that are not adjacent for the range, hold the control key on Windows or command key on macOS and select the cells for the range. As cells are selected for the range, they will be highlighted in the color that their address appears in. As part of the formula for easy identification.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.