Question $1$

What is the essential first step in the data analytics process?

$1$ point

Collecting and cleaning data

Defining the problem

Creating hypotheses

Presenting to key stakeholders

$2.$

Question $2$

Which professional predicts the future using data from the past?

$1$ point

Data scientist

Data engineer

Business analyst

Software developer

$3.$

Question $3$

For a financial information analysis, what would you suggest be considered as a preliminary step to ensure data reliability?

$1$ point

Avoiding summary statistics on individual columns

Running detailed transaction analysis

Ignoring data integrity questions

Performing logic checks on high$-$level expectations

$4.$

Question $4$

What is the relevance of visuals to your presentation?

$1$ point

They draw attention away from the raw data.

They are an effective way of presenting semi$-$structured data.

They make your findings appear credible and trustworthy.

They help tell a story and make data relatable.

$5.$

Question $5$

What technical skills are mentioned as essential for Data Analysts?

$1$ point

No technical skills are required

SQL and spreadsheet skills only

Fluency in Python and R only

Programming skills including Python, R$,$ and SQL

$6.$

Question $6$

What does CSV stand for?

$1$ point

Comma$-$separated values used for storing tabular data in plain text

Conditional Sorting and Validation, utilized for organizing Excel data

Compact Spreadsheet Viewer used for advanced data analysis

Centralized Style Variation, employed for formatting Excel sheets

$7.$

Question $7$

Which of the following formulas contains only relative references?

$1$ point

$=$SUM $($A$$1$: A$$10)$

$=$SUM $($$A$$1$: $A$$10)$

$=$SUM $($A$1$:A$10)$

$=$SUM $($$A$1$: A$$10)$

$8.$

Question $8$

When gathering data, you find agents keep their records and do not constantly update the information in the shared company database. In this case, the data would be considered $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.$

$1$ point

unreliable

irrelevant

inaccurate

untimely

$9.$

Question $9$

Which of the following acts governs privacy rules around collecting health$-$related information?

$1$ point

HIPAA

GDPR

PCI

CCPA

$10.$

Question $10$

What should you do if you have Excel data in all upper$-$case letters and want to change it to all lowercase?

$1$ point

Use the LOWER function.

Use the Change Case button.

Use the CHANGE$\_$CASE function.

Use the PROPER function.

$11.$

Question $11$

For which situation is the $$text to columns$$ feature most appropriate?

$1$ point

Combining two columns containing $$ and $$ into a single column.

D: Removing white space from a string containing first names and surnames in a cell.

Break down a cell containing a mixture of honorifics, first names, middle initials, and surnames into multiple rows

Splitting a column containing $$ into two columns.

$12.$

Question $12$

Which character is the default delimiter in a $.$csv file?

$1$ point

period

tab

comma

semi$-$colon

$13.$

Question $13$

Which statement best describes the purpose of filtering your data?

$1$ point

It helps you to remove duplicates in your data.

It enables you to find inconsistencies in your data.

It helps you to order your data.

It enables you to gain more control over which parts of your data are displayed.

$14.$

Question $14$

Which of the following statements best describes the output of the function

$=$SUMIF $($B$1$:B$7,"=10,$ A$1$:A$7)?$

$1$ point

It sums the values in the range A$1$:A$7$ if the corresponding values in range B$1$:B$7$ equal $10.$

It sums the values in the range B$1$:B$7$ if the corresponding values in the range A$1$:A$7$ equal $10.$

It returns an error.

It sums all values in the range B$1$:B$7$ and A$1$:A$7$ if those values equal $10.$

$15.$

Question $15$

What is the lookup value in this formula?

$=$VLOOKUP$($B$3,$A$2$:B$12,2,$FALSE$)$

$1$ point

$2$

B$3$

B$12$

A$2$

$16.$

Question $16$

Which of the following is true about an area chart?

$1$ point

It contains a filled area under a series of data points.

It cannot be produced using a PivotChart.

It is round, similar to a pie chart.

It cannot contain negative values.

$17.$

Question $17$

Which of the following is true of scatter charts?

$1$ point

They plot one set of data onto an xy axis.

They combine two sets of values on the x and y axes into single data points and then display them in clusters in the chart.

They are seldom used for statistical scientific data.

They are seldom customized, so they are very consistent.

$18.$

Question $18$

Which of the following is true about filled map charts?

$1$ point

They show a line of values with a shaded area beneath.