Formulas, Functions and Formulas
Task Objectives
Apply a theme
Apply the Percentage number format
Change a column width to an exact value
Format a column using Autofit
Change the fill color of a cell
Change the font size of cell contents
Change the page orientation
Create a formula using arithmetic operators
Create a formula using order of operations
Create a formula using the AVERAGE, MAX, MIN and SUM functions
Create a new conditional formatting rule
Add a border to cells
Apply the Currency number format
Apply the Date number format
Change a row height to an approximate value
Change the number of displayed decimals places
Check spelling
Change worksheet margins
Use the keyboard to enter a formula that uses a function
Use Flash Fill
Create a formula using relative cell references
Use the Fill Handle to copy a formula
Print a section of a worksheet
Enter text in a header
Enter a formula by selecting cells
Scale a worksheet for printing
Vocabulary
Accounting Style
Arithmetic Operator
AutoComplete
AutoFit
AVERAGE Function
Cell Boundary
Circular Reference (Indirect and Direct)
Column
Comma Style
Conditional Formatting
Currency Style
Fill Handle
Footer
Formula
Function
Header
Margins
MAX Function
MIN Function
Nonadjacent Range
Normal View
Order of Operations
Page Break View
Page Layout View
Page Orientation
Percentage Style
Pixel
Point Mode
Print Area
Range
Range Finder
Relative Cell Reference
Row
SUM Function
Theme