# 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
 Computer Education HomeProduct InfoSite MapContact Us

 Please read our Terms of Use and Privacy Notice before you explore our Web site. To report a technical problem with this Web site, please contact the Web Producer.