Microsoft Excel Questions... 9 pages of questions.
Jimmy John
excel_2010_chapter_05_tf.docName _________________________ Date ___________
Excel 2010: Chapter 5 – True/False
Instructions: Circle T if the statement is true or F if the statement is false.
|
T |
F |
1. The individual data items that make up a record are called fields. |
|
T |
F |
2. Excel is considered a true database management system. |
|
T |
F |
3. You can hide columns by selecting them and then pressing CTRL+H. |
|
T |
F |
4. The Conditional Formatting Rules Manager dialog box allows you to view all of the rules for the current selection or for an entire worksheet. |
|
T |
F |
5. Excel allows you to sort on a maximum of 100 fields in a single sort operation. |
|
T |
F |
6. The OR operator indicates that both parts of a criteria must be true. |
|
T |
F |
7. If the criteria range contains a blank row, it means that no comparison criteria have been defined. |
|
T |
F |
8. The Index function can search for values in multiple ranges at the same time. |
|
T |
F |
9. The field on which you sort prior to clicking the Subtotal button is called the Record Range Check field. |
|
T |
F |
10. Items that are dimmed are selections or buttons that are unavailable. |
