5 Written Questions
5 Matching Questions
- auto filter
- absolute cell reference
- In Excel, if you restrict cell entries to certain data types and do not enter an Error Alert title or text, the user will not know that an entry is invalid.
- active cell
- What happens to blank cells when data in a worksheet is sorted?
- a False
- b the cell in which you can enter data.
- c a built-in set of filtering capabilities that you can apply to worksheet data
- d They are always placed at the end
- e In a formula, a reference to a specific cell.
5 Multiple Choice Questions
- Tab color
- the value that a function uses to perform operations or calculations
- preset conditional format options
5 True/False Questions
cell → a single media file including art, sound, animation, or movies
chart → a letter, number, punctuation, mark, or symbol
Nonadjacent cells may be selected by using which of the following methods? → False
Patterns may be added as the background for a cell → True
If you sort dates in ascending order, they will be placed in _____. → click the row heading