Glossary: Terms and definitions

We’ve covered a lot of terms—some of which you may have already known, and some of which are new. To make it easy to remember what a word means, we created this glossary of terms and definitions.

To use the glossary for this course item, click the link below and select “Use Template.”

Link to glossary: Week 3 Glossary

OR

If you don’t have a Google account, you can download the glossary directly from the attachment below.

Course 5 Week 3 Glossary _ DA terms and definitions

Weekly challenge 3

1st grade

Question 1

In data analytics, what is the process of gathering data from multiple sources and combining it into a single, summarized collection?

A. Data aggregation

B. Data grouping

C. Data composition

D. Data mapping

The correct answer is A. Data aggregation

Question 2

VLOOKUP can have problems when used on data values that have leading and trailing spaces. What function can be used to eliminate these spaces?

A. TRIM

B. CUT

C. VALUE

D. NOSPACE

The correct answer is A. TRIM

Question 3

You are using the VLOOKUP function in a specific column in your spreadsheet. You know that one of VLOOKUP’s limitations is that it can only search in columns to the right of the column into which it is entered. What can you do if you also want the function to search the data found to the left?

A. Use VLOOKUP in the leftmost column

B. Use VLOOKUP in the rightmost column

C. Make the data into an absolute reference

D. Copy that data into new columns to the right

The correct answer is D. Copy that data into new columns to the right

Question 4

A data analyst wraps the data array for their function in dollar signs ($). What does this do? Select all that apply.

• It makes it so that rows cannot be changed
• It makes it so that column cannot be changed
• It converts the data to currency
• It creates an absolute reference

Question 5

The following is a selection from a spreadsheet:

N/A	A	B	C
1	Country	Population in 2020 (millions)	Growth in population 2000-2020
2	China	1,439,323,776	13.4 %
3	India	1,380,004,385	37.1 %
4	United States	331,002,651	17.3 %
5	Indonesia	273,523,615	27.7%
6	Pakistan	220,892,340	44.9%
7	Brazil	212,559,417	21.9%
8	Nigeria	206,139,589	66.3%
9	Bangladesh	164,689,383	27.9%
10	Russia	145,934,462	-0.8%

To search for the population of Pakistan, what is the correct VLOOKUP syntax?

A. =VLOOKUP("Pakistan", A2:B10, 2, false)

B. =VLOOKUP("Pakistan", A2:B10, 3, false)

C. =VLOOKUP(Pakistan, A2:B10, 3, false)

D. =VLOOKUP(Pakistan, A2*B10, 2, false)

The correct answer is A. =VLOOKUP("Pakistan", A2:B10, 2, false)

Question 6

A data analyst writes a query in SQL with the RIGHT JOIN function

FROM fiction_table
RIGHT JOIN
books_table

What does this function do?

A. It returns all the records in the fiction table and only the records from the books table with matching values.

B. It returns all records in the books table and only the records from the fiction table with matching values.

C. It returns only the records with values that match from both tables.

D. It returns all records in both the fiction table and the books table.

The answer is B. It returns all records in the books table and only the records from the fiction table with matching values.

Question 7

The COUNT DISTINCT function includes repeating values when returning values in a specified range. True or False?

A. True

B. False

It is false statement

Question 8

When working with subqueries, which part of the query segment executes first?

A. The smaller query

B. The outer query

**C. The inner query **

D. The larger query

The correct answer is C. The inner query

2nd grade

Question 1

In data analytics, what is data aggregation?

A. The process of modifying data in order to make it suitable for analysis.

B. The process of gathering data from multiple sources and combining it into a single, summarized collection.

C. The process of ensuring a company’s data is properly stored, managed, and maintained.

D. The process of moving certain data points to a higher rank or position.

The correct answer is B. The process of gathering data from multiple sources and combining it into a single, summarized collection.

Question 2

A data analyst is performing numerical calculations on the data in their spreadsheet. Ahead of these calculations, they use the VALUE function. Why might they do this?

A. To find the average of all the numbers in the spreadsheet

B. To get a list of all the distinct numbers in the data

C. To convert the numbers in the data from text to numerical values

D. To sum up all the numbers in the spreadsheet

The correct answer is C. To convert the numbers in the data from text to numerical values

Question 3

One of the limitations of the VLOOKUP function is that it can only search columns to the right of the column into which it is entered. What is another limitation of VLOOKUP?

A. It can only be used on numerical data.

B. It will only return the last match it finds.

C. It will only return the first match it finds.

D. It can only be used with text data.

The correct answer is C. It will only return the first match it finds.

Question 4

A data analyst uses an absolute reference to lock a function array so rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference?

