1) Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition. A conditional format that displays a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells. The process of listing records or text in a specific sequence, such as alphabetically by last name. The process of specifying conditions to display only those records that meet those conditions. A set of rules that applies specific formatting to highlight or emphasize cells that meet specifications. A group of related fields representing one entity, such as data for one person, place, event, or concept. The rules that control the fill color of the header row, columns, and records in a table. An indication of where data will start on another printed page. A table row that appears below the last row of records in an Excel table and displays summary or aggregate statistics, such as a sum or an avera A conditional format that displays a particular color based on the relative value of the cell contents to the other selected cells. The sequence in which the pages are printed. A tag or use of a table element, such as a field label, as a reference in a formula. Symbols or signs that classify data into three, four, or five categories, based on the values in a range. The range of cells within a worksheet that will print. A predefined formula that calculates an aggregate value, such as totals, for values in a range, a table, or a database. An individual piece of data in a table, such as first name, last name, address, and phone number. A structure that organizes data in a series of records (rows), with each record made up of a number of fields (columns). The process of keeping rows andlor columns visible onscreen at all times, even when you scroll through a large dataset. The organization method used to manage multiple data points within a dataset. The use of headings without row references in a structured formula. A structured formula that includes references for table name