Task 5

A major car manufacturer has collated data on three of its main competitors – BMW, Cadillac and KIA. An extract of the data is provided in the “MBF Summative data.xlsx” file under the “Task 5 – Data” tab. Using this data, complete the following tasks:

ai) Use the "COUNTIF" function to count the number of cars manufactured by Cadillac

ii) Use the "COUNTIFS" function to determine the number of Kia cars that are sold only in Russia.

bi) Using the VLOOKUP function, determine what the body type is for the 8-Series model manufactured by BMW

ii) Using the VLOOKUP function, determine what the production years were for the STS model manufactured by Cadillac

c) Apply a filter to the data set and select filters to show only Large MPV's produced by Kia and display it separately.

di) Copy all the main headings and the details for the first five Kia cars on the list. Transpose this data.

Using this data, conduct the following search:

ii) Run a "HLOOKUP" search to determine the body type for the Kia Pride model

Final-MBF-Summative-data-for-students