Excel interview questions for data analysts
Use these suggested interview exercises to practice explaining assumptions, methods and validation. They are not a list of questions guaranteed to appear in an interview. The employer’s current requirements and assessment instructions take precedence.
Before you practice
Read the job description. Identify the responsibilities you would own. Ask about the assessment format, time limit, data, allowed tools and AI-assistance policy. Practice with public or synthetic data, and be ready to explain a step without relying on an assistant’s output.
How would you find inconsistent records?
Practice scenario: A spreadsheet contains duplicate order IDs, mixed date formats and blank amounts. Explain how you would inspect it before building a summary.
What to explain: Preserve the original data, establish the column meanings and identify invalid or duplicate records. Use appropriate validation, filters or query steps and record any correction. Do not silently replace missing values with zero if that changes the meaning.
How would you reconcile a PivotTable?
Practice scenario: A PivotTable total differs from the source table. Describe the checks and how you would explain the difference.
What to explain: Check the source range, refresh state, filters, value aggregation and whether numbers are stored as text. Compare an independently calculated total and inspect excluded rows. A visually convincing summary can still use incomplete data.
How would you make the workbook reviewable?
Practice scenario: A colleague must update your monthly workbook after you leave. Explain the handoff.
What to explain: Document sources, refresh steps, formulas, assumptions and expected checks. Separate inputs from outputs and test a known case. Follow the employer’s sharing permissions and avoid hidden manual adjustments that a reviewer cannot trace.
Review your answer
Check whether you defined the question, justified the method and proposed a way to verify the result. Include a failure case and a limitation. Our suggested rubric assesses reasoning and evidence; it is not an employer’s official scoring system.
Questions for the interviewer
- Which deliverable would I own, and who reviews it?
- What data-quality or operational problems does the team currently face?
- How do you assess success and support learning in this role?
Sources and next steps
Sources checked on October 2, 2026. Follow the linked documentation for current requirements.