5 Written questions
5 Matching questions
- How do you change the chart type of an existing chart?
- What is the formula to determine the number of cars that cost less than 20,000?
- What charting limits does excel have in terms of data points and series?
- Is the following formula valid? =Not(E3:E8)
- a Excel charts require at least one numeric data series and at least one label data series
- b The specific format of a function including the function name and the order of the arguments
- c Go to the design ribbon and click change chart type
- d No, it is not valid, Not cannot do a range
- e =countif(B2:B10,"<=20000")
5 Multiple choice questions
- 11 standard charts and 73 sub types
5 True/False questions
The result_vector of a lookup function must be sorted in ascending order → False, descending
Evaluate the following =AND(FALSE,TRUE,TRUE) → False because and means they have to be true
Write a formula in cell G3 that can be copied down the column to return the following: if this item has an actual cost of less than 100, then return the text, minor component cost. If this item has an actual cost of 100 or more, then return the text, major component cost → =If(D3<100,"Minor component cost", "Major component Cost")
Write a formula to determine the average price of only Ford vehicles using the worksheet in question 11. → =And(Or(E3:E5,B7), Not(Or(E6,E8)))
Algorithm → The specific format of a function including the function name and the order of the arguments