Editing files using Google spreadsheet

Page | of 1

Google Sheets – Assignment #2

Store Spreadsheet

Please download these instructions for your reference.

Below is a sample 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, and the names of the items.

2. Center the column titles, dates, and scores.

3. Italicize the Total Sales ($) column title.

4. Use a formula to total the Daily Sales for each column

a. Hint: Total the Sales the way it was taught in the Tutorial

5. Use a formula to total the Total Sales ($) for each row

a. Hint: Total the Sales the way it was taught in the Tutorial

6. Name the file: Store Spreadsheet

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

8. Name the folder G Suite

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

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