The following tests your answers for the tutorial for the week: Please compl...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
The following tests your answers for the tutorial for the week:
Please complete the complex criteria per question below by entering the missing formula, or part of a formula.
a.1.
|
== |
a.2.
|
== |
a.3.
|
=(D4=,E4=) |
a.4.
|
=(D4=,D4=) |
a.5.
|
=(E4="fast printers",(D4="tax",D4=)) |
a.6.
|
=(F4>=50,F4,E4="butterworths",(D4=,D4="acc")) |
The following question refers to the extra filter exercises that you received in this lesson.
This is the correct simplex criteria for Question 2 (from extra examples):
LANGUAGE | TYPE | |
Afrikaans | Book | >2000 |
English | Book | >2000 |
Japanese | Book | >2000 |
Afrikaans | DVD | >2000 |
English | DVD | >2000 |
Japanese | DVD | >2000 |
Complete the complex criteria formula below that will generate the same output as the above simplex criteria.
|
=AND((I2="afrikaans",,I2="english"),(G2="book",),D2>) |
Want instant access to all verified answers on emslearn.sun.ac.za?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!