5 Written questions
5 Matching questions
 The formula MATCH(40,{10,40,50,90},0) returns the value 2
 What is the mode of the data set: 2,5,4,3,1,2,7
 =NOT(OR(FALSE,FALSE,False)
 When using the increase decimal button on the toolbar, the preise value in the cell is modified. True or false?
 What charting limits does excel have in terms of data points and series?
 a =mode(2,5,4,3,1,2,7)
 b True because all are false so its going to come back false, but it says not, so it is the opposite
 c Excel charts require at least one numeric data series and at least one label data series
 d False
 e True
5 Multiple choice questions
 =OR(E3:E8)
 =Large(B2:B10,3)
 True
 =average(2,5,4,3,1,2,7)
 Gives a number between 0 and 1
5 True/False questions

How do sparklines differ from charts? → Small wordsized charts or graphics are embedded within the words, numbers, and images they represent in a worksheet, making multiple comparisons of trends and patters much easier.

Write a formula to dtermine if none of items are within budget → =Not(E3:E8)

What is the formula to determine the number of cars that cost less than 20,000? → =countif(B2:B10,"<=20000")

What are the three steps involved in using the insert tab to create a chart? → =Sumif(A2:A10,"Ford",B2:B10)

What formula would you use if you wanted to set a conditional format of cell a3 using the formula is methodsuch that the item name would be shade in yellow if this item has an actual cost of at least 400 → You have to ttell it to shade yellow, so it should be conditional format using the Formula is method to create one. Use =$D3>=400, indicate to shade yellow, applying to $A$3:$A$8.