BIS 221 Final Exam Study Guide
Print Title
Excel command that enables you to specify rows and columns to repeat on each printed page
AutoFill
Excel feature that generates and extends values into adjacent cells based on the values of selected cells
Legend
a chart element that identifies the patterns or colors that are assigned to the categories in the chart
Merge and Center
a command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the new cell
Relational Database
a more sophisticated type of database that stored multiple collections of data that are related to one another. example: data about students, the courses, and the faculty members
Table
a series of rows and columns that contain related data
Range
a series of two or more adjacent cells in a column or row or a rectangular group of cells
Referential Integrity
a set of rules that ensures that the data between related tables is valid
Data Bar
a shaded bar that provides a visual cue about the value of a cell relative to other cells
Field
a single piece of information that is stored in every record and represented by a column in a table
Record
a table row that contains all the categories of data pertaining to one person, place, thing, event, or idea
Goal Seek
a tool that finds the percentage you are looking for
Summary Sheet
a worksheet where totals from other worksheets are displayed and summarized
Zoom Dialog Box
allows more working space into which you can type a calculation
Form
an Access object to enter new records into a table, edit or delete existing records in a table, or display existing records
Function
an equation that is predefined by Excel. example: =SUM(A4*A10)
Formula
an equation that we write ourselves. example: =A2+A4+A6
Cell Content
anything typed into a cell
Formula Bar
displays the value or formula contained in the active cell; here you can also enter or edit values or formulas
Relative Cell Reference
in a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to
Sheet Tab
labels along the lower border of the Excel window that identify each worksheet
Absolute Cell Reference
refers to cells by their fixed position in a worksheet; formula remains the same when copied. example: A2 / $B$2
Cascade Options
relationship options that enable you to update records in related tables when referential integrity is enforced
Data Point
represents a certain point on a graph
Data Series
represents all the content on a graph
Flash Fill
the Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output
AutoComplete
the Excel feature, which, after typing = and the first letter of a function, displays a list of function names
Underlying Value
the data that displays in the formula bar
Primary Key
the field that uniquely identifies a record in a table
Cell Reference
the identification of a specific cell by its intersecting column letter and row number
Cell
the intersection of a column and a row
Order of Operations
the mathematical rules for performing multiple calculations within a formula
Report
the object that displays fields and records from a table or query in a printable format
Query
the object that retrieves specific data and then displays only the data that you specify
What-if Analysis
the process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet
Arithmetic Operators
the symbols +, -, *, /, %, and ^ used to denote addition, subtraction, multiplication, division, percentage, and exponentiation in an Excel formula
Join Line
the visual cue in the Relationships window that indicates tables are related by connecting common fields
Field Properties
used to tell Access what information to display - make rules for what information is valid
