![placeholder image to represent content](/_next/image?url=%2Fassets%2Fquiz_default_logo.jpg&w=256&q=75)
Class 1 Quiz
Quiz by Siraj Samsudeen
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
22 questions
Show answers
- Q1If you want to update the name of the CSV file you have imported into PQ, which step should you change?Connection Config DialogI Don't KnowChanged TypeSource30s
- Q2Text files contains which delimiter?Tab or CommaTabCommaI Don't Know30s
- Q3PowerQuery expects you to set change data types on load. If you delete the Changed Type step, it would not allow you to load the data backFALSEI Don't KnowTRUE30s
- Q4Which one of these is NOT a valid option for Close and Load ToData ModelTableCSV FilePivot Table30s
- Q5If you do not want to load the output of PowerQuery anywhere in the Excel, you should chooseOnly Create Connection with Add To Data ModelOnly Create ConnectionPivot TablePivot Chart30s
- Q6Where can see you see the number of rows output from a Query, if you have 10,000 rows in your CSV file?Queries List in PQ EditorI Don't KnowQueries & Connection PaneStatus Bar in PQ Editor30s
- Q7If you want to keep a Pivot Table created from a Query for historical reasons and create a new Pivot Table based on new data, what should you do?Duplicate the Query, change the source and create a new Pivot Table connected to the new QueryI Don't KnowDuplicate the Pivot Table and change the Source of the original Query30s
- Q8If you delete the sheet where PQ is creating its output, what happens?Queries changes to 'Only Create Connection' as the Load To OptionI Don't KnowYou can delete the sheet , but the Query will not workYou get an Error - you can't delete the sheet30s
- Q9When you split a column by delimiter, the delimiter can be only ONE letter or characterI Don't KnowTRUEFALSE30s
- Q10When a text column in split into 3 columns, then when 1 column is number and other column is date, PQ sets the data type of all three columns by defaultFALSETRUEI Don't Know30s
- Q11When you select Table as the Load To option, the Table will ALWAYS be created in a new sheetTRUEI Don't KnowFALSE30s
- Q12When you add new rows to a Table connected to PQ, after adding the rows, you have to adjust the formulas so that PQ picks up the new rowsI Don't KnowTRUEFALSE30s
- Q13When you add new rows to a Table connected to PQ, if you refresh, you getOnly Old dataAll the data in the Table - old and newOnly new dataI Don't Know30s
- Q14When you see 'ABC123' in front of the colum name in PQ Editor, what is the datatype of the column?A mix of Text and IntegerTextIntegerNo data type30s
- Q15When you drag Sales to Pivot Table Values area and its datatype is text, what calculation is applied by default?Count of SalesYou can drag only numbers to Values areaI Don't KnowSum of Sales30s