Python
What keyword is used to define a function in Python?
def
What does VBA stand for?
Visual Basic for Applications
What function returns the average of a range?
=AVERAGE()
What function gives you the largest number in a range?
=MAX()
What visual shows trends over time in Power BI?
Line chart
What data type stores a list of items in order and allows duplicates?
list
What keyword is used to declare a variable in VBA?
Dim
What function counts how many cells contain numbers?
=COUNT()
What is the middle value of an ordered data set called?
Median
What language is used for calculations in Power BI?
DAX
Which operator checks if two values are equal?
==
Which object is used to show a pop-up message in VBA?
MsgBox
Which function finds the most frequent number in a range?
=MODE()
Which function measures how far numbers deviate from the mean?
=STDEV.S()
What is the tool that lets users filter visuals?
Slicer
What is the output of len([3, 4, 5, 6])
4
What keyword ends a subroutine?
End Sub
What formula would calculate percentage change from A1 to B1?
=(B1 - A1) / A1
What percentage of data falls within 2 standard deviations in a normal distribution?
95%
What is the purpose of the Format pane in Power BI?
To customize visual appearance
What is the difference between a tuple and a list in Python?
Tuples are immutable, lists are mutable.
What function returns the position of one string within another in VBA?
InStr
What function looks up a value in the first column of a range and returns a value in the same row from another column?
=VLOOKUP()
What does a correlation coefficient of -1 mean?
Perfect negative linear relationship
What is the difference between a Measure and a Column in Power BI?
Measures calculate at runtime; columns are stored in the data model.