Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...

A data set that occurs frequently consists of the values or the percentage breakdown of several categories for two time periods. A common way of plotting these data is to use a pair of pie charts.