N-Level Computer Applications (SEAB 7018) Spreadsheets and Charts quiz: formatting, formulas, references, functions, IF, sorting, filtering, charts quiz
16questions. Pick an answer and you'll see why right away.
How is a spreadsheet organised?
To display a value as money, what is the best approach?
What does a spreadsheet formula always begin with?
Which formula correctly multiplies cell A1 by cell B1?
What happens to a relative reference such as A2 when the formula is copied down one row?
What do the dollar signs in 1 do?
A formula in C2 is =A2*1. What does it become when copied to C3?
Which function gives the mean (average) of a range of cells?
What does =COUNT(B2:B10) return?
What does the IF function do?
Which formula displays Pass if B2 is at least 50, otherwise Fail?
Why must you select the whole table before sorting?
What is the purpose of filtering data in a spreadsheet?
Which chart type is best for showing how a value changes over time?
Which chart type best shows the proportion each part contributes to a whole?
Which labels should a clear chart include so it can be understood on its own?