Business Info Management (BIM) Review

Z to A order, largest to smallest

Displays records meeting specific criteria. Can NOT save

Lets you organize, summarize, and print all or a portion of the data in a database

Arranging a list of items in a specific order

A row

A column

Horizontal and identified by numbers

Vertical are for data that is identified by a letter across a spreadsheet grid

Words or phrases that identify parts of a chart

Designates the horizontal scale in a chart

Represents the vertical scale in a chart

A section of a pie in a pie chart

Lines of references in a chart or graph

Similar to a bar chart except the bars are replaced by points connected by a line

Short descriptions of the items, units, or scale represented on the axes

Shows the relationship of a part to a whole by dividing a circle into several "slices"

Referred to as a vertical bar chart

List that identifies patterns or symbols used in a spreadsheet

Graphical representation of data contained in a spreadsheet. May be referred to as a graph

Uses rectangles of varying heights to illustrate values in a spreadsheet

Bar chart in which each bar is divided into segments

Intersection of the rows and columns

The page is upright (longer)

The page is sideways (wider)

Special Formulas that do not use mathematical operations

Lines that you can insert above, below, or in the sides of cells

Inserts color behind the characters in a cell

Keeps rows or column titles on the screen no matter where you scroll

Places data in a specific order

Columns that determine how data will be stored

The area of the spreadsheet to be sorted

Determines the number of cells with entered data in a range

Locates the smallest number in a range of cells

Locates the largest number in a range of cells

Will calculate a total for a range of cells

Will calculate the average for a range of cells