Excel Challenge 57 Posted on July 2, 2024August 20, 2026 by Vijay Verma Excel Quiz 57 Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 A Power Query column contains dates such as: 15/08/2026 However, Power Query interprets some values incorrectly because the source system uses a different regional date convention. What is the most appropriate solution? Convert the column to Text permanently Delete the problematic rows Set the correct data type using the appropriate locale Change the Windows display resolution 2 / 10 A PivotTable is based on an Excel Table. You add 500 new records to the Table. What is normally required before those records appear in the PivotTable Recreate the PivotTable Change the PivotTable source manually Refresh the PivotTable Convert the Table back to a normal range 3 / 10 You have a Power Query containing these steps: Source Promoted Headers Changed Type Removed Columns Filtered Rows You discover that one of the removed columns is actually required for a later calculation. Delete the entire query and start again Modify or remove the relevant Applied Step and adjust subsequent steps if necessary Add the column back manually in Excel Refresh the query repeatedly until the column reappears 4 / 10 You want to allow users to enter data only into specific input cells while preventing them from changing formulas elsewhere on the worksheet. What is the appropriate approach? Hide all formula columns Lock the input cells and protect the worksheet Unlock the intended input cells, keep formula cells locked, and then protect the worksheet Protect the workbook structure only 5 / 10 You have converted a data range into an Excel Table. A new row is entered immediately below the table. Which statement is generally true? The new row is automatically included in the Table only if formulas are present in the row above Tables cannot expand automatically The Table expands only after the workbook is saved Excel will generally expand the Table to include the new row 6 / 10 A sales dataset contains: Region Product Sales You want to create a summary showing total Sales by Region. Which Power Query feature is most appropriate? Merge Queries Group By Unpivot Columns Split Column 7 / 10 You want to highlight all duplicate values in a column. Which Excel feature can do this directly without creating a formula rule? Conditional Formatting → Highlight Cells Rules → Duplicate Values Data Validation Cell Styles Format Painter 8 / 10 You want users to select a Department from a predefined list rather than manually typing values. Which Excel feature is most appropriate? Conditional Formatting Data Validation with a List Flash Fill Find and Replace 9 / 10 A Power Query imports data from a CSV file. You make changes directly to the resulting worksheet after loading the query. What will normally happen when the query is refreshed? Excel permanently preserves all manual changes Only formatting changes are removed The query output is regenerated, so manual changes to loaded data may be overwritten Power Query automatically incorporates the manual changes into the source 10 / 10 You have a sales table with: Region Salesperson Sales You need the data sorted first by Region alphabetically, and then by Sales from largest to smallest within each Region. Which Excel feature is most suitable? Filter Group Freeze Panes Multi-level Sort Your score is LinkedIn Facebook Twitter Retake quiz Exit
