Editing files using Google spreadsheet

Page | of 2

Google Sheets

Assignment: 1st Quarter Test

Please download these instructions for your reference.

Spreadsheets had their start in the business world, but now everyone uses them. They are great for making lists, adding long lists of numbers and creating graphs.

Below is an example of a spreadsheet that you must recreate in Google Sheets. You must type the information and make the changes below.

Format the information in your spreadsheet in the following ways:

1. Bold all the column titles (including dates), and names

2. Center the column titles, dates, and scores

3. Italicize the Total Points column title

4. Below the row containing the name Denzel Washington skip a row and then type AVERAGE, and bold and italicize it

5. Use a formula to find the total points for each student

a. Hint: Use the Sum formula that was taught in the Tutorial

6. Use a formula to find the average score for each test

a. Hint: Use the Average formula that was taught in the Tutorial

7. Name the File: 1ST Quarter Test

8. When complete create a folder in your Google Drive

9. When complete, create a folder in your Google Drive (only one folder is needed; this will be repeated).

10. Name the folder G Suite

11. Put this assignments for Google Sheets in the G Suite folder

12. When all your assignments for Google Sheets are complete; share the G Suite folder URL in Canvas for a grade