Question

Question 1
To better understand customer needs and preferences, a data team merges a dataset of customer purchase histories with a dataset of customer demographics. What should the data team do to ensure the compatibility of the two datasets?


Map the data



Spotcheck for null values



Use a visualization



Apply a data structure


1 point
2.
Question 2
Fill in the blank: When typing a LEN function, the correct _____ to follow is =LEN(range).


syntax



system



validation



algorithm


1 point
3.
Question 3
In this spreadsheet, which function will extract Clay Casey’s four-digit postcode?


A

B

C

D

1

Customer

Street

Territory

Country

2

Terry Stewart

707 Collins St, Docklands

VIC 3008

Australia

3

Che Price

177 William St, Tennant Creek

NT 0860

Australia

4

Stanley Moss

430 Little Collins St,

CXI 6798

Australia

5

Clay Casey

250 Queen St, Sydney

NSW 3000

Australia




=RIGHT(4,C5)



=LEFT(C5,4)



=RIGHT(C5,4)



=LEFT(4,C5)


1 point
4.
Question 4
Fill in the blank: When searching for the value in the first argument of the function, VLOOKUP looks in the _____ column of the specified location.


false



rightmost



true



leftmost


1 point
5.
Question 5
In the following spreadsheet, a data professional wants to create product IDs in Column C. The IDs should include the product name from Column A and its version number from Column B. Which function will create the ID Life_vest04?


A

B

C

1

Product name

Version number

ID

2

Raft

05


3

Oar

01


4

Life_vest

04


5

Tether_rope

02





=CONCATENATE(A4*B4)



=CONCATENATE(A4+B4)



=CONCATENATE(A4,B4)



=CONCATENATE(B4, A4)


1 point
6.
Question 6
A data analyst wants to know how many cells from A2 through A50 contain numbers below 100. Which of the following COUNTIF statements should they use?



=COUNTIF(A2:A50,"<100")



=COUNTIF(A2:A50, >100)



=COUNTIF(A2:A50, <=100)



=COUNTIF(A2:A50,">=100")


1 point
7.
Question 7
A data analyst uses a spreadsheet’s Split tool to place each vegetable and fruit into new, separate cells. What is the comma’s function in this scenario?


A

B

1

Vegetables

Fruits

2

Carrot, Celery

Strawberry, Grape

3

Broccoli, Cauliflower, Spinach

Coconut, Banana, Orange

4

Zucchini

Pear, Blackberry




Substring



Duplicate



Delimiter



String


1 point
8.
Question 8
A data analyst suspects that there are some nulls in their spreadsheet. In order to identify those missing values, they use a spreadsheet tool that changes how cells appear when values meet specific conditions. What tool do they use?



Field length



Cell filtering



Data merging



Conditional formatting


1 point
9.
Question 9
A data analyst is working for a hospital network that has just merged with another hospital system. Both systems have separate databases containing patient information, including demographics, diagnoses, and treatment history. The goal is to combine this patient data into a single, unified database to improve patient care coordination. What is the most important step to take before analyzing the combined patient data?

Design attractive visualizations for presenting the combined data.



Data mapping to standardize, merge, and clean the data from both databases.



Develop targeted marketing campaigns for the new customer base.



Use VLOOKUP to merge the customer email addresses.


1 point
10.
Question 10
You're a data analyst working for a social media marketing agency. Your team just received a massive dataset containing follower demographics and engagement metrics for several client accounts. You suspect the data might have some inconsistencies. What steps should you take to ensure a smooth and accurate data cleaning process? Select all that apply.



Examine the data to understand the data cleaning needs before you start.



Identify and address spelling errors before you start.



Focus on cleaning a small sample set of the data first.



Clean the data before making a backup copy.


1 point

Answer 1

1. Map the data

2. syntax

3. =RIGHT(C5,4)

4. leftmost

5. =CONCATENATE(A4,B4)

6. =COUNTIF(A2:A50,"<100")

7. Delimiter

8. Conditional formatting

9. Data mapping to standardize, merge, and clean the data from both databases.

10.
- Examine the data to understand the data cleaning needs before you start.
- Identify and address spelling errors before you start.
- Focus on cleaning a small sample set of the data first.