00 PRACTICE EXERCISE MULTIPLE CHOICE DIRECTIONS: Read each question carefully and identify the word or group of words that contoon the best answer. Select from the given choices after each question and WRITE THE LETTER OF YOUR ANSWER AT THE SPACE PROVIDED. 1. It is a program designed to create spreadsheets which can later be used to analyze statistical data. A. Microsoft Excel C. Microsoft Publisher B. Microsoft Word D. Microsoft PowerPoint 2. It is a number format that puts a dollar symbol before each value. A. Percent B. Accounting C. Comma D. Date/Time 3. What is a function that adds a range of cells? A. ADD B. PLUS C. SUM D. TOTAL 4. This is the tab in the Format Cells dialog box where you can change the orientation of the text. A. Alignment B. Orientation C. File D. View 5. A function that gets the average of a range of cells. A. Average B. SUM C. MEAN D. MEDIAN 6. Which among the following is not part of the syntax of AVERAGEIF? A. Average Range B. Range C. Logical Test D. Criteria 13
