Data Analyst
Excel questions
189 questions on Excel for data analysts, easiest first.
Easy 59
- What a pivot table doeseasy
- Absolute references in Exceleasy
- VLOOKUP returns wrong priceseasy
- SUMIFS with two conditionseasy
- Lost leading zeros in IDseasy
- What the F4 key does in a formulaeasy
- COUNT versus COUNTAeasy
- What #DIV/0! meanseasy
- What causes #NAME?easy
- A cell full of ####easy
- Quick way to insert SUMeasy
- Result of =10+5*2easy
- Turning a range into a Tableeasy
- Keeping headers visible while scrollingeasy
- Copying a formula down one roweasy
- Pass or fail with IFeasy
- SUM ignores some numberseasy
- Counting orders above ₹50,000easy
- Finding the second-highest saleeasy
- A date that should not changeeasy
- The 3 in a VLOOKUPeasy
- Writing a basic XLOOKUPeasy
- Friendly message when an ID is missingeasy
- Cleaning extra spaces from nameseasy
- Fixing capital letters in nameseasy
- State code from a GSTINeasy
- Joining first and last nameeasy
- Spotting wrong mobile numberseasy
- Days between two dateseasy
- Showing the weekday nameeasy
- Last day of the montheasy
- Filling a pattern from one exampleeasy
- Splitting "City, State" into two columnseasy
- How Excel stores 12:00 nooneasy
- Lookup on a repeated IDeasy
- Listing only one region's rowseasy
- A list of cities without repeatseasy
- Sorting by sales, highest firsteasy
- What #SPILL! meanseasy
- Referring to a whole spilled listeasy
- Highlighting overdue amountseasy
- A dropdown for status valueseasy
- Deleting repeated rowseasy
- Sort by state, then by cityeasy
- Total sales per branch in a pivoteasy
- Pivot shows old numberseasy
- Buttons to filter a pivoteasy
- Chart for monthly revenue trendeasy
- Letting users edit only input cellseasy
- Sending numbers without formulaseasy
- GST formula gives a huge numbereasy
- Growth from last yeareasy
- One big salary skews the averageeasy
- Ranking salespeopleeasy
- Target achievement percentageeasy
- A running total columneasy
- GST with many decimalseasy
- Why PMT shows a negative EMIeasy
- Monthly EMI needs a monthly rateeasy
Medium 76
- Looking up a value to the leftmedium
- Share of sales in a pivot tablemedium
- Pivot ignores new data rowsmedium
- Same cleaning every Mondaymedium
- One formula for a whole gridmedium
- COUNTIF with the limit in a cellmedium
- Counting names that contain a wordmedium
- IFERROR hides too muchmedium
- IFS returns #N/A for some rowsmedium
- Turning codes into names with SWITCHmedium
- Sum that skips hidden rowsmedium
- Summing a column that has errorsmedium
- Circular reference warningmedium
- Summing the same cell on many sheetsmedium
- Why name the tax rate cellmedium
- What [@Qty] means in a Tablemedium
- AVERAGE with a blank and a zeromedium
- Total is off by 0.01medium
- #REF! after a column was deletedmedium
- #VALUE! with + but not with SUMmedium
- Formulas do not updatemedium
- Weighted average pricemedium
- Highest sale in one regionmedium
- Rounding prices up to the next ₹5medium
- Commission rate from slabsmedium
- Lookup by row and columnmedium
- The 0 at the end of MATCHmedium
- One XLOOKUP, three columns backmedium
- Latest price for a productmedium
- Lookup fails for values that look identicalmedium
- ID 1001 not foundmedium
- Removing commas from amountsmedium
- FIND versus SEARCHmedium
- Getting the domain from an emailmedium
- TEXTAFTER for the email domainmedium
- Joining address parts without gapsmedium
- Month labels sort in the wrong ordermedium
- One month after 31 Januarymedium
- Working days in two weeksmedium
- Due date 3 working days latermedium
- Age in completed yearsmedium
- Hours for a night shiftmedium
- Weekly hours show 16:30medium
- Paying an hourly ratemedium
- What SEQUENCE returnsmedium
- FILTER with two conditionsmedium
- FILTER returns #CALC!medium
- Sort names by a column you do not showmedium
- Customers who ordered only oncemedium
- Colouring the whole row by statusmedium
- A second dropdown that depends on the firstmedium
- January shows two years togethermedium
- Counting unique customers in a pivotmedium
- A strange GETPIVOTDATA formulamedium
- Months spread across columnsmedium
- Merge or Append in Power Querymedium
- Finding the price for a target profitmedium
- EMI for many rates and tenuresmedium
- Revenue and margin % on one chartmedium
- Filling blanks with the value abovemedium
- Top 5 products in one formulamedium
- Stacking two sheets with a formulamedium
- A dropdown that grows with the datamedium
- A 2-million-row CSVmedium
- GST inside a pricemedium
- VAT inside a UAE receiptmedium
- Markup and margin on the same itemmedium
- STDEV.S or STDEV.Pmedium
- EMI on a ₹10 lakh loanmedium
- Value of a 10-year SIPmedium
- Where the initial investment goes in NPVmedium
- Returns on irregular investmentsmedium
- CAGR when revenue doublesmedium
- Straight-line depreciationmedium
- Reading a CORREL resultmedium
- Ageing buckets for receivablesmedium
Hard 54
- Grand total of an average pivothard
- Result of =-2^2hard
- A difference of -2.78E-17hard
- 16-digit numbers lose a digithard
- Why the model recalculates slowlyhard
- SUMIF adds the wrong rowshard
- INT and TRUNC on a negative numberhard
- COUNTIF finds duplicates that are nothard
- An intended circular formulahard
- Summing two regions in one SUMIFShard
- The "Set precision as displayed" optionhard
- Why the double minushard
- An @ appears in an old formulahard
- Why use LEThard
- Creating a GST function with LAMBDAhard
- Counting codes with exact casehard
- Dates swapped when opening a CSVhard
- The date that never existedhard
- Approximate lookup on unsorted datahard
- XLOOKUP with a partial namehard
- Lookup on two conditionshard
- TRIM does not remove a spacehard
- Financial year from a datehard
- Week number of 1 January 2027hard
- Lookup shows 0 for an empty cellhard
- Wrong values after inserting a columnhard
- Times stored as texthard
- First day of the month from any datehard
- Fast lookup on a million rowshard
- Working days with a Friday–Saturday weekendhard
- Monthly total from a date columnhard
- Margin in a calculated fieldhard
- Query breaks after a column renamehard
- Duplicates that Power Query keepshard
- Total Sales that follows slicershard
- Share of total with CALCULATEhard
- A summary table with one formulahard
- Production mix with limitshard
- Model slows down after adding data tableshard
- Highlight lands one row offhard
- Invalid values despite validationhard
- Chart loses data when rows are hiddenhard
- Grouping one pivot changes anotherhard
- Protecting confidential salary datahard
- Loading big data without a worksheethard
- FILTER inside an Excel Tablehard
- A project with two IRRshard
- Effective rate of 12% compounded monthlyhard
- Lease paid at the start of each monthhard
- Interest in the first EMIhard
- Double-declining depreciation in year 1hard
- Forecasting the next monthhard
- GST total differs by a paisahard
- Showing amounts in lakh stylehard