Why do we use excel?
a. to solve math problems
b. to write letters
A
100
What symbol do you use to multiply?
a. x
b. *
B
100
What does the sum function do?
a. adds up a range of numbers
b. finds the smallest number
A
100
Add a thick border around a cell
good job!
100
Change the font in a cell to tahoma 20 point
Awesome!
200
Why do we use microsoft word?
a. to solve math problems
b. to write letters
B
200
What symbol do you use to divide?
a. /
b. *
A
200
What does the max function do?
a. subtracts a row
b. finds the biggest number
B
200
Change the fill color of a cell to blue.
Great Job!
200
Wrap the text in a cell.
Terrific!
300
What is a relative cell reference?
A cell reference in a formula that changes as the formula is moved from cell to cell.
300
Write is the formula for how much money I have left?
Cell A1 - 100 dollars (started with)
Cell B3 - 55.90 (bought a usb powered gumball machine)
A1 - B3
300
Use the sum function on this row of numbers:
34
42
23
sum(A1:A3)
300
What is this task asking you to do?
Specify that text in the current cell will appear on multiple lines within the cell.
Wrap text
300
Merge and center a title from columns B to D
nice!
400
What is an absolute cell reference?
A cell reference that stays the same no matter where the formula is moved.
400
What is the formula for finding a 5% increase.
Cell A10 - 5,554 dollars
A10 * 1.05
400
What are the three ways you can sum up a row of numbers?
Choose then click sum
Click sum then choose
click sum then type in the range
400
What is this task asking you to do?
Specify that the formula in the edit line will always multiply by cell A4 even if pasted into another cell.
Make an absolute cell reference
400
In a rectangle of four cells, add a double blue bottom border, a green dashed center border, and a red solid border on the left, right and top. Change the fill color to yellow.
Sweetness!
500
Why do we worry about the formatting of our spreadsheets?
Because most people don't use excel! We are the experts and we need to communicate.
500
What is the formula for finding a 6.2% increase using an absolute value?
Cell A15 - 6,443 dollars
Cell D15 - ?
D15 is 1.062
Formula is A15 * $D$15
500
What is the difference between and formula and a function?
500
What is this task asking you to do?
Specify that the cell address currently in the edit line WILL change if copied to another cell.