SQL-based questions cover windows functions, GROUP BY, and all join types (LEFT, RIGHT, INNER, CROSS), along with outputs of OUTER, INNER, LEFT, and RIGHT JOINs.
Excel questions involve SORT, FILTER, RANK, VLOOKUP, XLOOKUP, and HLOOKUP formulas.
Additionally, there will be Pandas questions related to basic data manipulation, selection, filtering, merging, grouping, and summary statistics in Python.