Excel - Ch 4 Flashcards
The process of keeping rows/columns visible on screen at all times
Freezing
Freezes columns & rows to right/bottom of active cell
Freeze Panes
Freezes top row
Freeze Top Row
Freezes first column
Freeze First Column
Indicates where data will start on another printed page
Page Break
Indicates where automatic page breaks will occur
Blue Dashed Lines
Indicates where manual page breaks have been inserted
Solid Blue Lines
Range of cells that will print (can be set); use this function to print titles on every page
Print Area
Sequence in which pages are printed; default is top-left section, bottom-left section, top-right section, bottom-right section
Print Order
Structured range that contains refined data organized in a method that increases the capacity to manage
Table
The organization method used to manage multiple data points within a data set (names, grades, contact info, etc.)
Data Structure
Individual piece of data (such as names); each should represent the smallest possible unit of data (First & Last names separated); enables you to manipulate data in a variety of ways for output
Field
A collection of related data about one entity (represented across full row in a table)
Record
Control fill colour of header row & rows of records; can change to certain colour schemes
Table Styles
Displays header row (field names) when checked
Header Row
