Question

Refer to the included Bike Safety Patrol Budget Spreadsheet.Cell B8 contains the number of different products ordered (number of items listed in column A). What formula should be in Cell B8 to accomplish this task? T B C D E F G H I NY tax NJ tax 8.0% 7.0% tax Item Cost $12.00 $23.45 $64.50 quantity 13 10 1 total cost $156.00 $234.50 $64.50 Bike Safety Patrol Budget discount cost with Shipping to amount discount state $15.60 $140.40 NJ $23.45 $211.05 NY $3.23 $61.28 NY $9.83 $16.88 $16.88 $4.90 shipping $0.00 $0.00 $10.00 total $150.23 $227.93 $76.18 Item 4 T-shirts 5 jackets 6 helmets first aid belts Number of different products ordered $24.00 $24.00 $1.20 $22.80 NJ $1.60 $10.00 $34.40 Number shipped to Amount owed: NJ $488.74 =count(A4:A7) 0 =sum(A4:47) =countif(A4:A7,">0") =countA(A4:A7)

Answer 1

Answer is D. =countA(A4:A7)

Option A is to count numeric values.

Option B is to calculate the total value of numeric

Option C is a conditional formula. count the numeric value greater than 0

You can reach me over comment box, if you have any doubts. Please rate this answer