The Year 9 test will cover spreadsheets and web design. For spreadsheets, students should understand simple formulas and data filters. They will need to open a CSV file, save it as an Excel file, and add filters to only show color phones with talk time over 240 minutes. For web design, students will create a two-page website with a stylesheet to demonstrate how to use data filters. The stylesheet should style h1 tags as red and size 20, and use the body tag to set a light yellow background color. Students will be asked questions about creating data filters, saving filtered CSV files, the purpose of CSS rules, and which tags to use for fonts and backgrounds.