ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 101 - TDA-C01 discussion

Report
Export

DRAG DROP

In a worksheet, you have a calculated column named YTD Sales that uses the following formula.

[Order Date] <= TODAY () AND DATETBUNC {''year'', [Order Dace]) = DATETPUNC)'year', TODAY(J)

You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.

How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)


Question 101
Correct answer: Question 101
asked 23/09/2024
Avinash Kumar
32 questions
User
0 comments
Sorted by

Leave a comment first