# iCheck™ Series Microsoft® Office 2007 Real World Applications

## Lesson 2: Advanced Data Analysis

### Self Checks

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

 1 A ____ is based on the data contained in a PivotTable. A) database function B) What-If Analysis C) LOOKUP table D) PivotChart 2 To replace every occurrence of the word "First" with the word "Last," use the ____ function. A) SUBSTITUTE B) What-If Analysis C) PROPER D) LOOKUP 3 What is a scenario? A) A formula that acts on only those items that meet certain specifications. B) A version of a worksheet designed to test one of a number of possible outcomes. C) A word or words that represent one cell or a range of cells. D) A limit that is set. 4 If you want to modify text so that only the first letter is capitalized, use the ____ function. A) UPPER B) LOWER C) PROPER D) SUBSTITUTE 5 Given the following dialog box, how will the Solver find a solution? (49.0K) A) By increasing the value in cell F9. B) By decreasing the value in cell F9. C) By multiply A9 by F9. D) By altering the value in cell A9. 6 When using ____, a statement is either true or false. A) conditional logic B) a database function C) a What-If Analysis D) a LOOKUP function 7 In which of the situations listed here would the following test be true? =AND(B3>=0.8, C3 = 1) A) B3 = 0.8; C3 = 2 B) B3 = 0.7; C3 = 0 C) B3 = 0.7; C3 = 1 D) B3 = 0.9; C3 = 1 8 To create a PivotChart, choose ____. A) Data>Data Tools>PivotChart B) Options>>Tools>PivotChart C) Insert>Tables>PivotChart D) Insert>Charts>PivotChart 9 If you want to determine how many times column M contains a value of zero and column N contains a positive number, use the ____ function. A) SUMIF B) SUMIFS C) COUNTIF D) COUNTIFS 10 The following worksheet contains a ____. (40.0K) A) PivotTable B) scenario C) LOOKUP table D) database function