A. Hashtag (#)

B. Asterisk (*)

C. Ampersand (&)

D. Dollar sign ($)

The correct answer is D. Dollar sign ($)

Question 5

The following is a selection from a spreadsheet:

N/A	A	B	C
1	Country	Population in 2020 (millions)	Growth in population 2000-2020
2	China	1,439,323,776	13.4 %
3	India	1,380,004,385	37.1 %
4	United States	331,002,651	17.3 %
5	Indonesia	273,523,615	27.7%
6	Pakistan	220,892,340	44.9%
7	Brazil	212,559,417	21.9%
8	Nigeria	206,139,589	66.3%
9	Bangladesh	164,689,383	27.9%
10	Russia	145,934,462	-0.8%

To search for the growth in population in China, what is the correct VLOOKUP syntax?

A. =VLOOKUP(“China”, A2:C10, 2, false)

B. =VLOOKUP(China, A2:C10, 2, false)

C. =VLOOKUP(“China”, A2:C10, 3, false)

D. =VLOOKUP(China, A2*C10, 3, false)

The correct syntax is C. =VLOOKUP(“China”, A2:C10, 3, false)

Question 6

A data analyst writes a query in SQL with the RIGHT JOIN function

FROM fiction_table
RIGHT JOIN
books_table

What does this function do?

A. It returns all the records in the fiction table and only the records from the books table with matching values.

B. It returns all records in the books table and only the records from the fiction table with matching values.

C. It returns all records in both the fiction table and the books table.

D. It returns only the records with values that match from both tables.

The correct answer is B. It returns all records in the books table and only the records from the fiction table with matching values.

Question 7

A data analyst writes a query that asks a database to return only distinct values in a specified range, rather than including repeating values. Which function do they use?

A. RETURN

B. RETURN VALUES

C. COUNT DISTINCT

D. COUNT

They use COUNT DISTINCT funcition.

Question 8

A data analyst writes a query in SQL. Inside this query, they have a second query. What is another name for the first query? Select all that apply.

• Central select
• Subquery
• Outer select
• Outer query

This is not correct answers

3rd grade

Passed 100%

Question 1

In data analytics, what is data aggregation?

A. The process of ensuring a company’s data is properly stored, managed, and maintained.

B. The process of moving certain data points to a higher rank or position.

C. The process of gathering data from multiple sources and combining it into a single, summarized collection.

D. The process of modifying data in order to make it suitable for analysis.

The correct answer is C. The process of gathering data from multiple sources and combining it into a single, summarized collection.

Question 2

VLOOKUP can have problems when used on data values that have leading and trailing spaces. What function can be used to eliminate these spaces?

A. TRIM

B. VALUE

C. CUT

D. NOSPACE

The correct answer is A. TRIM

Question 3

A data analyst is using a VLOOKUP function in a column in their spreadsheet. They enter the function in a column to the left of the data columns. Why would they do this?

A. VLOOKUP will return all the values found to the left of its column.

B. VLOOKUP will only search values in columns to the right of the column it is entered into.

C. VLOOKUP will then search the data twice.

D. VLOOKUP will delete the values in the columns to the left of its column.

The correct answer is B. VLOOKUP will only search values in columns to the right of the column it is entered into.

Question 4

A data analyst creates an absolute reference around a function array. What is the purpose of the absolute reference?

A. To keep a function array consistent so rows and columns will automatically change if the function is copied

B. To copy a function and apply it to all rows and columns

C. To lock the function array so rows and columns don’t change if the function is copied

D. To automatically change numeric values to currency values

The correct answer is C. To lock the function array so rows and columns don’t change if the function is copied

Question 5

The following is a selection from a spreadsheet:

N/A	A	B	C
1	Country	Population in 2020 (millions)	Growth in population 2000-2020
2	China	1,439,323,776	13.4 %
3	India	1,380,004,385	37.1 %
4	United States	331,002,651	17.3 %
5	Indonesia	273,523,615	27.7%
6	Pakistan	220,892,340	44.9%
7	Brazil	212,559,417	21.9%
8	Nigeria	206,139,589	66.3%
9	Bangladesh	164,689,383	27.9%
10	Russia	145,934,462	-0.8%

To search for the population of Brazil, what is the correct VLOOKUP syntax?

A. =VLOOKUP(Brazil, A2:B10, 3, false)

B. =VLOOKUP(Brazil, A2:B10, 2, false)

C. =VLOOKUP(Brazil, A2,B10, 3, false)

D. =VLOOKUP(“Brazil”, A2:B10, 2, false)

The correct answer is D. =VLOOKUP(“Brazil”, A2:B10, 2, false)

Question 6

You write a query in SQL that includes the INNER JOIN function between two tables. What does this function do?

A. It returns all the records of one table and only the matching records from the other.

B. It returns only those records in one table whose values do not match those in the other.

C. It returns only those records with matching values in the two tables.

D. It returns all records from both tables.

The correct answer is C. It returns only those records with matching values in the two tables.

Question 7

A data analyst writes a query that asks a database to return only distinct values in a specified range, rather than including repeating values. Which function do they use?

A. COUNT

B. COUNT DISTINCT

C. RETURN

D. RETURN VALUES

They use COUNT DISTINCT funcition.

Question 8

A data analyst writes a query in SQL. Inside this query, they have a second query. What is this second query called? Select all that apply.

• Central query
• Subquery
• Smaller query
• Nested query