5.2.3.Weekly challenge 2 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

LATEST SUBMISSION GRADE 100%

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?

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

Correct. 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
  • Data validation
  • Conditional formatting
  • Pop-up menus

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

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?

  • Conditional formatting
  • CONVERT
  • Add color
  • Data validation

Correct. They are using conditional formatting*, which changes how cells appear when values meet specific conditions, such as 80 or more.*

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?

  • JOIN
  • CONCAT
  • GROUP
  • COMBINE

Correct. You can use CONCAT*, which enables you to join multiple text strings from multiple sources.*

Question 5

You are querying a database of keynote speakers to determine who has expertise in zoology. For your project, you only need the first 12 records. What clause should you add to the following SQL query?

SELECT speakers
FROM keynote_table
WHERE expertise = "zoology"
  • LIMIT 12
  • LIMIT_12
  • LIMIT,12
  • LIMIT = 12

Correct. To return only the first 12 records, type LIMIT 12*.*

Question 6

A data analyst is working with a spreadsheet that has very long text strings. Rather than counting the characters themselves to determine the number of characters they contain, what tool can they use?

  • The LEN function
  • The CHAR function
  • The MID function
  • The COUNT function

Correct. They can use the LEN function, which counts the number of characters in a text string.

Question 7

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

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

Correct. 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

When working with a spreadsheet, data analysts use the find function to locate specific characters in a string. Find is case-sensitive, so it’s necessary to input the substring exactly how it appears.

  • True
  • False

Correct. Find is case-sensitive, so it’s necessary to input the substring exactly how it appears.