Coursera Google Data Analytics Professional Analyze Data to Answer Questions (Week 2) Quiz Answer-Formatting and adjusting data.

  

Recommended Courses:

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

2.Formatting and adjusting data.

Question 1

An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. What spreadsheet tool can help them select the right format?

• Format as Currency
• EXCHANGE
• CURRENCY
• Format as Dollar

The Format as Currency tool can be used to change the text to Australian dollars.

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 dropdown list with Need to Apply and Applied as the possible options?

• FIND
• Conditional formatting
• Data validation
• Pop-up menus

Data validation can be used to add drop-down lists with predetermined options for Need to Apply and Applied.

 

Question 3

You are using a spreadsheet to keep track of your newspaper subscriptions. You add color to indicate if a subscription is current or has expired. Which spreadsheet tool changes how cells appear when values meet each expiration date?

• Add color
• Conditional formatting
• CONVERT
• Data validation

You are using conditional formatting. Conditional formatting changes how cells appear when values meet specific conditions.

Question 4

A data analyst wants to write a SQL query to combine data from two columns and into a new column. What function can they use?

• JOIN
• CONCAT
• GROUP
• COMBINE

They can use CONCAT, which joins multiple text strings from multiple sources.

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"

• LIMIT = 80
• LIMIT 80
• LIMIT,80
• LIMIT_80

To return only the first 80 records, type LIMIT 80.

 

Question 6

A data analyst is working with a spreadsheet that has very long text strings. They use a function to count the number of characters in cell G11. What is the correct syntax?

• =LEN(G,11)
• =LEN(G:G11)
• =LEN(G11)
• =LEN(“G11”)

The correct syntax is =LEN(G11). The LEN function counts the number of characters in a text string and the parameter for the function is the cell reference.

Question 7

Spreadsheet cell L6 contains the text string “Function.” To return the substring “Fun,” what is the correct syntax?

• =LEFT(L6, 3)
• =RIGHT(L6, 3)
• =RIGHT(3,L6)
• =LEFT(3,L6)

The function =LEFT(L6, 3) will return “Fun.” The LEFT function returns a set number of characters from the left side of a text string. In this case, it returns a three-character substring from the end of the string in L6, starting from the left.

 

Question 8

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

• IDENTIFY
• FIND
• WHERE
• FROM

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

 

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

                         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