Pre-test: Data Wrangling – Big Data for Business (888102)

Q1.

Which Excel feature would you use to show only rows where continent is ‘Asia’?

Filter Sort PivotTable Data Validation

Q2.

Which Excel function can help list all unique country names?

UNIQUE() FILTER() SORT() COUNTIF()

Q3.

To sort countries by population from highest to lowest, which should you choose?

Sort Z to A Sort A to Z Conditional Formatting Remove Duplicates

Q4.

To create a new column for total GDP, what formula would you use?

=C2*D2 =pop/gdpPercap =IF(C2>D2) =SUM(C2:D2)

Q5.

How can you filter data to show only the year 2007?

Use Filter on Year column Use Conditional Formatting Use Data Validation Use Sort by Year

Q6.

Which tool creates a dropdown list for continent values?

Data Validation Filter Sort Flash Fill

Q7.

Which function counts how many rows have ‘Africa’ in the continent column?

COUNTIF() SUM() IF() MATCH()

Q8.

Which feature would color rows where life expectancy is below 50?

Conditional Formatting Sort Filter Flash Fill

Q9.

What Excel tool would sort country names alphabetically?

Sort A to Z Filter Data Validation Text to Columns

Q10.

How can you extract a list of distinct country names?

Q1.

If the dataset contains 1704 rows, what does =COUNTIF(C2:C1705,2007) return if column C is year?

142 1704 284 456

Q2.

What does =MAX(E2:E1705) return if column D is ‘lifeExp’?

82.6 99.9 80.1 75.2

Q3.

What is the result of =MIN(E2:E1705) if column E is ‘pop’?

60011 50203 10023 120000

Q4.

If column F is ‘gdpPercap’, what does =AVERAGE(F2:F1705) return?

7215.3 12003.8 1050.7 24587.2

Q5.

What does =COUNTA(UNIQUE(C2:C1705)) return if column C is ‘year’?

12 3 7 5

Q6.

What would be the result of =MAX(E2:E1705) if column E is population?

1318683096 99876543 1000000000 849000000

Q7.

What is the output of =SUMIF(B2:B1705, "Asia", E2:E1705) if B is continent and E is population?

30507333901 2398798051 1534856540 2547890000

Q8.

What value does =MIN(D2:D1705) return if D is life expectancy?

23.6 40.2 51.3 33.0

Q9.

What is the number of unique countries in the dataset using =COUNTA(UNIQUE(A2:A1705)) if A is country?

142 89 187 120

Q10.

If E is pop and F is gdpPercap, what does =SUMPRODUCT(E2:E1705,F2:F1705) return?

1.013024e+13 9.87E+12 3.18E+14 2.75E+11

Q11.

What does =AVERAGEIF(B2:B1705, "Europe", D2:D1705) return if B is continent and D is lifeExp?

71.9 77.6 73.2 69.5

Q12.

What is the result of =MAXIFS(D2:D1705, B2:B1705, "Africa") if D is lifeExp and B is continent?

76.4 71.2 65.1 59.8

Q13.

Using =SORT(UNIQUE(B2:B1705)), what is the last value if B is continent?

Oceania Europe Asia Americas

Q14.

What would =SUM(D2:D1705) give if D is lifeExp?

109812.8 101344.4 95630.0 138472.5

Q15.

If column C is year, what does =MAX(C2:C1705)-MIN(C2:C1705) return?

52 53 54 55

Q16.

After applying a filter for continent=‘Asia’ and sorting by lifeExp descending, what would the top country likely be?

Japan Thailand India China

Q17.

If you filter year = 2007 and sort by GDP (pop * gdpPercap), which country is likely ranked 3th?

United States China Japan India

Q18.

After filtering for continent = 'Africa' and year = 1957, and sorting by lifeExp ascending, which country is likely listed first?

Sierra Leone Nigeria Sudan Uganda

Q19.

How many countries are in the Gapminder dataset?

Q20.

If you apply filter for year = 1952 and sort by population in descending order, which country is likely ranked 4th?