MS Excel Brm

Please read the following carefully and then answer the below 8 questions.
Please read the following carefully and then answer the below 8 questions.

Every part fitted to a vehicle needs to have a part number to enable correct part ordering (amongst many other important reasons).
Table 1 below contains data relating to 10 part numbers. These part numbers are allocated to different variants of car seat.

The sheet called "Definitions & Functions" contains:
- definitions that you will need to know in order to answer the below questions.
- 7 basic Excel Functions. Several of these Functions (possibly combined) will be needed to answer questions 1-5.

Important Notes:
- Questions 1-5 will require formulas as answers. These formulas should be created in the first row and dragged down to all rows. ie.must be the same generic formula in each row
- Questions 6-8 will require text answers only. No formulas or functions required.
- To be fair to people with varying Excel backgrounds, you're only allowed to use the functions listed in the 'Definitions & Functions' sheet