0 of 8 Questions completed
Questions:
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:
0 of 8 Questions answered correctly
Your time:
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)
Which function checks whether a condition is met and returns one value if true and another value if false?
What are the three wildcards available in Excel?
Which function returns the difference between two dates?
Which two arguments are required when using the EDATE function?
Which function is useful for converting miles into kilometers, Fahrenheit into Celsius, or gallons into liters?
Which function is useful when you need the position of an item in a range instead of the item itself?
If the match type is zero, MATCH finds the first value that is exactly equal to the lookup_value.
Which of the following represents the SUMPRODUCT formula?