Tables and Spreadsheets

This is a practice bank for UCAT Quantitative Reasoning questions involving data presented in tables and spreadsheets. Work through the 20 questions under timed conditions (~40 seconds each) before reviewing your answers.

---

Quick-Reference: Reading Tables

Tables are the most common data format in QR. You will typically see rows representing categories (e.g. years, departments, products) and columns representing variables (e.g. sales, costs, percentages).

Step-by-Step Approach

1. Read the column headers first — understand what each column measures and its units
2. Identify the row you need — scan the leftmost column for the category in question
3. Extract the correct cell — follow the row across to the correct column
4. Check units — the question may ask for a different unit to the one in the table
5. Perform any calculation — percentages, differences, ratios, or totals

Common Table Calculations

Calculation	Formula
Percentage of total	(Part / Total) x 100
Percentage change	((New - Old) / Old) x 100
Mean (average)	Sum of values / Number of values
Difference	Value A - Value B
Ratio	Value A : Value B (simplify by dividing both by GCD)

---

Strategy

• Spend no more than 40 seconds per question
• Identify exactly which cells you need before calculating
• Use estimation to eliminate obviously wrong options
• Flag and move on if a question requires more than two calculation steps

---

Practice

Complete the 20 assessment questions for this lesson. Each presents data in a table and asks you to extract or calculate a value.