CHAPTER 20 PRACTICAL
Spreadsheets Quest
Work inside a Microsoft Excel-style spreadsheet environment. Enter real formulae, replicate cell references, use Chapter 20 functions, perform lookups, filter and sort data, format worksheets and prepare printouts.
6 rotating setsExcel-style worksheetWorking formula engine30 marks eachAuto-marked
Chapter 20 skills onlyModels • formulae • absolute/relative references • functions • lookups • filters • sorting • formatting • printing
The previous five sets are remembered for this student/browser so all six are normally seen before a repeat.
SPREADSHEET
5 marksMission
AutoSave On
fx
SelectionA1
StatusReady
＋