Embedded Files
Writing Formulas Using Functions
Writing Formulas Using Functions
Functions are used to form all or part of a formula. We will be using the Functions button located within the Toolbar. Alternatively, you can also insert a function from the Insert >> Function menu option in Google Sheets.
Whenever you click the Function button, Google Spreadsheets gives you the option of inserting a function in the active cell.
Do the following:
➤ With your Grades spreadsheet still open, select cell C11 and click on the Functions button. Select the SUM option.
You want to sum up B2 through B10, this is denoted in a more compact form as B2:B10.
Do the following:
➤ Position your cursor in the parentheses next to SUM, and type in B2:B10.
NOTE: You can also click on cell B2 and drag your cursor down to B10, selecting all cells in between. After cells B2 through B10 are highlighted, press the Enter/Return key to enter the formula.
The Sum function is one of the many functions Google Spreadsheets provides. It also provides many statistical functions in particular the Average function. To learn about the other functions that are provided, select the Learn more under the Functions button.
Now that you know how to enter formulas using operators and functions, you can practice on your "Checking" spreadsheet.
Do the following:
➤ Open your Checking spreadsheet from your Google Drive
➤ Select cell E3 and enter the following formula: =E2-C3
This formula will compute your balance after your purchase was made at Stop and Shop.
➤ Select cell E4 and enter the following formula: =E3+C4
This formula will compute your balance after a direct deposit was added to your account.
➤ Select cell E5 and enter the following formula: =E4-C5
This formula will compute your balance after an online payment to Verizon was made.
➤ Select cell E6 and enter the formula that would compute the balance after a cash withdrawal was made at the atm.
If something is incorrect in your "Checking" spreadsheet, review your formulas and look for errors. Next, you will learn how to format in Google Sheets.
Page updated
Google Sites
Report abuse