Let’s say you have a table containing expenses for each quarter ... showing you what to select and where the AutoSum button is located. This is an excellent, time-saving feature if you need to add up ...

Scatter charts use two columns of data for each point. By default, Excel ... line chart, add additional numbers in cells below your existing data. Right-click the chart, choose "Select Data ...

Microsoft Excel's CHOOSECOLS ... cell B9 to select a valid game number, safe in the knowledge that even if you add extra columns to your table, CHOOSECOLS and the named range in data validation ...

Quickly add a blank row between multiple rows of data ... value 2. Select the values 1 and 2 (cells F2:F3 above) and double-click the fill handle. Excel will auto-fill the cells in column F.

Sorts are a simple task in Microsoft Excel ... data set is simple on purpose so you can easily discern the different groups as a result of the multiple column sorts. For each group, simply add ...