Upon completion of Lesson 5, you will be able to:
- Identify the parts of a function.
- Enter formulas with functions.
- Use functions to solve mathematical problems.
- Use functions to solve statistical problems.
- Use functions to solve financial problems.
- Use logical functions to make decisions with worksheet data.
- Use functions to insert times and dates in a worksheet.
- Use text functions to format and work with cell contents.
Lesson 5 Folder
- Create a new folder inside of your Google Spreadsheet folder and name it Lesson 5.
- Once your folder is created, you will need to locate the following shared files in this Lesson 5 folder:
- Functions
- Finances
- Test
- National
- Team
- Golf
- Xanthan
- Occidental
- Make a copy of these files, move those copies into the Lesson 5 folder, and rename them without the Copy of so the Google Spreadsheet looks like the file names above.