Microsoft Excel Questions... 9 pages of questions.

Name ____________________________ Date ___________________

Excel 2010: Chapter 5 – Short Answer

Instructions: Fill in the best answer.

1. A(n) _______________ column is a column in a table in which each row uses a common formula that references other fields in the table.

2. The _______________ function is used when a table direction is horizontal across a worksheet.

3. _______________ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.

4. _______________ columns provide alternating colors every other column.

5. The field or fields you select to sort the records are called _______________.

6. The process of filtering activity based on one or more filter criteria is called a(n) _______________.

7. When copying records that meet a comparison criteria range to another part of a worksheet, the location to where the records are copied is called the _______________.

8. Excel’s _______________ function tells you the relative position of an item in a range or table that matches a specified value in a specified order.

9. The _______________ function returns the value or reference of a cell at the intersection of a particular row and column in a table or range.

10. By utilizing the _______________ features of Excel, you quickly can hide and show detail rows.