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 5 Week 2 Glossary _ DA terms and definitions

Weekly challenge 2

Graded 100%

Question 1

An analyst has financial data that is formatted as Euros, but it should be formatted as Pesos. What spreadsheet tool can help them select the right format?

A. Format as Euros

B. Format as Money

C. Format as Currency

D. Format as Peso

The correct answer is C. Format as Currency

Question 2

You are creating a spreadsheet to help you with your job search. Every time you find an interesting job, you add it to the spreadsheet. Then, you want to indicate two possible options: Need to Apply or Applied. What spreadsheet tool will save you time by enabling you to create a drop-down list with Need to Apply and Applied as the possible options?

A. Find

B. Conditional formatting

C. Data validation

D. Pop-up menus

The correct answer is C. Data validation

Question 3

A data analyst at a symphony orchestra uses a spreadsheet to keep track of how many concerts require more than 80 musicians. They use a spreadsheet tool to change how cells appear when values equal 80 or more. What tool are they using?

A. Data validation

B. Conditional formatting

C. CONVERT

D. Add color

The correct answer is B. Conditional formatting

Question 4

You are analyzing data about the capitals of different countries. In your SQL database, you have one column with the names of the countries and another column with the names of the capitals. What function can you use in your query to combine the countries and capitals into a new column?

A. CONCAT

B. GROUP

C. COMBINE

D. JOIN

The correct function is A. CONCAT

Question 5

You are querying a database of ice cream flavors to determine which stores are selling the most mint chip. For your project, you only need the first 80 records. What clause should you add to the following SQL query?

SELECT flavors
FROM ice_cream_table
WHERE flavor = “mint_chip”

A. LIMIT = 80

B. LIMIT ,80

C. LIMIT_80

D. LIMIT 80

The correct answer is D. LIMIT 80

Question 6

Fill in the blank: A data analyst is working with a spreadsheet that has very long text strings. They use the LEN function to count the number of _____ in the text strings.

A. fields

B. characters

C. substrings

D. values

Explain: They use the LEN function to count the number of characters in the text strings.

Question 7

Spreadsheet cell C2 contains the text string “Deviation”. To return the substring “Dev”, what is the correct syntax?

A. =LEFT(C2, 3)

B. =RIGHT(3,C2)

C. =LEFT(3,C2)

D. =RIGHT(C2, 3)

The correct answer is A. =LEFT(C2, 3)

Question 8

Fill in the blank: When working with spreadsheets, data analysts can use the _____ function to locate specific characters in a string.

A. FROM

B. WHERE

C. IDENTIFY

D. FIND

Explain: When working with spreadsheets, data analysts can use the FIND function to locate specific characters in a string.