Cell references, comparison operators, and array formulas can help analyze large sets of changing data Data Tables can be used for automatically generating multiple possible scenarios.

Arrays also simplify the complexity of huge worksheets, as they let the user autofill and compute multiple calculations simultaneously Businesses need spreadsheets to handle datasets that are updated every minute with information.

Data Table — scenario-building tool in Excel that lets users choose a set of cells on the spreadsheet, and then outputs different solutions or forecasts depending on different scenarios. comparison operators — inequality symbols used in math; includes <, >, ≥ , ≤ , =, and <>. array — selection of rows or columns that do not have to be contiguous. MIN — function that finds the lowest value in a dataset.