Matching questions
1-19 of 19
Click a definition to match it with a term
Nest IF function
Give this one a try later!
IF(test 1, calculation A, IF(test 2, calculation B, calculation C))
How to bring data all the way down?
, Give this one a try later!
Ctrl Shift down key
Sorting
Give this one a try later!
-make sure to "sort by column"
-select all rows and columns
What to remember when doing Macros?
Give this one a try later!
1. enable editing on top (yellow bar at top of page)
2. save as macro enabled workbook
3. macros don't automatically adjust references
4. click onto the first box when starting
RANDBETWEEN()
Give this one a try later!
(smallest number, biggest number)
cant have percents in equation
1-19 of 19
Click a definition to match it with a term
Nest IF function
Give this one a try later!
IF(test 1, calculation A, IF(test 2, calculation B, calculation C))
How to bring data all the way down?
, Give this one a try later!
Ctrl Shift down key
Sorting
Give this one a try later!
-make sure to "sort by column"
-select all rows and columns
What to remember when doing Macros?
Give this one a try later!
1. enable editing on top (yellow bar at top of page)
2. save as macro enabled workbook
3. macros don't automatically adjust references
4. click onto the first box when starting
RANDBETWEEN()
Give this one a try later!
(smallest number, biggest number)
cant have percents in equation
