Multiple Lesson Coverage
Challenge: Phone Bill
Author: Colleen Hayes
Publication Date: 4/15/22
Keywords: merge, center, font size, font face, CONCAT, LEFT, RIGHT, AVERAGE, SUM, IF, format numbers, VLOOKUP, SUMIF, COUNTIF, conditional formatting, OR, sort, filter
Platform: Windows, Mac, and Online
Challenge: Business Sales for Weekend Donut Shop
Weekend Donuts is a local donut shop open on Fridays, Saturdays, and Sundays. They track weekend sales on a spreadsheet and are looking for your help to develop reports based on their sales data.
Authors: Colleen Hayes
Publication Date: 5/1/22
Keywords: copy and paste, fill color, group sheets, conditional formatting, formulas, named range, SUM, SUMIF, VLOOKUP, tables, table calculated column, table total row, column chart, Donut Chart, PivotTable
Platform: Windows, Mac, and Online
Business Sales for Weekend Donut Shop
Challenge: Where to Work
When looking at job offers as you graduate one important factor to consider is your salary relative to the cost of living where you are going to work.
Authors: Robert Wood, Colleen Hayes
Publication Date: 9/1/22
Keywords: formulas, VLOOKUP, data validation (list)
Platform: Windows, Mac, and Online
Challenge: To/From School
An off-campus student is analyzing the commuting costs involved with several approaches to planning the school year. He can plan his schedule so he must attend school either three times a week or five times a week, and he can either drive his car or take the bus.
Authors: Robert Wood, Colleen Hayes
Publication Date: 9/1/22
Keywords: formulas, one-way data tables, line chart
Platform: Windows and Mac