What is the purpose of Excel's Data Table functionality?

• A. To analyze different scenarios by generating outputs based on varying input values.
• B. To store historical data for archival.
• C. To format worksheets.
• D. To lock cells from editing.

Answer: (A)

Excel's Data Table lets you explore how changing input values affects the results of a formula. It automates recalculations across many input values and presents the corresponding outputs in a grid, so you can compare different scenarios quickly. You can use a one-variable data table to see how a single input (like interest rate) changes the output (such as payment), or a two-variable data table to examine how two inputs (for example rate and term) influence the result at once. This makes it a powerful tool for sensitivity or scenario analysis without manually editing inputs each time. The other options describe storing data, formatting, or protecting cells, which are not what-data tables are designed to do.