placeholder image to represent content

Class 1 Quiz

Quiz by Siraj Samsudeen

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
22 questions
Show answers
  • Q1
    If you want to update the name of the CSV file you have imported into PQ, which step should you change?
    Connection Config Dialog
    I Don't Know
    Changed Type
    Source
    30s
  • Q2
    Text files contains which delimiter?
    Tab or Comma
    Tab
    Comma
    I Don't Know
    30s
  • Q3
    PowerQuery 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 back
    FALSE
    I Don't Know
    TRUE
    30s
  • Q4
    Which one of these is NOT a valid option for Close and Load To
    Data Model
    Table
    CSV File
    Pivot Table
    30s
  • Q5
    If you do not want to load the output of PowerQuery anywhere in the Excel, you should choose
    Only Create Connection with Add To Data Model
    Only Create Connection
    Pivot Table
    Pivot Chart
    30s
  • Q6
    Where 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 Editor
    I Don't Know
    Queries & Connection Pane
    Status Bar in PQ Editor
    30s
  • Q7
    If 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 Query
    I Don't Know
    Duplicate the Pivot Table and change the Source of the original Query
    30s
  • Q8
    If you delete the sheet where PQ is creating its output, what happens?
    Queries changes to 'Only Create Connection' as the Load To Option
    I Don't Know
    You can delete the sheet , but the Query will not work
    You get an Error - you can't delete the sheet
    30s
  • Q9
    When you split a column by delimiter, the delimiter can be only ONE letter or character
    I Don't Know
    TRUE
    FALSE
    30s
  • Q10
    When 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 default
    FALSE
    TRUE
    I Don't Know
    30s
  • Q11
    When you select Table as the Load To option, the Table will ALWAYS be created in a new sheet
    TRUE
    I Don't Know
    FALSE
    30s
  • Q12
    When 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 rows
    I Don't Know
    TRUE
    FALSE
    30s
  • Q13
    When you add new rows to a Table connected to PQ, if you refresh, you get
    Only Old data
    All the data in the Table - old and new
    Only new data
    I Don't Know
    30s
  • Q14
    When you see 'ABC123' in front of the colum name in PQ Editor, what is the datatype of the column?
    A mix of Text and Integer
    Text
    Integer
    No data type
    30s
  • Q15
    When you drag Sales to Pivot Table Values area and its datatype is text, what calculation is applied by default?
    Count of Sales
    You can drag only numbers to Values area
    I Don't Know
    Sum of Sales
    30s

Teachers give this quiz to your class