NEW
Font size
S
M
L
XL
WorksheetsExcel
Total questions: 10
Worksheet time: 30mins
Name
Class
Date
1.
How many agents are there?
a)
10
b)
11
c)
12
2.
What is the Average Total Sales?
a)
$23,423.88
b)
$18,491.67
c)
$34,138.46
3.
What is the highest commission?
a)
$490
b)
$480
c)
$450
4.
What is the lowest commission?
a)
$293
b)
$289
c)
$276
5.
What is the commission amount for Lim Yi Kai?
a)
$356
b)
$366
c)
$376
6.
What is the Total Salary amount?
a)
$22,323
b)
$22,423
c)
$22,523
7.
How much Bonus is paid to Choo Ai Meng?
a)
$115
b)
$125
c)
$135
8.
How many agents have Total Salary that exceeds 10% of Average Total Sales? (conditional formatting in instruction 19)
a)
4
b)
5
c)
6
9.
What is the name of the first agent after sorting according to instruction 22?
a)
Ong Soo Mei
b)
Ang Bao Li
c)
Ang Li Li
10.
How many agents have commission greater than $360? (autofilter under instruction 25)
a)
5
b)
6
c)
7
Reset
