Crowdly
Add to Chrome
Excel Avance IDSI31138 (202504-42)
Looking for Excel Avance IDSI31138 (202504-42) test answers and solutions? Browse our comprehensive collection of verified answers for Excel Avance IDSI31138 (202504-42) at moodle.essec.fr.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
What is the result of this formula?=SORTBY({"a","b","c","d"},{3,4,2,1},-1)
=FILTER(
SEQUENCE(365;1;DATE(YEAR(TODAY());1;1));
WEEKNUM(SEQUENCE(365;1;DATE(YEAR(TODAY());1;1)))<>WEEKNUM(SEQUENCE(365;1;DATE(YEAR(TODAY());1;1))+1))
Supposing that Invoice is a table containg detailed information about invoices, what does this formula return?
=FILTER(Invoices,(LEFT(Invoices[customer])="x")*(Invoices[region]="east")*NOT(MONTH(Invoices[date])=4))
What function should you use if you want to get Selected if at least one condition is met?
=IF(???(B2="South",C2>100),"Selected","Rejected")