| plotarea | | this object explains the symbols, colors, or patterns used to differentiate the data |
| indent | | this type of chart may be used to immediately reflect up-to-date changes made to a spreadsheet |
| right | | default justification for labels |
| count | | instruct the software to perform calculations |
| xaxis | | the bottom horizontal side of the graph |
| countA | | data that contains numbers that may be used in calculations |
| piechart | | finds how many cells have a value entered |
| center | | used for subcategories |
| orderofoperations | | a horizontal or vertical line that extends across the plot area of a graph |
| embedded | | this function returns one value if a condition you specify evaluates to True and returns another value if the condition evaluates to False |
| spreadsheet | | justification for titles and column headings |
| merge | | indicates the relationship of one component or data element to the whole data series such as the percentage of product sales to total sales |
| yaxis | | used to compare a cell value to an array of cells and return a value that matches the location of the value in the array |
| datamarkers | | analyzing statistical or scientific data to determine a correlation |
| fillseries | | used in a graph to indicate data values |
| columnchart | | all formulas begin with an |
| values | | describes the horizontal data labels |
| lookup | | an enhanced version of the pie chart |
| legends | | makes comparisons and generalizations about groups of data |
| left | | this type of chart appears on the same sheet as the spreadsheet it represents |
| datefunction | | math procedure of calculating formulas used in spreadsheets |
| formulas | | used to fill a column or row with consecutive data such as numerical numbers |
| list | | allows the rows and/or column titles to remain stationary on the screen while you scroll |
| freezingpanes | | describes the vertical data labels |
| linechart | | an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information |
| wraptext | | used to add identifying information to a spreadsheet |
| labels | | used to calculate a 30 day due date for a record of spreadsheet invoices |
| gridline | | compares the contribution of the individual items to the whole |
| iffunction | | used to combine adjacent cells or cell ranges |
| tickmark | | compares trends such as the sales trends of 3 departments over a period of time |
| charttitle | | this chart component is the main heading which describes the purpose and content of the chart |
| yaxistitle | | default justification for values |
| stackedbar | | used in a graph to clarify data categories or values |
| count | | square located at the bottom right of a cell used to create the continuation of a data series when dragged |
| headerfooter | | returns the number of cells in a range that contain numbers |
| equalsign | | used to validate how data is represented on paper before printing |
| explodedpie | | the area bound by the values (y) and the categories (x) axes |
| printpreview | | applied to cells that require more space when a row or column size is adjusted |
| linked | | returns the number of cells in a range that contain any value/label |
| XYscatter | | usually contains the numerical data |
| xaxistitle | | data that contains text, symbols, dates, or numbers not used in calculations |
| fillhandle | | a validated _____ limits data entry to specific choices programmed into the function |
