Data

Copy and paste the text below. It is read-only. Select All

Chart a visual Representation of selected worksheet data Chart area a chart object that contains all of the chart objects Cell Address In Excel, a column letter followed by a row number that specifies the location of a cell Criteria In Excel, conditions or qualifications that determine whether data is chosen for a filter Chart objects Individual components of a chart, such as the chart MAX Calculates the largest value in the list of arguments SUM In Excel, the function used to calculate the total of the arguments. Sort A command that organizes columns in Excel spreadsheet or a Word Table numerically or alphabetically. MIN Calculates the smallest value in a list of arguments COUNT NUMBERS Counts the number of values in the list of arguments Cell References The address of a cell in an Excel worksheet that defines its location in the worksheet by column AutoFilter arrows In Excel, arrows to the right of each column heading that appear when AutoFilter is selected for a list; click the arrows to open a menu containing options for filtering and sorting the list data. Arguments a value, cell reference, or text used in an Excel function AVERAGE Calculates the average value of the arguments in a list Data marker A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell Data table A grid in a chart that contains the chart's underlying worksheet data, and that is usually placed below the x-axis Functions A prewritten formula you can use instead of typing a formula from scratch Filter A command that displays only the data that you want to see in an Excel Formula auto complete In Excel, a feature that helps you enter a formula in a cell by suggesting a listing Formula builder A tab on the Excel Toolbox that helps users create mathematical calculations