v
Introduction
Project
Client
New Skills
Unit 2: Sheets
2.1
Employee Contact Information
Adrenaline Sports
Create a new spreadsheet · Rename a spreadsheet · Resize
column width · Enter data into a spreadsheet · Format text ·
Change fill color · Set print area · Print preview · Print a
spreadsheet · Share a spreadsheet · Assign permissions
2.2
Quarterly Donor Data
B4 U Click
Merge cells · Insert an image · Format text · Align text ·
Format as currency · Decrease decimal places · Use the SUM
function · Use Autofill · Add fill color · Add a cell border
2.3
Menu Items Annual Sales
Healthy Hut
Format text · Align text · Format as currency · Decrease decimal
places · Use the SUM function · Use the MIN and MAX functions ·
Use Autofill · Create and customize a pie chart
2.4
New Product Sales
Adrenaline Sports
Format text · Align text · Sort data · Use the Count function ·
Freeze rows
2.5
Monthly Blog Traffic
B4 U Click
Format text · Align text · Use Autofill · Create and customize
a line chart · Use the MIN and MAX functions · Use the
AVERAGE function · Decrease decimal places · Add a new
sheet · Rename a sheet
2.6
Annual Sales Forecast
Healthy Hut
Format text · Align text · Merge cells · Resize column width ·
Format as a number · Format as a percentage · Decrease decimal
places · Use the SUM function · Use Autofill · Use absolute cell
reference · Use cell borders
2.7
Grand Opening Budget
Adrenaline Sports
Format text · Align text · Format as currency · Use formulas ·
Use the SUM function
2.8
Social Media User Survey
B4 U Click
Format text · Align text · Merge cells · Add fill color · Create
and customize a column chart
2.9
Customer Traffic Pattern
Analysis
Healthy Hut
Collaborate using Google Sheets · Align text · Format text ·
Create and customize a bar chart · Use Autofill · Add a new
sheet · Rename a sheet · Use comments
Unit 3: Slides
3.1
Customer Service Training
Adrenaline Sports
Choose a theme · Insert and resize an image · Create a bulleted
list · Create a numbered list · Change line spacing · Present a
slideshow · Print preview a presentation · Share a presentation
3.2
Classroom Device Guide
B4 U Click
Insert and resize an image · Insert a table · Apply transitions ·
Present a slideshow
3.3
Digital Menu Sign
Healthy Hut
Insert word art · Insert shapes · Insert and resize an image ·
Change fill and line color · Change line weight · Apply
transitions · Add animation · Present a slideshow
3.4
Camping Tent Clearance
Display
Adrenaline Sports
Use color as background · Use an image as background ·
Insert word art · Insert and resize an image · Mask an image ·
Add an image border · Apply transitions · Present a slideshow
For Evaluation Purposes Only