Formulas & Basic Functions

One feature that makes Sheets different from other applications is the powerful ability to work as a calculator. Basic math functions, such as addition, subtraction, multiplication, and division, are a breeze when data is used in formulas. When cell references are included in the formula, data in those cells can change, and the formula will do the work of updating the math for you. One of the most commonly used functions in Sheets is the SUM function, which will add up a range of adjacent cells. All functions and formulas can be copied and pasted to other cells, and the row or column reference will be updated. In this video, you will learn how to create basic formulas and functions to calculate data and analyze the data to make better business decisions. This video was created in relation to the Utah State CTE standards for the Business Office Specialist High School course. Specifically, this video prepares students to complete Strand 2, Standard 4: Create and code formulas and functions within a workbook/worksheet. This video uses the Basic Formulas document which you can copy by clicking the link below if you want to follow along. https://docs.google.com/spreadsheets/d/1Adeo8zihxVbhvsJtWgQzANuQso6_nsp6w9GwU0DlNXQ/copy