Coursera Google Data Analytics Professional Ask Questions to Make Data-Driven Decisions (Week 3) Quiz Answer- More spreadsheet basics.

 

Recommended Courses:

1. Coursera: Machine Learning
2. Google Data Analytics Professional Certificate.

3.More spreadsheet basics.

Question 1

Both formulas and functions in spreadsheets begin with what symbol?

• Vertical line (|)
• Equals sign (=)
• Plus-minus sign (±)
• Lowercase x

Both formulas and functions in spreadsheets begin with an equals sign.

 

Question 2

Attributes are used in spreadsheets for what purpose?

• Label the data in each column
• Insert data into each column
• Analyze the data in a row
• Add a new column

Attributes are used to label the type of data in each column in a spreadsheet.

 

Question 3

Which of the following tasks might be performed using spreadsheets?

• Land a new client
• Develop communication skills
• Maintain information about accounts
• Write a sales pitch

A spreadsheet could be used to maintain information about accounts.

 

Question 4

Fill in the blank: Combining formulas and functions enables the function to run based on a _____ set by the formula.

• change
• cell
• count
• criteria

Combining formulas and functions enables the function to run based on a criteria set by the formula.

 

Question 5

Which of the following statements describes a key difference between formulas and functions?

• Formulas are used in graphs, and functions are not.
• Formulas span two or more cells, and functions exist in only one cell.
• Formulas contain words and numbers, and functions contain numbers only.
• Formulas are written by the user, and functions are already defined.

Formulas are written by the user, and functions are already defined.

 

Question 6

Fill in the blank: Putting data into context helps data analysts eliminate _____.

• fairness
• intolerance
• labels
• bias

Putting data into context helps data analysts eliminate bias.

 

Question 7

Defining the problem domain is part of which data analytics process?

• Balanced thinking
• Logical thinking
• Organized thinking
• Structured thinking

Defining the problem domain is part of the structured-thinking process.

 

Question 8

A data analyst uses structured thinking to recognize the current problem or situation. Select the final step to structured thinking.

• Identify options
• Monitor options
• Clean data
• Sort data

The final step in the structured-thinking process is to identify options.

• 一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一一

                         Machine Learning Coursera-All weeks solutions [Assignment + Quiz]   click here

                                                                                &

                         Coursera Google Data Analytics Professional Quiz Answers   click here

Have no concerns to ask doubts in the comment section. I will give my best to answer it.

If you find this helpful kindly comment and share the post.

This is the simplest way to encourage me to keep doing such work.

Thanks & Regards,

      - Wolf