Top 10 Boss Questions and How to Answer Them in Excel

Top 10 boss questions come up in almost every job that touches a spreadsheet. If your boss has ever leaned over your desk and said, "Can you just tell me…?", you know the feeling. The clock starts ticking, eyes are on you, and your spreadsheet skills suddenly matter more than your coffee supply.

Here is your go-to list of 10 Excel formulas that answer the most common boss questions in seconds, complete with the plain-English version of the request, the exact formula, and why it works. You can download it here, and a free answer builder at the end runs every formula on sample data.

Boss Questions and Excel Formulas at a Glance

The boss asks	Answer with
What is the price or value for this item?	VLOOKUP, XLOOKUP, or INDEX and MATCH
Did it pass or fail?	IF
What is the total for one group?	SUMIF
How many are over a target?	COUNTIF
Show me just those results.	FILTER
Put these names in one line.	TEXTJOIN
Clean up these names.	PROPER
What is the grand total?	SUM

1. VLOOKUP: "Look Up Product 101 and Tell Me the Price"

VLOOKUP is the classic answer when someone wants one value from a long list.

Boss says	“Look up product 101 and tell me the price.”
Formula	`=VLOOKUP(101, A2:C20, 3, FALSE)`
Why it works	It searches for a value in the first column of a range and returns data from another column in the same row. FALSE means exact match only.
When to use	Quick lookups in a vertical list, like finding prices, IDs, or names.

The 3 is the column number to return, counting from the first column of the range. If you insert a column in the middle later, that number does not update, which is the most common way VLOOKUP breaks.

2. XLOOKUP: "Show Me Sales for 101, Unless There Are None"

XLOOKUP is the modern replacement for VLOOKUP, available in Excel for Microsoft 365 and Excel for the web.

Boss says	“If we have sales for 101, show me, unless there are none.”
Formula	`=XLOOKUP(101, A2:A20, C2:C20, "No Sales")`
Why it works	It looks up a value in one range and returns the matching value from another, in any direction, and shows a custom message if nothing is found.
When to use	Any time you want more flexibility than VLOOKUP without worrying about column positions.

Because you point to the lookup column and the return column separately, inserting columns does not break it.

3. INDEX and MATCH: "What Is the Revenue for Product 101?"

INDEX and MATCH is the flexible lookup that works in every version of Excel.

Boss says	“What is the revenue (column C) for product 101 (column A)?”
Formula	`=INDEX(C2:C20, MATCH(101, A2:A20, 0))`
Why it works	A two-part lookup: MATCH finds the row number of 101, and INDEX returns the value from that row in column C. The 0 means exact match.
When to use	Dynamic lookups, especially when column order might change, or when you need to look to the left.

4. IF: "If They Scored at Least 80, Show Pass"

IF turns a rule into an answer on every row.

Boss says	“If they scored at least 80, show Pass; if not, show Fail.”
Formula	`=IF(B2>=80, "Pass", "Fail")`
Why it works	It returns one value if a condition is TRUE and another if it is FALSE.
When to use	Decision formulas such as pass or fail, yes or no, and on track or off track.

For more than two outcomes, see our guide to IF statements with AND and OR.

5. SUMIF: "Add the Sales for the North Region"

SUMIF totals one group without filtering or sorting.

Boss says	“Add the sales (column C) for the North region (column A).”
Formula	`=SUMIF(A2:A20, "North", C2:C20)`
Why it works	It adds up the numbers that meet a single condition.
When to use	Region totals, category-specific sums, or conditional budgets.

Need two conditions, such as North and a specific month? Use SUMIFS, which accepts as many condition pairs as you need.

6. COUNTIF: "How Many Times Are We Over 100?"

COUNTIF counts how often something happens.

Boss says	“How many times do we have more than 100 (column B)?”
Formula	`=COUNTIF(B2:B20, ">100")`
Why it works	It counts the cells that meet a single condition.
When to use	Tracking thresholds, quality checks, or performance counts.

7. FILTER: "Show Me All of the North Results"

FILTER returns a live, filtered copy of your data.

Boss says	“Show me all of the North results.”
Formula	`=FILTER(A2:C20, B2:B20="North", "No results")`
Why it works	It returns only the rows that match your criteria, and shows "No results" if none do.
When to use	Quick filtered reports without deleting or moving data, in Excel for Microsoft 365 and Excel for the web.

