Data Analysis | MCQs

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 کسی چیز سے رشتہ یا تعلق

Explanation

The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition.

The condition is referred to as criteria , which can check things like: If a number is greater than another number >

***

RY24012023

Explanation

The Query is the database object to view change and analyze data in different ways.

This object displays data from one or more tables in a unique way.

Queries are a technique of getting data from one or more tables and organizing it.