lesson 4 Flashcards

1
Q

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

A

DATA ANALYTICS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
1
Q

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

A

MS Excel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

VLOOKUP:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

PivotTables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Removing Inconsistencies and Duplicates:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

: Horizontal lookup to find data in rows.

A

HLOOKUP

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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.

A

Data Cleaning Techniques

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  • Excel’s built-in error-checking tools, such as Trace Error and Evaluate Formula, help identify and troubleshoot issues in formulas.
A

Error Checking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
  • 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.
A

Handling Large Datasets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Best for comparing quantities across different categories.

A

o Bar Charts:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Effective for showing trends over time.

A

o Line Charts:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Visualize the proportion of different categories.

A

o Pie Charts:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Slicers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Data Import and Export

12
Q
A
13
Q
A
13
Q
A
13
Q
A
14
Q
A
15
Q
A
16
Q
A