Advanced Spreadsheet Skills

1.A program designed to create spreadsheets which can later be used to analyzed statistical data

• Microsoft Excel

• Microsoft Word

• Microsoft Publisher

• Microsoft Powerpoint

2. A number format that puts a dollar symbol before each value by default.

• Percent

• Accounting

• Comma

• Date/Time

3. A function that adds a range of cells

• ADD

• PLUS

• SUM

• TOTAL

4. This is the tab in the format cells dialog box where you can change the orientation of a text.

• Alignment

• Orientation

• File

• View

5. A function that gets the average of a range of cells

• AVERAGE

• SUM

• MEAN

• MEDIAN

6. Which among the following is not part of the syntax for AVERAGEIF

• Average Range

• Range

• Logical Test

• Criteria

7. A function used to count the number of cells that contains something in them if the criteria are met

• COUNT

• COUNT NOW

• COUNTING

• COUNTIF

8. A function used to add a certain range of cells if a condition is met

• SUMIF

• ADDIF

• TOTALIF

• PLUSIF

9. The shortcut key for the Format Cells dialog box

• Ctrl + F

• Shift + F

• Ctrl + 1

• Alt + 1

10. A syntax in the AVERAGEIF function that includes the value or label that determines if the cell is part of the range to be averaged

• Range

• Criteria

• Average Range

• Logical Test