Formulas
What function adds a column of numbers?
What is SUM()?
How can you quickly fill in the days of the week?
What is Drag-Fill?
How do you keep the top row visible while scrolling?
What is Freeze Panes?
How do you reference another sheet in a formula?
What is =Sheet2!A1?
This co-founder of Microsoft helped develop the original spreadsheet program that later inspired Excel.
Who is Bill Gates?
What symbol is used to start a formula?
What is = ?
How do you sort data from highest to lowest?
What is Sort Z→A?
Where do you find the Freeze Panes option?
What is the View tab?
How can you rename a sheet?
What is Right-click → Rename?
Excel was officially launched in this year, the same year Michael Jackson released Bad and “The Simpsons” first appeared on TV.
What is 1987?
How do you add two cells together?
What is = A1+B1?
What tool summarizes large datasets by category?
What is Pivot Table?
What’s the shortcut to go to the top of the sheet?
What is Ctrl + Home?
How do you move a sheet to a new workbook?
What is Move or Copy Sheet?
This iconic 90s sitcom featured a character who might’ve said “Pivot!”—just like you do when building tables in Excel.
What is Friends?
What function multiplies all values in a range?
What is PRODUCT()?
What does conditional formatting do?
What is change cell style based on values?
🎯 DAILY DOUBLE 🎯
What is Ctrl + Page Up/Down?
What’s the shortcut to add a new sheet?
What is Shift + F11?
Before Excel, this spreadsheet program helped launch the Apple II computer into business success.
What is VisiCalc?
How do you calculate the average excluding blanks?
What is AVERAGEIF?
What is the function to find the most common value?
What is MODE()?
What shortcut opens the Find/Replace dialog?
What is Ctrl + F?
How do you protect a sheet?
What is Review → Protect Sheet?
This U.S. president was in office when Excel first launched.
Who is Ronald Reagan?