5 Written Questions
4 Matching Questions
 Write a formula to dtermine if at least one item is within budget
 Reference and lookup functions may not contain nested functions as arguments
 What is the Countif formula to count the number of GM cars on this list?
 Arguments
 a =OR(E3:E8)
 b A function input (when putting a number and how many decimal places)
 c False
 d =Countif(A2:A10,"GM")
5 Multiple Choice Questions
 42
 True
 False, descending
 =Sumif(A2:A10,"Ford",B2:B10)
 INDEX
5 True/False Questions

The formula =RAND() gives what result? → Gives a number between 0 and 1

What charting limits does excel have in terms of data points and series? → Max

What are the three steps involved in using the insert tab to create a chart? → Select data you wish to display
Click insert tab
Click a button in charts group or dialogue box launcher 
AND(A2>6, NOT(FALSE)) where A2 contians the value 25 → True, because 25 is greater than 6, and not false is true

What formula would you write to add a range of numbers in cells A2:X2? → Max