Crowdly

Add to Chrome

Universities
moodle.essec.fr
Excel Avance IDSI31138 (202504-42)

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!

How to find the number of workdays remaining in the current week?

7-WEEKDAY(TODAY())

NETWORKDAYS(TODAY(), TODAY()+7-WEEKDAY(TODAY()))

DAYS(TODAY()+7-WEEKDAY(TODAY()),TODAY())

View this question

Today if it is a workday or the next workday

WORKDAY(TODAY(),0)

WORKDAY(TODAY(),0,TODAY())

WORKDAY(TODAY()-1,1)

View this question

What is the result of this formula?=SORTBY({"a","b","c","d"},{3,4,2,1},-1)

{"d","c","a","b"}

{"b","a","c","d"}

{"a","b","c","d"}

{"c","d","b","a"}

View this question

What does this formula return?

=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))

One date for each week of the year

A list of leap years

A list of weekend dates for the year

A sum of values by week

View this question

Which formula will return the part of the year remaining?

YEARFRAC(DATE(YEAR(TODAY()),1,1),TODAY())

YEARFRAC(DATE(YEAR(NOW()),1,1),NOW())

YEARFRAC(NOW(),DATE(YEAR(NOW()),12,31))

View this question

Which formula will not return the first day of the current month?

DATE(YEAR(TODAY()),MONTH(TODAY()),1)

EOMONTH(TODAY(),-1)+1

TODAY()-DAY(TODAY())

View this question

What is the type of error that happens when a dynamic array collide with an other value?

View this question

What is the first day of the week in the WEEKDAY function?

View this question

What is the first date in Excel?

1st of January 2000

0th of January 1900

0th of January 0000

1st of January 1990

View this question

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))

An invoice with a customer name starting with x and in region east and not from April

An invoice with a customer name starting with x or in region east or not from April

A list of all invoices with a customer name starting with x and in region east and not from April

A list of all invoices with a customer name starting with x or in region east or not from April

View this question

1
2
3
4
Next

Want instant access to all verified answers on moodle.essec.fr?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us

Add to Chrome

Add to Chrome