Google Sheets allows users to add levels of certainty to charts by declaring values as estimates. In this video, Jess Stratton shows you how to create an estimate, and how it visually changes the chart.
- [Instructor] I have here a very simple sheet…that contains software and the…release order of that software.…I can turn it into a chart by selecting the data,…clicking insert chart, clicking chart types,…and choosing something as simple as a line chart…to denote the release order of this software.…I'm going to click cancel because there's…one more thing that I can add to this chart…with Google sheets.…I can add how certain I am of these values.…
Google sheets allows you to use the Boolean values…of true and false to denote certainty in your chart.…I'm going to add one more column…and I'll label it certainty.…In it I'm now going to label each one…with how certain I am.…For example, I know that these first two pieces…of software are going to be released…in this particular order.…I'm very certain so I'll call this true.…These last two could be swapped,…I'm not sure if this is the final order…so I'm going to put false.…
These are the only two values that are allowed…to be used when dealing with certainty…and estimates and Google chart data.…
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.