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 2 Glossary

OR

If you don’t have a Google account, you can download the glossary directly from the attachment below: Course 4 Week 2 Glossary _ DA terms and definitions

Weekly challenge 2

1st grade

Question 1

Conditional formatting is a spreadsheet tool that changes how cells appear when values meet a specific condition. Data analysts can use conditional formatting to do which of the following tasks? Select all that apply.

• To calculate mathematical equations
• To make cells stand out for more efficient analysis
• To identify blank cells or missing information
• To sort data in series of cells into a meaningful order

Question 2

A data analyst at a nonprofit organization is working with the following spreadsheet, which contains member name data in column C. They want to divide this data using the underscore as a delimiter, so that first names are stored in one column and last names in another. Which tool should the analyst use?

N/A	A	B	C
1	Member Number	Date joined	LastFirst
2	100582	9/29/16	Yolanda_Dennis
3	195785	4/7/20	Josefina_Elliott
4	137621	10/28/17	Vernon_Moreno
5	145202	1/12/18	Cedric_Higgins

A. SPLIT function

B. Pivot table

C. Conditional formatting

D. MID function

The correct answer is A. SPLIT function

Question 3

A data analyst is using a function in a spreadsheet. When they input the function, they follow a predetermined structure that includes all required information for the function and its proper placement. What aspect of a function does this describe?

A. The specified value of the function

B. The length of the function

C. The syntax of the function

D. The number of characters in the function

The correct answer is C. The syntax of the function

Question 4

You are working with the following selection of a spreadsheet:

N/A	A	B
1	Customer	Address
2	Sally Stewart	9912 School St. North Wales, PA 19454
3	Lorenzo Price	88621 Glendale Dr. Burlington, MA 01803
4	Stella Moss	372 W. Addison Street Brandon, FL 33510
5	Paul Casey	9069 E. Brickyard Road Chattanooga, TN 37421

In order to extract the five-digit postal code from Burlington, MA, what is the correct function?

A. =RIGHT(5,B3)

B. =LEFT(5,B3)

C. =LEFT(B3,5)

D. =RIGHT(B3,5)

The correct syntax is D. =RIGHT(B3,5)

Question 5

A data analyst in a human resources department is working with the following selection of a spreadsheet:

N/A	A	B	C	D
1	Year Hired	Last 4 of SS#	Department	Employee ID
2	2019	1192	Marketing
3	2014	2683	Operations
4	2020	1939	Strategy
5	2009	3208	Graphics

They want to create employee identification numbers (IDs) in column D. The IDs should include the year hired plus the last four digits of the employee’s Social Security Number (SS#). What function will create the ID 20201939 for the employee in row 4?

A. =CONCATENATE(A4*B4)

B. =CONCATENATE(A4+B4)

C. =CONCATENATE(A4,B4)

D. =CONCATENATE(A4!B4)

The correct answer is C. =CONCATENATE(A4,B4)

Question 6

An analyst is cleaning a new dataset containing 500 rows. They want to make sure the data contained from cell B2 through cell B300 does not contain a number greater than 50. Choose the statement that includes the correct syntax for this COUNTIF function?

A. =COUNTIF(B2:B300,">50")

B. =COUNTIF(B2:B300,”<50”)

C. =COUNTIF(B2:B300,>50)

D. =COUNTIF(B2:B300,<=50)

The correct answer is D. =COUNTIF(B2:B300,<=50)

Question 7

What does the function VLOOKUP do?

A. Deletes information in a column containing some specified value.

B. Returns information in a row containing some specified value.

C. Returns information in a column containing some specified value.

D. Transforms information in a row containing some specified value.

The correct answer is C. Returns information in a column containing some specified value.

Question 8

Fill in the blank: Data _____ is the process of matching fields from one data source to another.

A. mapping

B. extracting

C. inserting

D. transforming

Data mapping is the process of matching fields from one data source to another.

2nd grade

Question 1

Conditional formatting is a spreadsheet tool that changes how cells appear when values meet a specific condition. Data analysts can use conditional formatting to do which of the following tasks? Select all that apply.

• To identify blank cells or missing information
• To make cells stand out for more efficient analysis
• To calculate mathematical equations
• To sort data in series of cells into a meaningful order

Question 2

A data analyst is working on a spreadsheet in which one of the columns is name data. This data is formatted as lastname, firstname. The analyst chooses to divide this data into two new columns, one containing the firstname data and the other containing the lastname data. What spreadsheet tool would they use to do this?

A. The SPLIT function

B. Conditional formatting

C. The MID function

D. Substring formatting

The correct answer is A. The SPLIT function

Question 3

Fill in the blank: A predetermined structure that includes a function’s required information and its proper placement is called _____.

A. syntax

B. script

C. standard

D. structure

A predetermined structure that includes a function’s required information and its proper placement is called syntax.

Question 4

In a spreadsheet, what does the function =LEFT(D5, 6) do?

A. Returns the first six columns in row B.

B. Returns the values in the first six cells of row D.

C. Returns the values located in rows five and six of column D.

D. Returns the first six characters in the string located in cell D5.

In a spreadsheet, the function =LEFT(D5, 6) will returns the first six characters in the string located in cell D5.

Question 5

A data analyst in a human resources department is working with the following selection of a spreadsheet:

N/A	A	B	C	D
1	Year Hired	Last 4 of SS#	Department	Employee ID
2	2019	1192	Marketing
3	2014	2683	Operations
4	2020	1939	Strategy
5	2009	3208	Graphics

They want to create employee identification numbers (IDs) in column D. The IDs should include the year hired plus the last four digits of the employee’s Social Security Number (SS#). What function will create the ID 32082009 for the employee in row 5?

A. =CONCATENATE(B5,A5)

B. =CONCATENATE(A5!B5)

C. =CONCATENATE(A5+B5)

D. =CONCATENATE(B5+A5)

The correct answer is A. =CONCATENATE(B5,A5)

Question 6

An analyst is working on a project involving customers from Bogota, Colombia. They receive a spreadsheet with 5,000 rows of customer information. What function can they use to confirm that the column for City contains the word Bogota exactly 5,000 times?

A. SUM

B. COUNT

C. COUNTIF

D. SUMIF

The correct answer is C. COUNTIF

Question 7

Fill in the blank: In a spreadsheet, the function VLOOKUP is used to _____ information in a column based on a specified data value.

A. return

B. transform

C. replace

D. delete

In a spreadsheet, the function VLOOKUP is used to return information in a column based on a specified data value.

Question 8

To evaluate how well two or more data sources work together, data analysts use data mapping. True or False?

A. True

B. False

It is true statement.