$
\
*
A report
An advanced filter
A filter
Vlookup
True
False
The result will return an exact match
The result will return the nearest match
It will return a negative
None of the above
1
2
3
4
1
2
3
4
True
False
True
False
Figures which switch between varying amounts
A conditional format
A macro
An IF statement
True
False
True
False
Cell style
Fill handle or Autofill
Page layout
Find
Replace
Merge and Center
Align
Freeze columns
Indent
Split
Mixed reference
Absolute reference
Relative reference
Additional reference
Money reference
Addition
Subtraction
Division
Percentage
Multiplication
Landscape
Portrait
Form
Demonstration
Template
Cell styles
Page Layout
Tools
Format
F4
F2 or double-click cell
Find and replace
Tools, Columns, Styles
Data bars, Color scales, Icon sets
Cell styles, Bold, Italics
Home, Edit, Fill
Shapes, Arrows, Clip art
Average()
Count()
Mean()
SumIF()
Round
Min()
Avg()
Max()
Most()
Sum()
NOT function
False function
Nper function
Sum function
PMT function
Conditional
Argument
Nested
Double
Hyperlink
Adds another argument
Displays a website
Formats worksheet
Hides worksheets
Now()
Days()
DDYYMM
TODAY()