Data Analysis | MCQs

Explanation

A PivotTable helps you calculate, summarize, and analyze data efficiently.

It lets you spot comparisons, patterns, and trends within large datasets.

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.

Explanation

A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data.

Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

Explanation

Tabulation is the presentation of figures from an investigation in a table which consists of rows and columns of cells, or spaces, each of which provides one unit of information.

Explanation

A Pivot Table in Excel is used to quickly summarize, analyze, explore, and present large sets of data.

It helps in organizing data by categories, totals, averages, and filters without altering the original dataset.

Explanation

Browser is not a term pertaining to spreadsheets.

Spreadsheets are not included in the definition of "browser."

Explanation

Sort/Report generators require more disk space than indexed/report generators .

Explanation

Data refers to raw facts and figures that have not yet been processed.

Once processed, data becomes information.

Explanation

A scatter plot is a type of graph used in Exploratory Data Analysis (EDA) to visualize the relationship between two continuous variables. It displays the data points as points on a coordinate grid, with the x-axis representing one variable and the y-axis representing the other.

The primary purpose of a scatter plot is to:

• Show the strength and direction of the relationship between the two variables
• Identify patterns, correlations, or outliers in the data
• Help identify potential relationships that may not be immediately apparent from looking at individual variables

Scatter plots are particularly useful for:

• Identifying linear or non-linear relationships
• Identifying clusters or groups in the data
• Identifying outliers or anomalies

Explanation

Relevant means قریب سے منسلک یا ہاتھ میں معاملے سے مناسب

Concerned means کسی چیز سے رشتہ یا تعلق