In cases where you want to test criteria between a range of values, placing the logical tests in a specific order-either from highest to lowest or lowest to highest-____.
A) can save a considerable amount of work
B) will generate more work
C) will have no bearing on the amount of work
D) is not recommended

Question

Quizplus · Accepted Answer

When logical tests are arranged in a specific order (either lowest to highest or highest to lowest), it can save a considerable amount of work because the formula will stop evaluating as soon as the first true condition is met, avoiding unnecessary calculations. This is commonly known as the "short-circuit" technique.

In Cases Where You Want to Test Criteria Between a Range