This quiz will test your understanding about Conditional Formulas and Advanced Functions. Please answer the following 5 questions.
Quiz Summary
0 of 5 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 5 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 5
1. Question
What function in Excel allows you to perform calculations based on a specified condition?
CorrectIncorrect -
Question 2 of 5
2. Question
In Excel, what does the COUNTIF function do?
CorrectIncorrect -
Question 3 of 5
3. Question
Which advanced Excel function is used to perform calculations on a range of cells that meet specific criteria?
CorrectIncorrect -
Question 4 of 5
4. Question
What function can you use in Excel to extract a portion of text from a larger text string based on a position and length?
CorrectIncorrect -
Question 5 of 5
5. Question
Which Excel function is used to find the largest value within a range that meets specific criteria?
CorrectIncorrect