Course Assignments
Module quiz: Excel fundamentals: Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate)
Question 1 True or False: When you select the Filter button on the Data tab, Excel automatically filters the data based on choices that you have already made in the drop-down menus next to each heading. ❌ True✅ False Explanation:Filter button sirf filtering ko enable karta hai. Excel tab tak koi filter apply nahi karta… <a href="https://codeshala.io/platform/coursera/course/preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate/assignment/module-quiz-excel-fundamentals-preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate/" rel="bookmark"><span class="screen-reader-text">Module quiz: Excel fundamentals: Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate)</span></a>
Module quiz: Formulas and functions :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025
Question 1 When you open a workbook, what does Excel recalculate? ❌ All formulas in the active worksheet❌ Only the formula in the currently selected cell✅ All formulas in the entire workbook that require recalculation Explanation:When a workbook is opened, Excel recalculates all formulas across the workbook that depend on changed or volatile data, not… <a href="https://codeshala.io/platform/coursera/course/preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate/assignment/module-quiz-formulas-and-functions-preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Module quiz: Formulas and functions :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025</span></a>
Module quiz: Formulas and functions :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025
Question 1 True or False:Cell A2 = United, Cell B2 = StatesFormula: =CONCAT(A2,B2)Result displayed: United States ❌ True✅ False Explanation:CONCAT(A2,B2) joins text without adding a space.Actual result → UnitedStates (no space). Question 2 Cell B2 contains: mOUNTAIN BikeFormula: =LOWER(B2) ❌ MOUNTAIN BIKE❌ Mountain Bike✅ mountain bike Explanation:The LOWER function converts all characters to lowercase. Question… <a href="https://codeshala.io/platform/coursera/course/preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate/assignment/module-quiz-formulas-and-functions-preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate-answers-2025-2/" rel="bookmark"><span class="screen-reader-text">Module quiz: Formulas and functions :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025</span></a>
Self-review: Creating an executive data summary :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025
Question 1 You need to freeze the screen so that columns A–F and row 1 remain visible while scrolling.Which option should you select from Freeze Panes? ❌ Freeze Top Row❌ Freeze First Column✅ Freeze Panes Explanation:To freeze both rows and columns, you must select a cell below row 1 and to the right of column… <a href="https://codeshala.io/platform/coursera/course/preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate/assignment/self-review-creating-an-executive-data-summary-preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Self-review: Creating an executive data summary :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025</span></a>
Course quiz: Preparing data for analysis with MS Excel :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025
Question 1 When you type an entry into a cell, where does it appear? ❌ In the worksheet grid only❌ In the Formula tab only✅ In the worksheet and the Formula tab Explanation:Excel shows the typed content inside the cell and in the Formula Bar at the same time. Question 2 True or False: The… <a href="https://codeshala.io/platform/coursera/course/preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate/assignment/course-quiz-preparing-data-for-analysis-with-ms-excel-preparing-data-for-analysis-with-microsoft-excel-microsoft-power-bi-data-analyst-professional-certificate-answers-2025/" rel="bookmark"><span class="screen-reader-text">Course quiz: Preparing data for analysis with MS Excel :Preparing Data for Analysis with Microsoft Excel (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025</span></a>