MENU
You want to show the cumulative total of each year for every state.
Which quick table calculation should you use?
Suggested Answer: B
Get Premium Analytics-DA-201 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
RE
Reid
7 months ago
I feel confident about B too. It’s straightforward for this scenario.
MI
Micah
7 months ago
Exactly! Running Total gives a better view of growth over time.
JA
Jani
7 months ago
I’m torn between B and D. YTD Total is also useful.
SH
Sherell
7 months ago
Agreed! Running Total makes sense for yearly data.
VA
Vallie
8 months ago
I think B) Running Total is the best choice. It shows cumulative totals clearly.
TI
Titus
8 months ago
Not sure about that, but I guess B makes sense.
LE
Lemuel
8 months ago
B) Running Total is the standard for cumulative totals.
JU
Justine
9 months ago
Wait, is YTD Total really the right choice?
GL
Glory
9 months ago
I'm with Johna on this one. B) Running Total is the way to solve this problem.
NI
Nichelle
9 months ago
Haha, C) Year Over Year Growth? What is this, a growth report? B) is the only logical choice.
JO
Johna
9 months ago
A) VTD Growth? Nah, that's not what we need for this. B) is the clear winner.
LO
Lorita
9 months ago
I definitely recall a question similar to this, and I think Running Total was the answer we went with.
EV
Evan
9 months ago
I feel like the YTD Total could also work, but it might not give us the breakdown by state that we need.
MA
Marquetta
10 months ago
I remember practicing with Year Over Year Growth, but that seems more about comparing years rather than showing a cumulative total.
LA
Lajuana
10 months ago
I think we might need to use the Running Total for this, but I'm not entirely sure if that's the best option.
RH
Rhea
10 months ago
I feel confident about this one. The question is asking for the cumulative total, so Running Total is the clear choice. Shouldn't be too hard to implement in the exam.
JE
Jestine
10 months ago
Running Total is definitely the way to go here. That will give me the cumulative totals I need to show the year-over-year trend for each state.
LO
Lou
10 months ago
I'm a bit confused on this one. Is "YTD Total" the same as a running total? Or is that something different? I want to make sure I pick the right answer.
RE
Ressie
10 months ago
I think A) VTD Growth is more relevant here.
JA
Jaleesa
11 months ago
Definitely B) Running Total. That's the way to go!
NO
Novella
11 months ago
B) Running Total is the way to go here. Gotta see that cumulative total for each state!
AN
Annice
11 months ago
D) YTD Total would be my pick. Keeps it simple and straightforward.
AL
Almeta
11 months ago
But YTD Total doesn’t show each year separately, right?
LU
Lucina
11 months ago
Okay, let me think this through. I'm pretty sure the "Running Total" option is what we want here to get the cumulative totals.
EV
Eve
12 months ago
Hmm, this seems like a straightforward question about table calculations. I think the key is to focus on the "cumulative total" part of the question.
KE
Keneth
6 months ago
YTD is for year-to-date, not cumulative across years.
JA
Jaime
6 months ago
What about YTD Total? Isn't that similar?
DI
Diego
6 months ago
I agree, Running Total is the way to go.
JO
Jordan
7 months ago
Yeah, that makes sense for cumulative totals!
VI
Vicki
7 months ago
I believe the answer is B) Running Total.