... second sheet I set up was the multipliers sheet, which would hold all the factors and their multiplying figure. I entered the separate multipliers onto the sheet, age, sex, area, no-claims bonus and the type of insurance. I entered numbers in column A, which will be needed later to lookup the multipliers. In column B I entered the different multipliers and in column C, I entered the multiplier figure. Setting up the input controls on quotes worksheet. This is the major worksheet of the system, and takes information from the groups and multipliers sheets and works out the quotation. I entered the labels for the customer's title, forename, surname, address, postcode and telephone, In C2 to C8. I also entered the labels for the customers' sex, age, car, area and type, in C11 to C20. I placed an option box over D10 and D11 and linked it to cell E11. Setting up the VLOOKUP functions on the ...

See this essay or coursework document in full right now