Use Functions, Formulas, and Charts in Google Sheets
A skill badge is an exclusive digital badge issued by Google Cloud in recognition of your proficiency with Google Cloud products and services and tests your ability to apply your knowledge in an interactive hands-on environment. Complete the skill badge quest, and final assessment challenge lab, to receive a digital badge that you can share with your network.
When you complete this activity, you can earn the badge displayed above! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!
Create charts using Google Sheets to share your data in an interesting way. Learn to create pie charts, column charts, combo charts and scatter charts. You also create sparklines and progress bars and learn how to share your spreadsheet in Google Slides and over the web.
Ensure that your data is valid and prepared for analysis using Google Sheets features and functions to organize, standardize, and clean data.
Finding specific content in large spreadsheets can be tricky. Learn to manipulate, search and substitute values in Google Sheets using features and functions like VLOOKUP, SUBSTITUTE and QUERY.
With Google Forms, you can create a survey, validate responses, and add custom logic that shows questions based on answers. In this lab, you create a Google Form and analyze the responses in Google Sheets using functions with conditional logic.
Create pivot tables to quickly summarize large amounts of data and reference data using named ranges. Use functions and formulas to calculate descriptive statistics.
In this challenge lab you demonstrate your knowledge of Google Sheets that you learned from the Use Functions, Formulas and Charts in Google Sheets quest.