Overview

This exercise introduces the basics of Google Sheets — an online tool for organizing data, performing calculations, and managing information efficiently.

What Should You Do?

Watch the videos in the Google short courses

1. Google Workspace: Sheets - Part 1 (equivalent YouTube video)
2. Google Workspace: Sheets - Part 2 (equivalent YouTube video)
   • Only the “Create Filters and Use Filter Views” section

Note: If you want to practice with the Google Sheets used in the videos, you can access them through the YouTube links.

Apply What You Learned

1. Make a copy of this Google Sheet

2. In your own copy, replace “YOUR_NAME” in the title with your own name

3. Row and Column insertion, and AutoFill

   • Insert a column before column A
   • Insert a row before row 1
   • Enter “Shirt Sales Information” in cell B2 and set the font size to 24
   • Use AutoFill to fill cells A4:A103 with the numbers 1 to 100

4. Format and Freeze Headers

   • Fill rows 1-3 with three different background colors
   • Change the font weight of rows 1-3 to bold
   • Center the text in rows 2-3
   • Freeze rows 1-3 so they remain visible at the top when scrolling vertically

5. Edit Cells

   • Enter “Sale ID” in cell A3
   • Enter “Other Information” in cell K2
   • Change the value in cell K3 to “Payment”
   • Change the value in cell L3 to “Source”

6. Merge Cells

   • Merge cells E2:G2 (three cells, from E2 to G2)
   • Merge cells H2:J2 (three cells, from H2 to J2)
   • Merge cells K2:L2 (two cells, K2 and L2)

7. Adjust Columns and Delete Unwanted Columns

   • Adjust column widths to remove extra space
   • Delete all columns beyond column L (do not delete column L)

8. Apply Border

   • Apply top and bottom borders to rows 2-3
   • Apply left and right borders to columns A-D
   • Apply right borders to columns G, J, and L
   • On row 1, clear all borders except the bottom border
   • On row 3, apply borders to every cell

9. Apply Filter

   • Use filters to show only rows that satisfy both of the following conditions:
     • Condition 1: Point of Sale is London or Glasgow
     • Condition 2: Date is between 1 June 2024 and 31 December 2024
   • Use a filter to order the rows by Date in ascending order

Here is a reference screenshot (sample) for you to check if you have successfully applied all the changes.

Share your Google Sheet to Public

Set the sharing settings of your Google Sheet to “Anyone with the link can view”.

Submit the Google Sheet link

Submit the shared link of your Google Sheet in Step 3 on the CYF Course Platform.

A volunteer will review your submission and check that it meets the acceptance criteria. They will give you feedback on your submission and help you make any changes needed to meet the criteria.

Here are the criteria you need to meet:

• You have edited, formatted, and applied filters on the Sales Data Google Sheet according to the instructions.
• You have added your name to the Google Sheet’s file name (title).
• You have made the Google sheet publicly viewable.
• You have submitted the Google Sheet link on the CYF Course Platform

Submission

You must do this on the CYF Course Platform.

1. Submit a link to your Google Sheet

When you have a question, ask it.

When you have questions about coursework, ask in a workshop🧶🧶 workshopCode Your Future Workshops are meetings where you can get technical help. or in Slack🧶🧶 SlackSlack is messaging software - once you have downloaded Slack you can visit our Slack workspace to ask your questions.

You do not need to wait for a workshop to ask a question. You can ask questions in Slack at any time. We are here to help you understand and complete this course. Our goal is to help you learn.

Use your new skill in real life:

This optional step is just for you. You don’t need to submit it. Next, make a spreadsheet to track your job applications. Use Google Sheets to evaluate the data in your spreadsheet.