Lecture notes for the Introduction to Computers by James Tam Return to the course web page

Sample Exam Questions: MS-Excel

Choose the answer that best answers each question.

  1. Which of the following is the proper way to use the COUNTIF function?
    1. Start of the range, end of the range, criteria to be counted
    2. End of the range, start of the range, criteria to be counted
    3. Criteria to be counted, start of the range, end of the range
    4. Criteria to be counted, end of the range, start of the range
    5. Start of the range, criteria to be counted, end of the ranges

 

Answers to the above questions