69
Project Description
In September, Adrenaline Sports began selling a new brand of energy bars
called Full Power. To determine the success of the new product, the Store
Manager would like to know which flavors were the most popular with
customers. This report will help determine the selection of flavors that will
continue to be sold.
Your Job
As the Google Sheets Specialist, you will create and format a new product sales spreadsheet that sorts the sales
of each flavor of energy bars from highest to lowest. The spreadsheet will also calculate the total number of new
items in the energy bar line.
Skills:
Format text
·
Align text
·
Sort data
·
Use the Count function
·
Freeze rows
Instructions
1. Open the Adrenaline Sports folder and create a new Google Sheets spreadsheet.
2. Unless otherwise instructed, rename the spreadsheet Project 2.4 New Product Sales.
3. Key the data into the spreadsheet as shown in Figure 2.4.
4. Format the text in cells A1 and A2 as font size 14 point and bold.
5. Format the text in cells A4 and B4 as bold.
6. Center align column B.
Unit 2: Sheets
Project 2.4
New Product Sales
For Evaluation Purposes Only