Excel has hundreds of key terms, and some are more intuitive than ... such as a translation or a calendar add-in. Array: A set of data within a range of cells. For example, if cells A1 to A20 ...

If you record daily sales data in Excel, it may be impossible to explain variances from day to day. Instead, it may make more sense to summarize the data by week to spot trends and explain variations.