Midterm Test $($May $5,19$:$00-$

LE$/$EECS$1520$ M$,$ N$,$ O$,$ P & Q $-$ Computer Use: Fundamentals $($Winter $2023-2024)$

$23$:$00$P Flag questionAssuming all $10000$ entries in column D of a worksheet are integers: which of the following formulas can be used in place of the Excel formula $=$ COUNTIF$($D$2$:D$10001,">=60")-$ COUNTIF$($D$2$:D$10001,">120")?$Select one:$=$ COUNTIFS$($D$2$:D$10001,>=60",$D$2$:D$10001,"<mn>1</mn><mn>2</mn><mn>0</mn><mi>"</mi><mi>)</mi>$none of the other choices is correct$=$ COUNTIFS$($D$2$:D$10001,">=60",$D$2$:D COUNTIFS$($D$2$:D$10001,">=60",$D$2$:D$10001,">120")$