81
Project Description
B4 U Click has completed a survey of the most popular social media apps
for teenagers in Lake County. They would like the data displayed as a
column chart to keep parents informed about how their children are using
social media.
Your Job
As the Google Sheets Specialist, you will create a social media user survey spreadsheet and column chart using
the data collected from the social media app survey.
Skills:
Format text
·
Align text
·
Merge cells
·
Add fill color
·
Create and customize a column chart
Instructions
1. Open the B4 U Click folder and create a new Google Sheets spreadsheet.
2. Unless otherwise instructed, rename the spreadsheet Project 2.8 Social Media User Survey.
3. Key the data into the spreadsheet as shown in Figure 2.8.
4. Resize the width of columns A C to 150.
5. Center align columns A C.
6. Merge cells A1 C1 and format the text in the newly merged cell as font size 12 point, bold, and center aligned.
7. Format the text in cells A4 C4 as bold and change the fill color to yellow.
Unit 2: Sheets
Project 2.8
Social Media User Survey
Unit 2: Sheets
For Evaluation Purposes Only