lOpen a new spreadsheet and enter the detailsshown alongside.2Highlight the formulae in row3. Fill these downto row5. Your spreadsheet should look like this:Notice that in each row, the ratio of yellow paintto blue paint is still3:5.3Now fill down the formulae until yourspreadsheet shows45L of yellow paint. Howmany litres of blue paint are required?4The painter also needs to obtain a particular shade of purple by mixing red paintwith blue paint in the ratio4:7.In A1 type ‘Red’.In A2 enter 4 and in B2 enter 7. In A3 enter=A2+4 and in B3 enter=B2+7.Fill the formulae down to find out how many litres of red paint are required to mixwith42L of blue paint.5White paint and black paint are to be mixed in the ratio2:9to make a shade ofgrey paint. How much of each type of paint is required to make55L of grey paint?m
