CPA S4 Data Lookup & Filter

Given the following spreadsheet, VLOOKUP is used to look up the population (million) of Thailand, fill in the blank to complete the formula.

=VLOOKUP(​​ (a)   ,$A$2:$D:$11,​ (b)   ,False)

• A10
• 2
• 1
• 3
• 4
• B10
• C10

Given the following spreadsheet, this formula =VLOOKUP(“Laos”,$A$2:$D$11, 4, FALSE) is used to look up what information about Laos?

• Name

• Population

• Land Size

• GDP

Which formula shows the VLOOKUP formula used to Look up the GDP(million USD) of Malaysia. (Hint: remember to lock your table)

• =VLOOKUP(“Malaysia”,$A$2:$D$11, 4, FALSE)

• =VLOOKUP(“A6”,$A$2:$D$11, 4, FALSE)

• =VLOOKUP(“A6”,A2:D11, 4, FALSE)

• =VLOOKUP(“Malaysia”,$A$2:$D$11, 4, TRUE)

Which formula shows the correct output after =VLOOKUP(“Malaysia”,$A$2:$D$11, 2, FALSE) formula is used to lookup data.

• 32.8

• 328550

• 365303

• =VLOOKUP(“Malaysia”,$A$2:$D$11, 4, TRUE)

Write down the VLOOKUP formula used to Look up the land size (km²) of Indonesia. (Hint: remember to lock your table)

(a)  

Given the following spreadsheet, this formula =VLOOKUP(“Laos”,$A$2:$D$11, 4, FALSE) is used to look up information about Laos, what will be the output (shown on the spreadsheet after enter the formula)?

(a)  

The following spreadsheet shows the products sold by a store. 

Predict the output of the following formulas:

=VLOOKUP(2000, $A$2:$C$5, 2, FALSE) ​ (a)  

=VLOOKUP(A3, $A$2:$C$5, 2, FALSE) ​ ​ (b)  

• Green Kendama
• Blue Fidget Spinner
• In Stock
• Red Fidget Spinner
• Brown Kendama
• Out of Stock

The table is filtered using a criterion on the Height (cm) column. The “Greater      Than…” option is used with the value 145. Does Irfan meet the criterion?

• Yes

• No

The table is filtered using a criterion on the Height (cm) column. The “Greater      Than…” option is used with the value 145. Write down the names of all students who meet the criterion.

​ ​ 1) ​ (a)  

2)​ (b)   ​

3) ​ (c)  

• Bala
• Peter
• Titus
• Alex
• Clara
• Siti