red triangle
- This is a preview of the essay.
To view the full text you must login!
Default date format
Proper syntax for mathematical formulas
Selecting adjacent and non-adjacent ranges
Clearing vs. deleting cells
Inserting rows, cells, columns or worksheets
Deleting, moving or renaming a worksheet
Order of precedence rules page 1.24
Absolute, relative, and mixed references when to use them, how they look, and how to change them
Financial functions page 2.05
Determining number of periods and interest rate for monthly or quarterly payments
Auto Fill page 2.18
IF function and comparison operators page 2.22
Know the proper way to set up an IF function as in case 2-2
Today() vs. Now() (try them out to see how they are different)
Depreciation functions page 2.34
Know all of the tabs and options on the Format Cells window
Merging cells and wrapping text
Hiding and unhiding rows or columns
Find and replace formats or other values
AutoFormat
Conditional Formatting
Creating styles
Page setup, page breaks, margins, headers, footers
Chart types page 4.05
Know what is available on the drawing toolbar
Sort, Filter, Form, Subtotals and Pivot Tables and Charts on the Data menu
Grouping worksheets
Linking workbooks together
Vlookup and hlookup how to set up the functions
Error values page 7.09
Green vs...