Formula Fun
What symbol must every Excel formula begin with?
= (equal sign)
What is a cell?
The intersection of a row and a column.
What is a spreadsheet used for?
Organizing, calculating, and analyzing data.
What formula finds the average of A1 to A5?
=AVERAGE(A1:A5)
Formula shows #DIV/0!. What does that mean?
Tried to divide by zero or an empty cell.
What formula adds the numbers in cells A1 through A5?
=SUM(A1:A5)
What is a cell reference?
The name of a cell, like A1 or C3.
Which bar displays formulas and functions?
The Formula Bar.
Which function adds up all values and divides by the count?
AVERAGE function
Formula shows #NAME?. What does that mean?
There’s a typo in the formula name.
What formula subtracts cell B2 from cell B1?
=B1-B2
What is a cell range?
A group of adjacent cells, like A1:A10.
What do columns use for labels?
Letters (A, B, C…).
How do you find the highest number in a range?
=MAX(A1:A10)
You see #### in a cell. What does that mean?
The column is too narrow to show the number.
What formula multiplies A3 and B3 together?
=A3*B3
Which part of Excel shows the address of the selected cell?
The Name Box.
What do rows use for labels?
Numbers (1, 2, 3…).
How do you find the lowest number in a range?
=MIN(A1:A10)
What’s wrong with this formula? =SUM A1:A10
Missing parentheses → should be =SUM(A1:A10)
What formula divides the total in C10 by the number in D10?
=C10/D10
True or False, Cells can not be formatted
False
How do you quickly sum a column of numbers?
Use AutoSum or press Alt + =.
What formula counts how many cells contain numbers?
=COUNT(A1:A10)
Why might =AVERAGE(B2:B6) give the wrong result?
Some cells may contain text or be blank.