If statements
What function returns 'Pass' if score >= 60, else 'Fail'?
:=IF(@score>=60, "Pass", "Fail")"
How to find an employee's department using VLOOKUP?
=VLOOKUP("Employee", A2:C10, 2, FALSE)
How do you use Goal Seek to hit a target?
Data > What-If Analysis > Goal Seek - In the Goal Seek dialog box: Set cell: The cell that contains your formula, To value: The goal you want (e.g., 10000), By changing cell: The input cell you want to adjust
How to create a named range?
Formulas > Define Name
What is a circular reference?
A formula that refers to its own cell.
How do you write a nested IF for grades A-F?
"=IF(@score>=90,"A",IF(@score>=80,"B",IF(@score>=70,"C",IF(@score>=60,"D","F"))))"
What does the FALSE parameter do in VLOOKUP?
It forces an exact match.
What tool helps analyze two variables?
Two-variable Data Table
What benefit does a named range provide?
Improves formula readability and reuse.
How do you allow circular references?
File > Options > Formulas > Enable iterative calculation
What function checks two conditions in IF?
"=IF(AND(condition1, condition2), "True", "False")"
How to handle missing values in VLOOKUP?
Not Found
What report shows results from different scenarios?
Scenario Summary Report
How do you reference a named range in a formula - give an example?
"=SUM(SalesData)"
What's the danger of using circular references?
May lead to inaccurate or infinite calculations.
How do you handle errors in IF formula?
"=IFERROR(@formula, "Error")"
What happens if the column index is too large?
You get a #REF! error.
What-If tool allows input adjustment for a formula?
Goal Seek
Can you use a name across multiple sheets?
What is Yes.
How to fix a circular reference?
Change formula logic or remove self-reference.
Who was one of the guest speakers this semester? and what was their company?
Who is Tom Labordo at Paramount? Who is Leah Raber from AirBnb?
How do you use a named range in VLOOKUP?
=VLOOKUP("X", NamedRange, 2, FALSE)
How do you model best/worst case scenarios?
Use Scenario Manager
This Excel feature allows you to assign a custom name to a cell or range of cells, making formulas easier to read and manage.
What is a named range?
Why might someone use a circular reference?
For iterative financial models or forecasts.