Course Assignments
Module 1 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025
Question 1 A data analyst sorts all data by ranking in one column while keeping entire rows together. ✅ Sort sheet❌ Sort rows❌ Sort column❌ Sort together Explanation:“Sort sheet” arranges all data rows based on one column’s values, ensuring that the rest of the row data stays aligned correctly.(“Sort range” or “Sort sheet” both sort… <a href="https://codeshala.io/platform/coursera/course/analyze-data-to-answer-questions-google-data-analytics-professional-certificate/assignment/module-1-challenge-analyze-data-to-answer-questions-google-data-analytics-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Module 1 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025</span></a>
Module 2 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025
Question 1 A junior data analyst uses a spreadsheet function to locate specific characters from account numbers. ✅ FIND❌ WHERE❌ IDENTIFY❌ FROM Explanation:The FIND() function locates the position of a specific character or substring within a text string.Example: =FIND("-", A2) finds where the dash appears in a cell. Question 2 Count the number of characters… <a href="https://codeshala.io/platform/coursera/course/analyze-data-to-answer-questions-google-data-analytics-professional-certificate/assignment/module-2-challenge-analyze-data-to-answer-questions-google-data-analytics-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Module 2 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025</span></a>
Module 3 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025
Question 1 You use VLOOKUP but it fails due to extra spaces in names. ✅ TRIM❌ NOSPACE❌ VALUE❌ CUT Explanation:TRIM() removes all extra spaces from text except for single spaces between words.Example: =TRIM(A1) This cleans “Liza␣␣Campbell” → “Liza Campbell”. Question 2 To count unique “paid” orders instead of total orders. ✅ COUNT DISTINCT❌ COUNT❌ RANGE❌… <a href="https://codeshala.io/platform/coursera/course/analyze-data-to-answer-questions-google-data-analytics-professional-certificate/assignment/module-3-challenge-analyze-data-to-answer-questions-google-data-analytics-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Module 3 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025</span></a>
Module 4 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025
Question 1 Identify rows where carbonated_bev values don’t match all_bev. ✅ WHERE all_bev <> carbonated_bev✅ WHERE all_bev != carbonated_bev❌ WHERE all_bev >< carbonated_bev❌ WHERE all_bev !! carbonated_bev Explanation:In SQL, <> and != both mean “not equal to”.Example: SELECT * FROM beverages WHERE all_bev <> carbonated_bev; Question 2 Fill in the blank: GROUP BY groups rows… <a href="https://codeshala.io/platform/coursera/course/analyze-data-to-answer-questions-google-data-analytics-professional-certificate/assignment/module-4-challenge-analyze-data-to-answer-questions-google-data-analytics-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Module 4 challenge :Analyze Data to Answer Questions (Google Data Analytics Professional Certificate) Answers 2025</span></a>