Unformatted text preview: 5. It sums the annual salaries of all full-time employees 6. It counts the number of employees earning more than $100,000 7. False, this requires two conditions. The COUNTIF can only have one condition. 8. False, the duplicate values conditional format highlights duplicates it does not delete them....
View Full Document
- Spring '14
- Salary, Personal name, conditional formatting rules, Marques Chandler, $100,000 7