Unit 3

Question 1

What are the features to analyse and interpret data? (In Exel)

Answer 1

1. Sub-total
2. Total
3. Sort
4. Filter
5. Count

Question 2

What are pivot tables?

Answer 2

Pivot tables are powerful tools in data analysis and reporting that summaries, analyse and visualise data efficiently

Question 3

What are the 6 functions of pivot tables?

Answer 3

1. Data summarisation
2. Grouping and categorisation
3. Dynamic Filtering
4. Sort
5. Calculations and formulas
6. Data visualisation

Question 4

What are the uses in pivot tables in automation?

Answer 4

> Automated reporting
Data analysis
Data cleaning and transportation
Interactive dashboard
Data consolidation

Question 5

What is the definition of a lookup table?

Answer 5

They are tables used to store and retrieve data efficiently. They provide a structured way to look at data from a specific column or row based on their key value

Question 6

What are the 2 types of lookup tables

Answer 6

VLOOKUP
HLOOKUP

Question 7

What is power query?

Answer 7

It is a data connection technology that enables you to import, transform, and automate data processing

Question 8

What are the uses of power query?

Answer 8

> Import data
Edit a query
Load data imported
Combine data imported from different files