placeholder image to represent content

BI (2)

Quiz by IT Skills

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

Correct quiz answers unlock more play!

New Quizalize solo game modes
9 questions
Show answers
  • Q1
    The data obtained from the website in exercise 1
    Was imported to the excel workbook
    Was exported from the excel workbook
    Was pasted on the excel workbook
    10s
  • Q2
    Which statement is False about conditional formatting
    Readily available rules are nonadjustable
    They are dependent on data selection
    The higher rule overrides
    You can create your own rules
    20s
  • Q3
    Which of the following is not a category in the Excel Function Library
    Reference & Lookup
    Conditional
    Date & Time
    Logical
    20s
  • Q4
    What tab contains the advanced filter functionality ?
    Insert
    Home
    Data
    View
    20s
  • Q5
    What parts of the criteria should not be selected for advanced filtering ?
    Titles
    Headers
    Data
    10s
  • Q6
    Using function COUNTA on the range {1 , 4 , XY ,1A2} will give you what answer ?
    2
    4
    1
    20s
  • Q7
    $F$13 is what type of referencing ?
    Relative
    Absolute reference
    10s
  • Q8
    What is not a Data Validation Style ?
    Question
    Warning
    Information
    Stop
    20s
  • Q9
    Is this the right syntax ? VLOOKUP( Lookup_value, Table_array, Row_index_num, Range_lookup)
    False
    True
    30s

Teachers give this quiz to your class