F G K 1 A BTCD E H I J Mrs. G's Class Pass mark 6 2 3 Student Test 1 Pass/Fail Test 2 Pass/Fail Progress 4 Sophie 4 Fail 9 Pass 5 Sergei 6 Pass 10 Pass 6 Anusha 8 Pass 6 Pass Laura 2 Fail 5 Fail 8 Ming 9 Pass 6 Pass 9 Karan 7 Pass 7 Pass 10 11 12 13 3. In F3 enter the word Progress as shown above. (You may have to replace text if you already typed there) 14 4. Enter an IF statement that returns the word "Better" if the Test 2 mark is better than the Test 1 mark; 15 "Same" if the marks are the same; or "Worse" if the Test 2 mark is not better than the Test 1 mark. 16 5. Sort the spreadsheet in ascending order by student's name. 17 6. Format the spreadsheet attractively. 18 7. Follow your teacher's instructions for printing or dropping off. Spreadsheet Tutorial #4 COUNT IFULA Before You Start, Click Here To Read Me! If you finish easily, Click Here To Read Me! 1 Use an IF formula in Column E to work out the vampire rating. If they drink 10 pints of blood or more per we they are rated as MONSTER. If they drink less than 10 they are rated as VEGGY 2 In 15, 16, 17 and 18, use COUNTIF to work out the number of vamps who prefer each of the blood types 3 In 19, use COUNTIF to work out the number of vamps who have been rated as MONSTER In 110, use COUNTIF to work out the number of vamps who have been rated as VEGGY 4 5 In 112, use COUNTA to count the number of vamps who owned up to a favourite blood type 6 In 113, use COUNT to count the number of vamps who owned up to the amount they drank per week 7 In Column F, work out the fang ranking for each vampire, based on the amount of blood they drink per week 8 Check your work - then SAVE it. 9 Set the PRINT AREA so that you select the cells containing data 10 Check Print Preview to make sure your sheet fits onto 1 page. If it doesn't, use Page Setup and Scaling to adjust the printed size of the sheet. 11 Print your work COUNT IFULA Favourite Blood Type Pints per week Vamp Rating Fang Ranking A B 20 15 10 12 AB A O 21 Vamp Orlok Vlad Barnabas Collins Edward Cullen Louis Spike Angel Lestadt Armand Drusilla Duckula Mina Lucy Blade 9 9 18 AB B 1 Totals A B AB o Monsters: Vegetarians: Blood Type: Pints per week