Question bank
Pick an answer to see if you're right — with an explanation.
All topicsPythonSQL / MySQLData ScienceNumPyPandasMatplotlibMachine LearningDeep LearningArtificial IntelligenceLarge Language ModelsDjangoAPIsGit & GitHubPower BIExcelStatistics
ExcelEasy
Which function removes leading and trailing spaces but keeps single spaces between words?
aCLEAN
bTRIM
cSUBSTITUTE
dPROPER
Explanation: TRIM strips leading, trailing and repeated inner spaces; CLEAN removes non-printing characters.
ExcelEasy
Which shortcut triggers Flash Fill?
aCtrl+T
bCtrl+Shift+L
cCtrl+D
dCtrl+E
Explanation: Ctrl+E runs Flash Fill, which completes a column from the pattern you typed in the first cell.
ExcelEasy
Which formula returns a distinct list of states from a column?
a=UNIQUE(Sales[State])
b=DISTINCT(Sales[State])
c=SORT(Sales[State])
d=COUNTIF(Sales[State],"*")
Explanation: UNIQUE spills the distinct values; there is no DISTINCT function in Excel.
ExcelEasy
In Data Validation, which Allow option creates a dropdown list in a cell?
aDecimal
bCustom
cList
dText length
Explanation: The List option builds a dropdown from typed values or a range reference.
ExcelMedium
In the formula below, what role does the `*` play?
=FILTER(Sales[Invoice], (Sales[State]="Rajasthan")*(Sales[Taxable]>50000), "None")aIt multiplies the invoice values
bIt joins the two text conditions
cIt acts as a logical AND between the two conditions, row by row
dIt is a wildcard for any state
Explanation: Multiplying two TRUE/FALSE arrays gives 1 only when both are TRUE, which is the array equivalent of AND.
ExcelMedium
Cell D2 holds the formula below and D5 already contains text. What happens?
=SORT(UNIQUE(Sales[City]))aExcel returns #SPILL! because a cell in the spill range is occupied
bExcel overwrites D5
cExcel returns only the first city
dExcel returns #NAME?
Explanation: A dynamic array needs empty cells to spill into; any obstruction gives #SPILL!.
ExcelMedium
The LAMBDA below is saved in Name Manager as `GSTAmount`. What does `=GSTAmount(50000,18)` return?
=LAMBDA(taxable, rate, ROUND(taxable * rate / 100, 2))a900
b59000
c#VALUE!
d9000
Explanation: 50000 x 18 / 100 = 9000; the LAMBDA is reusable once named.
ExcelMedium
A conditional formatting rule applied to `$A$2:$H$500` should colour the whole row when column E exceeds 1,00,000. Which formula is correct?
a=E2>100000
b=$E2>100000
c=$E$2>100000
d=E$2>100000
Explanation: Locking the column and leaving the row relative makes every cell in a row test that row's column E.
ExcelHard
In Power Query, a text column of dates like `13/04/2026` errors when you change its type to Date on a US-English machine. What is the correct fix?
aRemove the error rows
bSplit the column and rebuild the date
cReplace the slashes with hyphens first
dUse Change Type With Locale and choose Date, English (India)
Explanation: Locale tells Power Query the values are dd/mm/yyyy, so 13 is read as the day rather than an invalid month.
ExcelHard
Your dashboard has three PivotTables from the same Table, but the State slicer filters only one of them. What fixes it?
aCopy and paste the slicer twice
bConvert the slicer into a Timeline
cRight-click the slicer, open Report Connections and tick all three PivotTables
dMove all three PivotTables onto the dashboard sheet
Explanation: A slicer controls only the pivot it was created from until the other pivots are linked via Report Connections.