CLERICAL Interpreting Data 1 — Questions and Answers
Question 1: Based on the table of quarterly travel expenses below, which department had the lowest expenses in Q3? | Department | Q1 | Q2 | Q3 | Q4 | |---|---|---|---|---| | Sales | $5,200 | $6,100 | $5,500 | $5,800 | | Marketing | $3,000 | $3,500 | $2,800 | $4,000 | | Admin | $1,500 | $1,200 | $1,800 | $1,400 | | Tech | $4,500 | $4,800 | $4,200 | $4,900 |
- Sales
- Marketing
- Admin (Correct answer)
- Tech
Correct answer: Admin
To answer the question, look at the 'Q3' column and find the smallest number. The expenses are Sales ($5,500), Marketing ($2,800), Admin ($1,800), and Tech ($4,200). The lowest value is $1,800, which corresponds to the Admin department.
Question 2: Using the same table of quarterly travel expenses, what was the total annual travel expense for the Sales department?
- $20,600
- $21,900
- $22,600 (Correct answer)
- $23,400
Correct answer: $22,600
To find the total annual expense for the Sales department, add up all the values in the 'Sales' row: $5,200 (Q1) + $6,100 (Q2) + $5,500 (Q3) + $5,800 (Q4) = $22,600.
Question 3: Using the same table, what is the difference between the highest and lowest quarterly expense for the Tech department?
- $400
- $500
- $600
- $700 (Correct answer)
Correct answer: $700
First, identify the expenses for the Tech department: $4,500, $4,800, $4,200, and $4,900. The highest is $4,900 (Q4) and the lowest is $4,200 (Q3). The difference is $4,900 - $4,200 = $700.
Question 4: A pie chart shows the reasons for customer service calls: Billing Inquiry (40%), Technical Support (35%), Account Changes (15%), and Other (10%). If there were 800 calls in total, how many were for Technical Support?
- 120
- 280 (Correct answer)
- 320
- 350
Correct answer: 280
To find the number of calls for Technical Support, multiply the total number of calls by the percentage for that category: 800 calls * 35% (or 0.35) = 280 calls.
Question 5: Using the same pie chart data (Billing 40%, Tech 35%, Account 15%, Other 10%), how many more calls were for Billing Inquiry than for Account Changes if the total was 800 calls?
- 150
- 200 (Correct answer)
- 250
- 320
Correct answer: 200
First, find the number of calls for each category: Billing = 800 * 0.40 = 320. Account Changes = 800 * 0.15 = 120. Then, find the difference: 320 - 120 = 200. Alternatively, find the difference in percentage (40% - 15% = 25%) and then calculate: 800 * 0.25 = 200.
Question 6: A bar chart shows the number of new hires per quarter: Q1: 25, Q2: 30, Q3: 20, Q4: 35. What was the total number of new hires for the year?
- 90
- 100
- 110 (Correct answer)
- 120
Correct answer: 110
To find the total for the year, simply add the number of hires from each quarter: 25 + 30 + 20 + 35 = 110.
Question 7: Using the same new hire data (Q1: 25, Q2: 30, Q3: 20, Q4: 35), what was the percentage increase in new hires from Q3 to Q4?
- 15%
- 42.8%
- 50%
- 75% (Correct answer)
Correct answer: 75%
The formula for percentage increase is ((New Value - Old Value) / Old Value) * 100. The increase in hires is 35 (Q4) - 20 (Q3) = 15. Divide this increase by the original number (Q3): 15 / 20 = 0.75. Convert to a percentage: 0.75 * 100 = 75%.
CLERICAL Interpreting Data 1
Based on the table of quarterly travel expenses below, which department had the lowest expenses in Q3?
| Department | Q1 | Q2 | Q3 | Q4 |
|---|---|---|---|---|
| Sales | $5,200 | $6,100 | $5,500 | $5,800 |
| Marketing | $3,000 | $3,500 | $2,800 | $4,000 |
| Admin | $1,500 | $1,200 | $1,800 | $1,400 |
| Tech | $4,500 | $4,800 | $4,200 | $4,900 |