Show:
Wild Card
Formatting
Cell References
Inserting Rows/Columns & Sorting/Filtering
Inflation/Shark Tank
100
What does #### mean?
Too wide
100
What number format is used by default?
General
100
The default type of cell reference.
Relative
100
When inserting a column between M&N, which column would you select before you insert the column?
N
100
What happened when Scrooge’s nephews started duplicating coins?
Prices went up
200
What are the three parts of a formula?
1) = 2) Function 3) Cell References
200
What is the difference between accounting and currency?
Accounting - $ to the left Currency - $ next to the number
200
The cell reference that changes in relation to where it was copied to.
Relative
200
________________ order is when your items are sorted from largest to smallest.
Descending
200
The Bureau of Labor Statistics keeps track of this by monitoring everday goods/services that are purchased and it is used to measure inflation.
Consumer Price Index (CPI)
300
This type of orientation fits more columns.
Landscape
300
This is used to copy formulas to nearby cells.
Fill Handle
300
Name the type of cell reference used: $B$4
Absolute
300
What is the difference between sorting and filtering?
Sorting does not remove any of your items. Filtering only keeps the items you search for.
300
On Shark Tank, if an inventor asked for 20% for 100K, how much is the inventor valuing his company at?
500K
400
Which keys on the keyboard can you press to display formulas used?
Ctrl +~
400
How can you select an entire column/row?
Click on the letter/number
400
Which key on the keyboard do you use to create an absolute cell reference?
F4
400
_______________ order is when your items are sorted from the smallest to the largest.
Ascending
400
Inflation could occur if there was either a(n) ____________ in demand for goods or a(n) ____________ in supply of goods.
1) Increase in demand 2) Decrease in supply
500
Which tab on the ribbon is used to change the page breaks?
View --> Page Break Preview
500
A selection of two or more cells.
Range
500
The following forumula is in cell A4, =B1*$B$7. What will the formula change to when it is copied to B5?
=C2*$B$7
500
If you inserted a row between 8&9, which row does the formatting (colors and fonts) get copied from?
8
500
After watching Shark Tank, name 2 different reasons why inventors would ask for an investment from the sharks?
1) Advertising 2) Production of the good