IGCSE Practice Practical Spreadsheet

Write the exact absolute cell reference formula for cell F14

(Click on the photo to enlarge)

Write the exact absolute cell reference formula for cell F19

(Click on the photo to enlarge)

Write the exact formula to get the TOTAL Income in CELL H11

(Click on the photo to enlarge)

Write the exact formula to get the TOTAL Income in CELL H18

(Click on the photo to enlarge)

Write the exact VLOOKUP formula in Cell D7 according to the given data in Cell B7 with the criteria data range from Cells H7 to I17 (Click on the photo to enlarge)

Write the exact VLOOKUP formula in Cell C10 according to the given data in Cell B10 with the criteria data range from Cells H7 to I17 (Click on the photo to enlarge)

Write the exact VLOOKUP formula in Cell C15 according to the given data in Cell B15 with the criteria data range from Cells H7 to I17 (Click on the photo to enlarge)

Write the exact VLOOKUP formula in Cell M8 according to the given data in Cell L8 with the criteria data range from Cells O8 to P20 (Click on the photo to enlarge)

Write the exact VLOOKUP formula in Cell M18 according to the given data in Cell L18 with the criteria data range from Cells O8 to P20 (Click on the photo to enlarge)

Write the exact VLOOKUP formula in Cell S8 according to the given INPUTTED data in Cell S7 with the criteria data range from Cells R11 to U21 (Click on the photo to enlarge)