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.

Weekly challenge 3

1st time

Question 1

Fill in the blank: In spreadsheets, data analysts begin _____ with an equals sign (=).

A. cells

B. formulas

C. charts

D. numbers

In spreadsheets, data analysts begin formulas with an equals sign (=).

Question 2

What do data analysts use to label the type of data contained in each column in a spreadsheet?

A. Menus

B. Tables

C. Attributes

D. Headings

The correct answer is C. Attributes

Question 3

Which of the following tasks might be performed using spreadsheets?

A. Maintain information about accounts

B. Write a sales pitch

C. Develop communication skills

D. Land a new client

The correc answer is A. Maintain information about accounts.

Question 4

Fill in the blank: _____ are preset commands that perform calculations.

A. Functions

B. Goals

C. Formulas

D. Instructions

Functions are preset commands that perform calculations.

Question 5

In the function =MAX(B5:B15), what does B5:B15 represent?

A. Observation

B. Column

C. Attribute

D. Range

In the function =MAX(B5:B15), B5:B15 represent range.

Question 6

A data analyst enters the formula =A2*C4 into a cell. What does this formula do?

A. It sums all the values from cells A2 to C4.

B. It multiplies all the values from cells A2 to C4.

C. It swaps the values in cells A2 and C4.

D. It multiplies the values in cells A2 and C4.

The correct answer is D. It multiplies the values in cells A2 and C4.

Question 7

What are some questions you can ask to reduce potential bias? Select all that apply.

• What is the data about?
• How much data is there?
• Who collected the data?
• When was the data collected?

Question 8

Fill in the blank: A data analyst considers which organization created, collected, or funded a dataset in order to understand its _____.

A. length

B. detail

C. structure

D. context

A data analyst considers which organization created, collected, or funded a dataset in order to understand its context.

2nd time

Question 1

Which of the following are examples of expressions? Select all that apply.

• 7 * 3
• 6 < 9
• 1+2+3
• 7, 2

Question 2

What do data analysts use to label the type of data contained in each column in a spreadsheet?

A. Tables

B. Menus

C. Attributes

D. Headings

The correct answer is C. Attributes

Question 3

A data analyst is using data to predict next year’s revenue. What tool can they use to accomplish this task?

A. A spreadsheet

B. A social media platform

C. A slide show

D. A text editor

The correct answer is A. A spreadsheet

Question 4

Fill in the blank: _____ are preset commands that perform calculations.

A. Functions

B. Formulas

C. Instructions

D. Goals

Functions are preset commands that perform calculations

Question 5

What is the purpose of the fill handle in a spreadsheet cell?

A. It highlights the range of data used by the cell’s function or formula.

B. It auto-fills other cells in the row or column with the same formula or function.

C. It reverts the cell to the function or formula that previously occupied the cell.

D. It changes the range of the function to include all cells in the column.

The correct answer is B. It auto-fills other cells in the row or column with the same formula or function.

Question 6

A data analyst calculates the sum of the values in cells A2 and B2. They then divide this result by three. How can they enter these calculations using a single formula?

A. =A2+B2/3

B. =(A2+B2)/3

C. A2/3+B2/3

D. A2/3+B2

The correct answer is B. =(A2+B2)/3

Question 7

What are some of the ways to avoid bias in your data analysis? Select all that apply.

• Avoid complicated and large datasets
• Work with datasets that are familiar to you
• Collect the data in an appropriate and objective way
• Have an accurate representation of the population

Question 8

Structured thinking is a process that includes which of the following elements? Select all that apply.

• Recognizing the current problem
• Revealing gaps and opportunities
• Organizing available information
• Creating visualizations

3rd times

Question 1

Both formulas and functions in spreadsheets begin with what symbol?

A. Hyphen (-)

B. Bracket ([)

**C. Equals sign (=) **

D. Colon (:)

The correct answer is Equals sign (=)

Question 2

Which of the following are good practices when working with data in a spreadsheet? Select all that apply.

• Add data labels or attributes at the beginning of each row
• Create a folder on your computer specifically for spreadsheets
• Choose a short and clear title that states exactly what the data in the spreadsheet is about
• Delete the data that does not fit in the width of the columns

Question 3

A data analyst is using data to predict next year’s revenue. What tool can they use to accomplish this task?

A. A spreadsheet

B. A slide show

C. A social media platform

C. A text editor

The correct answer is A spreadsheet

Question 4

Which of the following are examples of spreadsheet formulas? Select all that apply.

• =A1-A2
• =2B2B3
• Save
• Paste

Question 5

In the function =MAX(A1:A12), what does A1:A12 represent?

A. The formula

B. The operator

C. The range

D. The maximum

A1:A12 represent the range.

Question 6

What is the correct spreadsheet formula for multiplying cell D5 times cell D7?

A. =D5xD7

B. =D5^D7

C. =D5*D7

D. =D5/D7

The correct spreadsheet formula is =D5*D7

Question 7

What are some questions you can ask to reduce potential bias? Select all that apply.

• When was the data collect?
• Who collected the data?
• How much data is there?
• What is the data about?

Question 8

A data analyst might use descriptive column headers in order to achieve what goal?

A. Protect the spreadsheet

B. Alphabetize the spreadsheet data

C. Add context to their data

D. Filter the data

The correct answer is C. Add context to their data.

3rd times

Question 1

You perform several calculations in your spreadsheet. One calculation is four divided by 10. How would you enter this into the spreadsheet?

A. =4/10

B. =4%10

C. =10/4

D. =10#4

The correct answer is A. =4/10

Question 2

What do data analysts use to label the type of data contained in each column in a spreadsheet?

A. Tables

B. Attributes

C. Menus

D. Headings

The correct answer is B. Attributes

Question 3

Which of the following tasks might be performed using spreadsheets?

A. Land a new client

B. Write a sales pitch

C. Develop communication skills

D. Maintain information about accounts

The correct answer is D. Maintain information about accounts

Question 4

Which of the following are examples of spreadsheet formulas? Select all that apply.

• =A1-A2
• Paste
• Save
• =2B2B3

Question 5

In the function =MAX(B5:B15), what does B5:B15 represent?

A. Observation

B. Attribute

C. Range

D. Column

B5:B15 represent range

Question 6

What is the correct spreadsheet formula for multiplying cell K3 times cell K8?

A. =K3*K8

B. =K3xK8

C. =K3/K8

D. =K3^K8

The correct spreadsheet formula for multiplying cell K3 times cell K8 is A. =K3*K8

Question 7

To avoid bias when collecting data, a data analyst should keep what in mind?

• Context
• Stakeholders
• Opinion
• Graphs

Question 8

A data analyst might use descriptive column headers in order to achieve what goal?

A. Protect the spreadsheet

B. Filter the data

C. Alphabetize the spreadsheet data

D. Add context to their data

The correct answer is D. Add context to their data