Consider the spreadsheet below. You are to determine how many products have a unit price that is less than $$50$ and also have a quantity greater than $3.$ Which of the following Excel formulas will give the correct result?

f answer choices

$=$COUNTIFS$($B$2$:B$12,"<50",$C$2$:C$12,">3")$

$=$COUNTIF$($B$2$:B$12,"<50")+$ COUNTIF$($C$2$:C$12,">3")$

$=$COUNTIF$($B$2$:B$12,$AND$("<50",">3"))$

$=$COUNTIF$($B$2$:B$12,"<50")$ AND COUNTIF$($C$2$:C$12,">3")$