In this lesson, you managed and transformed the data you had organized, edited, and analyzedin previous lessons so that you could see specific data more clearly and make businessdecisions about the fundraiser, such as which salesperson should lead the next fundraiser,which t-shirt design should be cut from the offerings, or how many shirts need to be sold to make a profit.
To do this you:downloaded a spreadsheet in another file format and converted it to Google Sheets,added the new spreadsheet to your existing spreadsheet,used the SUM and MULTIPLY functions to calculate cost and revenue,used absolute cell references, subtraction formulas, and more functions to calculateprofit and summarize data,analyzed sales data using the MIN, MAX, and AVERAGE functions,applied conditional formatting to emphasize specific values,and inserted links, an image, and a drawing to create a broader picture of your data.
The skills you learned in this lesson are useful for other types of spreadsheet projects,as well. For instance, you might usethe MIN, MAX, and AVERAGE functions to find the best flight for an upcoming vacation,links to vendor websites and images of individual contracts in a wedding planning tracker,or conditional formatting when creating a job search tracker, to show the status ofyour applications.
Keep creating new spreadsheets to master the skills you learned in this lesson!
And explore more G Suite Certification lessons to learn and practice with other applications!
1. Introduction to G Suite Certification: Sheets - Part 3
2. Sheets: Copy Sheets Into Your Spreadsheet — Copy from .csv and .xls File Types
3. Sheets: Use Functions to Calculate Cost and Current Sales — Format Currency and View Function List
4. Sheets: Use Functions to Summarize Data and Calculate Profit
5. Sheets: Use the MIN, MAX, and AVERAGE Functions to Analyze Sales Data
6. Sheets: Add Conditional Formatting to Emphasize Data
7. Sheets: Insert Links, Images, Forms and Drawings