# iCheck™ Series Microsoft® Office 2007 Real World Applications

## Lesson 4: Analyze Data

### Self Checks

Self Checks provide you with multiple choice questions you can use to review the main ideas of the lesson.

 1 The arrows in the first row of the worksheet indicate that ____. (212.0K) A) AutoFilter is turned on B) the columns have been sorted C) the IF function is turned on D) the NOW function is turned on 2 A formula must always begin with the ____ sign. A) = B) * C) + D) - 3 How can you edit a formula? A) Choose Data>Data Tools>Edit. B) Key changes in the formula bar. C) Use the AutoSum function. D) Choose Home>Editing>Sort & Filter. 4 Identify the button that you would click to organize the selected column in ascending order. (228.0K) A) A B) B C) C D) D 5 A(n) ____ does not change when you copy a formula to a new location. A) AutoFilter B) mixed reference C) relative reference D) absolute reference 6 The formula in this formula bar contains ____. (57.0K) A) only absolute references B) only relative references C) mixed references D) no references 7 To add a label to a chart's horizontal axis, choose ____. A) Insert>Charts>Column B) Insert>Charts>Labels C) Layout>Labels>Axis Titles D) Layout>Titles>Axis 8 The ____ tab in the Chart Tools lets you change a chart's type. A) Layout B) Format C) Data D) Design 9 The ____ function checks to see if a specific condition is true. A) IF B) NOW C) PMT D) COUNT 10 The ____ function calculates payments for a loan based on interest rate, number of payments, and the amount of the loan. A) IF B) NOW C) PMT D) COUNT