Ravindra BagaleCourses & study guides मराठी Track your progress
Ravi Sir (Ravindra Bagale) cartoon

Excel Interview Questions and Answers: 42 Interview Cards with Examples

By Last updated:

Contents

Basics and formulas

Excel interview card 1: Formula vs function: what is the difference? Example, what it is, why use it and how to do it.
Card 1 of 42: Formula vs function: what is the difference? · Download PNG · Full lesson
Excel interview card 2: What are relative, absolute and mixed references? Example, what it is, why use it and how to do it.
Card 2 of 42: What are relative, absolute and mixed references? · Download PNG · Full lesson
Excel interview card 3: What is an Excel Table, and why not a plain range? Example, what it is, why use it and how to do it.
Card 3 of 42: What is an Excel Table, and why not a plain range? · Download PNG · Full lesson
Excel interview card 4: What is Flash Fill? Example, what it is, why use it and how to do it.
Card 4 of 42: What is Flash Fill? · Download PNG · Full lesson
Excel interview card 5: How do you make a drop-down list? Example, what it is, why use it and how to do it.
Card 5 of 42: How do you make a drop-down list? · Download PNG · Full lesson
Excel interview card 6: How do you highlight a whole row by a rule? Example, what it is, why use it and how to do it.
Card 6 of 42: How do you highlight a whole row by a rule? · Download PNG · Full lesson

SUMIFS, COUNTIFS and logic

Excel interview card 7: What is SUMIF vs SUMIFS? Example, what it is, why use it and how to do it.
Card 7 of 42: What is SUMIF vs SUMIFS? · Download PNG · Full lesson
Excel interview card 8: What is COUNT vs COUNTA vs COUNTBLANK? Example, what it is, why use it and how to do it.
Card 8 of 42: What is COUNT vs COUNTA vs COUNTBLANK? · Download PNG · Full lesson
Excel interview card 9: What is COUNTIFS? Example, what it is, why use it and how to do it.
Card 9 of 42: What is COUNTIFS? · Download PNG · Full lesson
Excel interview card 10: What is AVERAGEIFS? Example, what it is, why use it and how to do it.
Card 10 of 42: What is AVERAGEIFS? · Download PNG · Full lesson
Excel interview card 11: What are MAXIFS and MINIFS? Example, what it is, why use it and how to do it.
Card 11 of 42: What are MAXIFS and MINIFS? · Download PNG · Full lesson
Excel interview card 12: How do IF, AND and OR work together? Example, what it is, why use it and how to do it.
Card 12 of 42: How do IF, AND and OR work together? · Download PNG · Full lesson
Excel interview card 13: What is nested IF vs IFS? Example, what it is, why use it and how to do it.
Card 13 of 42: What is nested IF vs IFS? · Download PNG · Full lesson
Excel interview card 14: What is IFERROR vs IFNA? Example, what it is, why use it and how to do it.
Card 14 of 42: What is IFERROR vs IFNA? · Download PNG · Full lesson
Excel interview card 15: What is SUBTOTAL vs SUM? Example, what it is, why use it and how to do it.
Card 15 of 42: What is SUBTOTAL vs SUM? · Download PNG · Full lesson

Lookups

Excel interview card 16: What is VLOOKUP vs XLOOKUP? Example, what it is, why use it and how to do it.
Card 16 of 42: What is VLOOKUP vs XLOOKUP? · Download PNG · Full lesson
Excel interview card 17: What is INDEX + MATCH? Example, what it is, why use it and how to do it.
Card 17 of 42: What is INDEX + MATCH? · Download PNG · Full lesson
Excel interview card 18: What is an approximate match lookup? Example, what it is, why use it and how to do it.
Card 18 of 42: What is an approximate match lookup? · Download PNG · Full lesson
Excel interview card 19: How do you get the last match with XLOOKUP? Example, what it is, why use it and how to do it.
Card 19 of 42: How do you get the last match with XLOOKUP? · Download PNG · Full lesson
Excel interview card 20: How do you return several columns with one lookup? Example, what it is, why use it and how to do it.
Card 20 of 42: How do you return several columns with one lookup? · Download PNG · Full lesson

Text and dates

