Class 7 Computer Science: MS Excel: Formulas & Charts

Microsoft Excel works out answers with formulas, which always begin with an equals sign, and functions like SUM, AVERAGE and MAX that act on a range such as A1:A5. Charts then turn the numbers into pictures: a pie chart shows parts of a total and a line chart shows change over time. Students fill in the blanks and match functions and chart types to their uses, out of 15 marks.