Print test
5 Written questions
5 Matching questions
 When using the increase decimal button on the toolbar, the preise value in the cell is modified. True or false?
 Give an example of a low data ink ratio in a chart.
 The formula MATCH(40,{10,40,50,90},0) returns the value 2
 #######
 If you enter 1,149+25, what value would result?
 a Box has insufficient width
 b False
 c It would just show 1149+25
 d 9 colors with only 4 cells with data.
 e True
5 Multiple choice questions
 =If(D3<C3, "True","False")
 False
 42
 =average(2,5,4,3,1,2,7)
 Excel charts require at least one numeric data series and at least one label data series
5 True/False questions

Write a formula to determine the average price of only Ford vehicles using the worksheet in question 11. → =Averageif(A2:A10,"Ford",B2:B10)

The rows and column arguments in the INDEX functions can be numeric values, Boolean values, or text → True

=NOT(OR(FALSE,FALSE,False) → True because one of the two separated by the comma has to be true

What is the difference between a bar chart and a column chart? → XY scatter chart requires 2 values to compare (highlight tab)

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