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 |