Excel interview card 21: What do TRIM, CLEAN and PROPER do? Example, what it is, why use it and how to do it.
Card 21 of 42: What do TRIM, CLEAN and PROPER do? · Download PNG · Full lesson
Excel interview card 22: What is TEXTJOIN vs CONCAT? Example, what it is, why use it and how to do it.
Card 22 of 42: What is TEXTJOIN vs CONCAT? · Download PNG · Full lesson
Excel interview card 23: What are TEXTBEFORE and TEXTAFTER? Example, what it is, why use it and how to do it.
Card 23 of 42: What are TEXTBEFORE and TEXTAFTER? · Download PNG · Full lesson
Excel interview card 24: What is DATEDIF? Example, what it is, why use it and how to do it.
Card 24 of 42: What is DATEDIF? · Download PNG · Full lesson
Excel interview card 25: What are EOMONTH and EDATE? Example, what it is, why use it and how to do it.
Card 25 of 42: What are EOMONTH and EDATE? · Download PNG · Full lesson
Excel interview card 26: What is NETWORKDAYS? Example, what it is, why use it and how to do it.
Card 26 of 42: What is NETWORKDAYS? · Download PNG · Full lesson
Excel interview card 27: How does Excel store a date? Example, what it is, why use it and how to do it.
Card 27 of 42: How does Excel store a date? · Download PNG · Full lesson

Dynamic arrays

Excel interview card 28: What is the FILTER function? Example, what it is, why use it and how to do it.
Card 28 of 42: What is the FILTER function? · Download PNG · Full lesson
Excel interview card 29: What is the UNIQUE function? Example, what it is, why use it and how to do it.
Card 29 of 42: What is the UNIQUE function? · Download PNG · Full lesson
Excel interview card 30: How do you get the top N rows with a formula? Example, what it is, why use it and how to do it.
Card 30 of 42: How do you get the top N rows with a formula? · Download PNG · Full lesson
Excel interview card 31: What is a spill range and #SPILL!? Example, what it is, why use it and how to do it.
Card 31 of 42: What is a spill range and #SPILL!? · Download PNG · Full lesson
Excel interview card 32: What is the LET function? Example, what it is, why use it and how to do it.
Card 32 of 42: What is the LET function? · Download PNG · Full lesson

PivotTables

Excel interview card 33: What is a PivotTable? Example, what it is, why use it and how to do it.
Card 33 of 42: What is a PivotTable? · Download PNG · Full lesson
Excel interview card 34: What is a Calculated Field? Example, what it is, why use it and how to do it.
Card 34 of 42: What is a Calculated Field? · Download PNG · Full lesson
Excel interview card 35: How do you group dates by month in a PivotTable? Example, what it is, why use it and how to do it.
Card 35 of 42: How do you group dates by month in a PivotTable? · Download PNG · Full lesson
Excel interview card 36: What is a Slicer vs a Timeline? Example, what it is, why use it and how to do it.
Card 36 of 42: What is a Slicer vs a Timeline? · Download PNG · Full lesson
Excel interview card 37: What is GETPIVOTDATA? Example, what it is, why use it and how to do it.
Card 37 of 42: What is GETPIVOTDATA? · Download PNG · Full lesson

Cleaning, what-if, Power Query and macros

Excel interview card 38: How do you remove duplicates? Example, what it is, why use it and how to do it.
Card 38 of 42: How do you remove duplicates? · Download PNG · Full lesson
Excel interview card 39: What is Goal Seek? Example, what it is, why use it and how to do it.
Card 39 of 42: What is Goal Seek? · Download PNG · Full lesson
Excel interview card 40: What is Power Query? Example, what it is, why use it and how to do it.
Card 40 of 42: What is Power Query? · Download PNG · Full lesson
Excel interview card 41: What is the Data Model and CALCULATE? Example, what it is, why use it and how to do it.
Card 41 of 42: What is the Data Model and CALCULATE? · Download PNG · Full lesson
Excel interview card 42: What is a macro, and how do you save it? Example, what it is, why use it and how to do it.
Card 42 of 42: What is a macro, and how do you save it? · Download PNG · Full lesson

More quick revision: Ravi Sir's Cards.