lesson 4

Question 1

involves examining datasets to draw conclusions about the information they contain, using specialized systems and software. It is a crucial process in business decision-making, helping to identify patterns, correlations, and trends

Answer 1

DATA ANALYTICS

Question 1

is a powerful tool for data manipulation, analysis, and visualization. It is widely accessible and
contains built-in tools that make it ideal for both beginners and advanced users to perform analytics

Answer 1

MS Excel

Question 2

Searches for a value in the leftmost column and returns a value in the same
row from a specified column.

Answer 2

VLOOKUP:

Question 2

summarize large datasets, allowing users to reorganize and extract meaningful information without altering the original dataset.

Answer 2

PivotTables

Question 3

o Identify and remove duplicates using Data > Remove Duplicates.
o Use Conditional Formatting to highlight duplicate or inconsistent data.

Answer 3

Removing Inconsistencies and Duplicates:

Question 3

: Horizontal lookup to find data in rows.

Answer 3

HLOOKUP

Question 4

Cleaning data ensures accurate analysis.

Remove duplicates using Data > Remove Duplicates.

Use text functions like LEFT(), RIGHT(), and TRIM() to clean textual data.

Convert data types and deal with errors such as missing values.

Answer 4

Data Cleaning Techniques

Question 5

• Excel’s built-in error-checking tools, such as Trace Error and Evaluate Formula, help identify and troubleshoot issues in formulas.

Answer 5

Error Checking

Question 6

• Filtering Data: Use Data > Filter to sort or filter rows based on specific criteria. Filtering helps
  work efficiently with large datasets.
• Sorting Data: Sort data alphabetically, numerically, or based on custom lists.

Answer 6

Handling Large Datasets

Question 7

Best for comparing quantities across different categories.

Answer 7

o Bar Charts:

Question 8

Effective for showing trends over time.

Answer 8

o Line Charts:

Question 9

Visualize the proportion of different categories.

Answer 9

o Pie Charts:

Question 10

Use =—– to add interactive buttons to filter data dynamically in PivotTables and PivotCharts.

Answer 10

Slicers

Question 11

Import large datasets from external sources, such as CSV files or databases using Data > Get External Data.

Export cleaned or analyzed data to formats like CSV for use in other applications

Answer 11

Data Import and Export