Excel

How many agents are there?

• 10

• 11

• 12

What is the Average Total Sales?

• $23,423.88

• $18,491.67

• $34,138.46

What is the highest commission?

• $490

• $480

• $450

What is the lowest commission?

• $293

• $289

• $276

What is the commission amount for Lim Yi Kai?

• $356

• $366

• $376

What is the Total Salary amount?

• $22,323

• $22,423

• $22,523

How much Bonus is paid to Choo Ai Meng?

• $115

• $125

• $135

How many agents have Total Salary that exceeds 10% of Average Total Sales? (conditional formatting in instruction 19)

• 4

• 5

• 6

What is the name of the first agent after sorting according to instruction 22?

• Ong Soo Mei

• Ang Bao Li

• Ang Li Li

How many agents have commission greater than $360? (autofilter under instruction 25)

• 5

• 6

• 7