A | B |
A graphical representation of worksheet data. | Chart |
The best way to represent data groups that are part of a whole. | Pie Chart |
A good choice for representing trends over a period of time. | Line Chart |
Represented by a circle divided into portions. | Pie Chart |
Arrange All command | Allows you to view multiple workbooks at the same time. |
The lines that establish a relationship between data in a chart. | Axes |
Useful when you want to print a chart next to the data the chart illustrates. | Embedded charts |
Produces a "cloud" of data points not connected by lines. | Scatter chart |
A reference to the same cell or range in multiple worksheets that you use in a formula. | 3-D cell reference |
A collection of worksheets. | workbook |
The sheet that appears on the screen | active sheet |
Appear at the bottom of the workbook window and identify the worksheets withing the workbook. | sheet tabs |
=Sheet!2D10 | Inserts the value in D10 of Sheet2 |
=Sheet3!D10+Sheet3!D11 | Add the values in D10 and D11 of Sheet3 |
sparkline | A mini chart that is inserted within a cell. |
The patterns or symbols that identify the different types of data. | legend |
To rename a chart sheet. | double-click or right-click and rename |