Question 1
Which of the following highlights and color-codes each cell as you type its address?
Formula Auditing
Range Finder
Evaluate Formula
Select Method
Question 2
Which of the following words best describes a Z to A sort?
Ascending
Rising
Descending
Sliding
Question 3
Which of the following commands should you use to lock rows or columns in view so you
can position data for easy review?
Zoom options
Merge & Center command
Status bar view buttons
Freeze Panes command
Question 4
Which of the following is a single value from within a data series?
Gridline
Tick mark