D 467 / D467 Objective Assessment
(Latest Update )
Exploring Data | Review Questions
with Verified Answers | Grade A |
100% Correct - WGU
Question:
To create a clean and consistent visual appearance for a spreadsheet, which
tool ensures all font types, sizes, and colors are uniform?
Answer:
Clear formats
Question:
What is the process of combining two or more datasets into a single dataset?
Answer:
Data merging
,Question:
Fill in the blank: In data analytics, _____ describes how well two or more
datasets are able to work together.
Answer:
compatibility
Question:
What is the relationship between a text string and a substring?
Answer:
A text string is a group of characters within a cell. A substring is a smaller
subset of that text string.
Question:
A data analyst uses the COUNTIF function to count the number of times a
value less than 50 occurs between spreadsheet cells D2 through F100. What is
the correct syntax?
Answer:
=COUNTIF(D2:F100,"<50")
,Question:
Fill in the blank: To remove leading, trailing, and repeated spaces in data,
analysts use the ____ function.
Answer:
trim
Question:
Which spreadsheet tool searches for matches to a specified value in one
column, returning a corresponding piece of information from another
location?
Answer:
vlookup
Question:
Fill in the blank: When typing a LEN function, the correct _____ to follow is
=LEN(range).
Answer:
syntax
, Question:
Fill in the blank: In a VLOOKUP function, the value of the third argument
tells VLOOKUP to return the value in the _____ row from the specified
column.
Answer:
same
Question:
A data analyst wants to make sure their dataset contains only numbers below
500 from cell G2 through cell G100. Which of the following COUNTIF
statements could they use? Select all that apply.
Answer:
=COUNTIF(G2:G100,"<500")
Question:
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?
Answer:
Conditional formatting
(Latest Update )
Exploring Data | Review Questions
with Verified Answers | Grade A |
100% Correct - WGU
Question:
To create a clean and consistent visual appearance for a spreadsheet, which
tool ensures all font types, sizes, and colors are uniform?
Answer:
Clear formats
Question:
What is the process of combining two or more datasets into a single dataset?
Answer:
Data merging
,Question:
Fill in the blank: In data analytics, _____ describes how well two or more
datasets are able to work together.
Answer:
compatibility
Question:
What is the relationship between a text string and a substring?
Answer:
A text string is a group of characters within a cell. A substring is a smaller
subset of that text string.
Question:
A data analyst uses the COUNTIF function to count the number of times a
value less than 50 occurs between spreadsheet cells D2 through F100. What is
the correct syntax?
Answer:
=COUNTIF(D2:F100,"<50")
,Question:
Fill in the blank: To remove leading, trailing, and repeated spaces in data,
analysts use the ____ function.
Answer:
trim
Question:
Which spreadsheet tool searches for matches to a specified value in one
column, returning a corresponding piece of information from another
location?
Answer:
vlookup
Question:
Fill in the blank: When typing a LEN function, the correct _____ to follow is
=LEN(range).
Answer:
syntax
, Question:
Fill in the blank: In a VLOOKUP function, the value of the third argument
tells VLOOKUP to return the value in the _____ row from the specified
column.
Answer:
same
Question:
A data analyst wants to make sure their dataset contains only numbers below
500 from cell G2 through cell G100. Which of the following COUNTIF
statements could they use? Select all that apply.
Answer:
=COUNTIF(G2:G100,"<500")
Question:
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?
Answer:
Conditional formatting
