78
Project Description
Adrenaline Sports is opening a new store in a larger city 20 miles away. To
promote the new store, they will be having a Grand Opening Celebration.
Before organizing this event, a budget is needed in order to plan for the
upcoming expenses.
Your Job
As the Google Sheets Specialist, you will create a grand opening budget spreadsheet to calculate the expenses
related to decorations, refreshments, advertising, extra staff, a VIP appearance, and promotional prizes.
Skills:
Format text
·
Align text
·
Format as currency
·
Use formulas
·
Use the SUM function
Instructions
1. Open the Adrenaline Sports folder and create a new Google Sheets spreadsheet.
2. Unless otherwise instructed, rename the spreadsheet Project 2.7 Grand Opening Budget.
3. Key the data into the spreadsheet as shown in Figure 2.7.
Hint: Resize the columns so that all data fits appropriately.
4. Format the text in cells A1 and A2 as font size 14 point and bold.
5. Format the text in rows 4, 6, 9, 11, 17, 19, 26, 28, 33, 35, 39, 41, 46, and 48 as bold.
6. Center align column B.
Unit 2: Sheets
Project 2.7
Grand Opening Budget
Unit 2: Sheets
For Evaluation Purposes Only