Assignment: Edit a Spreadsheet

Opened: Thursday, 5 October 2023, 12:00 AM
Due: Saturday, 30 December 2023, 12:00 AM
View Make a submission

Objective: To be able to produce a Google Sheets spreadsheet that is easy to read.

Instructions:

  1. This assignment must be done using a computer desktop or laptop.
  2. Download the attached Microsoft Excel file.
  3. In your Google Sheets application, open the Excel file.
  4. Edit or update the formatting of the data so that they become easy to read. 
  5. Insert a chart based on the column "progress". No need to configure the chart any further. Just a pie chart will suffice
  6. Once you're done with the spreadsheet, make a screenshot of it, making sure that:
    1. The entire width of the window is captured, and
    2. Both the upper part of the window (showing the document title and your profile image) and the content are captured.
  7. See the attached sample screenshot of a Google Sheet spreadsheet for your guidance.
  8. Submit the screenshot.