CGS 1519
Final Exam Review
#NAME?	Group edit	Relative v. Absolute
[	Hiding rows/columns	ROUND
AND	Hierarchy of operations	Row heading
Argument--Use of comma, colon	HLOOKUP	Save/Save As
Audit	Hyperlink	Scaling
Auditing Toolbar	IF	Scenarios
AVERAGE	IPMT	Solver
Change print settings in Print Preview	Input cell	Sorting
Charts--embedded, chart sheet	INT	Source range
Clear v. Delete	Internal reference	Spell check
Commands available in open dialog box	Line break	Standard Toolbar
Comment	Linking workbooks	Status bar
Consolidation	Lock/unlock cells	Style
Constraint	Macros	Subtotaling
Copy cell formatting	MAX	Subtype
COUNT	MIN	SUM
Criteria	Move v. Copy	Suppress zeros
Custom formats	Name box	Target range
Custom view	Nested function	Template
Data Form	NOT	Title bar
Data validation	NOW	TODAY
Database	nper	Trendline
DATE	Number formats	Two-variable Table
Dependent worksheet	One-variable Table	type
Docked toolbar	OR	Undo
Drag and drop	Outline levels	VLOOKUP
Dynamic link	Page break	WEEKDAY
External reference	Paste function	Window arrangements
Field	PivotTable	Window freeze panes
Field Name	PMT	Window split
Filter	Point	Workspace
Filtering	PPMT	X axis
Fit to	Print area	Y axis
Floating toolbar	Protect sheet	Zoom
Formatting Toolbar	Protect workbook	#VALUE!
FV	PV	#REF!
GoalSeek	Range names	#DIV/0!
GoTo	rate
Gridlines	Record