Excel Basics
What do we call the entire Excel file?
Workbook
What symbol must every formula start with?
=
What function adds numbers in Excel?
SUM
Does Google Sheets use ALT + =? (Yes or No)
No
What error appears when dividing by zero?
#DIV/0!
What is the name of one sheet inside a workbook?
Worksheet
Which symbol is used to multiply in Excel?
*
What formula adds cells A1 through A5?
=SUM(A1:A5)
What mistake happens if you forget the = sign?
Excel won’t calculate
What is the box where a row and column meet called?
Cell
What symbol is used to divide numbers?
/
What does =SUM(B2:B5) do?
Adds all values from B2 to B5
What key do you press after typing a formula?
Enter
What error appears if a function is spelled wrong?
#NAME?
What does cell A1 represent?
Column A, Row 1
Which symbol represents exponents (powers)?
^
What happens if you forget the parenthesis in SUM?
The formula will not work
What happens when you drag a formula down a column?
The formula copies
What happens if you leave a cell out of your SUM range?
The total will be incorrect
What is the difference between a row and a column?
Rows go left to right; columns go up and down
Which symbol is used to add numbers together?
+
What tool button can you click in Google Sheets to add numbers automatically?
Σ (Functions button)
What does B2:B5 mean in a formula?
Cells B2 through B5
Which error appears if a cell reference is deleted?
#REF!