Get to work with spreadsheets

To perform calculations in a spreadsheet, data analysts use formulas and functions. True or False?

A. True

B. False

Explain: To perform calculations in a spreadsheet, data analysts use formulas and functions, such as SUM, AVERAGE, and COUNT.

What are the first steps a data analyst takes when working with data in a spreadsheet?

A. Sort and filter

B. Calculate and present

C. Highlight and graph

D. View and summarize

The correct answer is A. Sort and filter. Explain: The first steps a data analyst takes when working with data in a spreadsheet are to sort and filter the data.

Step-by-step in spreadsheets

Would you like to perform upcoming formatting tasks along with the instructor using the same spreadsheet?

Click the link below and select “Use Template.”

Link to template: Population of Latin and Caribbean Countries

OR

If you don't have a Google account, download the template directly from the attachment below.

Formulas for success

Would you like to follow along with the instructor using the same spreadsheet?

Click the link below and select "Use Template"

Link to template: Monthly Sales

OR

If you don't have a Google account, download the template directly from the attachment below.

In spreadsheets, what is the term for the symbols used in formulas to perform a specific calculation?

A. Operators

B. Attributes

C. References

D. Tables

The correct answer is A. Operators. Explain:

In spreadsheets, the symbols used in a formula to perform a specific calculation are called operators.

Spreadsheet errors and fixes

Would you like to follow along with the instructor using the same spreadsheet? To use the template for the spreadsheet, click the link below and select "Use Template."

Note: You will be expected to select multiple tabs to different worksheets to follow along. Consult the README in the first worksheet for the details.

Link to template: Spreadsheet Errors and Fixes Demo Sheets

OR

If you don't have a Google account, you can download the workbook from the attachment below

Functions 101

Question 1

Would you like to follow along with the instructor using the same spreadsheet? To use the template for the spreadsheet, click the link below and select "Use Template."

Link to template: Monthly Sales - Functions 101

OR

If you don't have a Google account, you can download the spreadsheet from the attachment below

Question 2

Which of the following are functions? Select all that apply.

• START
• MIN

Explain: SUM, AVERAGE, and MIN are functions. A function is a preset command that automatically performs a specific process or task using data.

• SUM

Explain: SUM, AVERAGE, and MIN are functions. A function is a preset command that automatically performs a specific process or task using data.

• AVERAGE

Explain: SUM, AVERAGE, and MIN are functions. A function is a preset command that automatically performs a specific process or task using data.

Staying objective

A data analyst considers who, what, when, where, why, and how in order to achieve what goal?

A. To ensure calculations are accurate

B. To create compelling graphs

C. To put information into context

D. To make data-driven decisions

The correct answer is C. To put information into context. Explain: A data analyst asks who, what, when, where, why, and how in order to put information into context.