Leave empty space below and to the right of the formula, because the results spill into as many cells as they need.

8. TEXTJOIN: "Combine the Names in One Cell With Commas"

TEXTJOIN builds a list out of many cells.

Boss says	“I want names combined in one column with a comma between.”
Formula	`=TEXTJOIN(", ", TRUE, A2:A5)`
Why it works	It combines multiple cells into one with the separator you choose, and TRUE skips blank cells.
When to use	Creating lists from multiple entries, like names, categories, or tags.

9. PROPER: "Capitalize the Company Name"

PROPER fixes inconsistent capitalization in one step.

Boss says	“Capitalize the company name ‘hello world’.”
Formula	`=PROPER("hello world")`
Why it works	It capitalizes the first letter of each word in a text string, returning "Hello World."
When to use	Cleaning up inconsistent data entry in names, addresses, or titles.

In practice, point it at a cell, such as =PROPER(A2), and fill it down the column.

10. SUM: "Add Up All the Totals for Me"

SUM is the simplest and most-used formula in Excel.

Boss says	“Add up all the totals for me.”
Formula	`=SUM(C2:C20)`
Why it works	It adds up all the numbers in a range.
When to use	Budgets, totals, or any time you need a quick sum.

Select the cell below a column of numbers and press Alt + = to insert it automatically.

Free Boss Question Answer Builder

Practice all ten before the next time your boss leans over your desk. The builder below uses a small sales table with product IDs, regions, sales, scores, and rep names.

Change the product ID, region, sales threshold, or passing score, and every question rewrites itself with the exact formula and the answer from the sample data. For product 101, the rep is jane smith, sales are 1,200, and a score of 85 passes. North sales add up to 3,620, and four products sold more than 1,000.

Copy it to Excel and paste it in cell A1 of a blank sheet to get the data and all ten formulas running live. The FILTER formula is last so its results have room to spill. Print it as a desk reference.

Boss Question Answer Builder

Change the product ID, region, sales threshold, and passing score, and every boss question below updates with the exact formula and the answer from the sample data. Copy it to Excel to get the sample data and all ten formulas running live, ready to swap in your own data. Nothing you enter is saved or sent anywhere.

Product ID

Region

Sales threshold

Passing score

Sample data (cells A1 to E9)

Boss questions, formulas, and answers

Answering Boss Questions in Excel With Confidence

Memorizing these 10 formulas will help you answer most of your boss’s quick questions without breaking a sweat. Start with SUM, IF, and one lookup, then add SUMIF, COUNTIF, and FILTER as you get comfortable.

For a printable list of more formulas, see our Excel formulas cheat sheet. And when the questions start coming faster than the spreadsheets can keep up, Updoot is business management software for $5 per user per month with live dashboards, so the answers are already on screen.

Get All Templates Free

Opens in Google Drive. View and download for free.

Frequently Asked Questions About Answering Boss Questions in Excel

What Excel formulas should every employee know?

SUM, IF, VLOOKUP or XLOOKUP, INDEX and MATCH, SUMIF, COUNTIF, FILTER, TEXTJOIN, and PROPER answer most everyday questions from managers.

What is the difference between VLOOKUP and XLOOKUP?

VLOOKUP only looks to the right and uses a column number, which breaks if columns move. XLOOKUP points to separate lookup and return ranges, looks in any direction, and can show a custom message when nothing is found.

When should I use INDEX and MATCH instead of VLOOKUP?

Use INDEX and MATCH when you need to look to the left, when columns might be inserted, or when you work in an older version of Excel without XLOOKUP.

How do I total sales for one region in Excel?

Use SUMIF, such as =SUMIF(A2:A20,"North",C2:C20). For more than one condition, use SUMIFS.

How do I count cells over a number in Excel?

Use COUNTIF with a comparison in quotes, such as =COUNTIF(B2:B20,">100").

Why does my FILTER formula show #SPILL!?

Something is in the cells where the results need to go. Clear the space below and to the right of the formula.

How do I combine names into one cell with commas?

Use =TEXTJOIN(", ",TRUE,A2:A5). The TRUE skips blank cells.