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