Excel
All Top 50 Excel & Business Modeling Questions#24
Formatting Dates and Financial Numbers Dynamically Using the TEXT Function
EasyMorgan StanleyInterview Question #24
Asked at Morgan StanleyIn cell `A2` you have the date `2026-09-04`, and in `B2` you have the revenue `1452000`. In cell `C2`, generate an executive summary sentence reading: 'As of Sep 2026, total revenue reached $1.45M.' using the TEXT function.
Input Table: InputData (A1:B2)
1 rows preview| Report Date (Col A) | Revenue (Col B) |
|---|---|
| 2026-09-04 | 1452000 |
Expected Output Structure1 rows
| Executive Narrative (Col C) |
|---|
| As of Sep 2026, total revenue reached $1.45M. |
Interview Context
Asked frequently in data analyst and business analyst technical rounds. Focus on clean filtering, optimal indexing usage, and unambiguous column selection.
Microsoft Excel 365
E2fx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Report Date (Col A) | Revenue (Col B) | ||||
| 2 | 2026-09-04 | 1452000 | Target [Enter Formula] | |||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 |
Click on target cell E2 and enter your formula above.Shortcut: Click "Load Solution" to inspect