QUESTION $1$

Use the data given below to answer the following question$($s$).$

Below is a spreadsheet of purchase orders for a computer hardware retailer.

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$,$H$],[1,\backslash$table$[[$Purchase$],[$Orders$]],,,,,,,],[2,,,,,,,,],[3,$Supplier,$\backslash$table$[[$Item$],[$Description$]],\backslash$table$[[$Item$],[$Cost$]],$Quantity,$\backslash$table$[[$Cost$],[$per$],[$Order$]],\backslash$table$[[$A$/$P Terms$],[($Months$)]],\backslash$table$[[$Order$],[$No$.]],\backslash$table$[[$Order$],[$Size$]]],[4,\backslash$table$[[$Rex$],[$Technologies$]],$Graphics Card,$$89,35,$$$3115,20,$AL$123,$Large$],[\backslash$table$[[5]],\backslash$table$[[$Rex$],[$Technologies$]],$Monitor,$$150,15,$$$2250,25,$AL$234,$Small$],[6,\backslash$table$[[$Rex$],[$Technologies$]],$Keyboard,$$15,40,$$$600,15,$AL$345,$Large$],[7,\backslash$table$[[$Rex$],[$Technologies$]],$Speakers,$$15,20,$$$300,25,$AL$456,$Small$],[8,\backslash$table$[[$Max$\text{'}$s$],[$Wavetech$]],$HD Cables,$$5,10,$$$50,25,$KO$876,$Small$],[9,\backslash$table$[[$Max$\text{'}$s$],[$Wavetech$]],$Processor,$$278,27,$$$6950,30,$KO$765,$Large$],[10,\backslash$table$[[$Max$\text{'}$s$],[$Wavetech$]],$Hard disk,$$120,18,$$$2160,20,$KO$654,$Small$],[11,,,,,,,,],[12,,,,,,,,]]$

To find the number of orders with A$/$P terms less than $25$ months, what Excel formula should be used in A$12?$

$=$AVERAGE$($F$4$:F$10,"<mn\; id="EditorElement\_36048">2</mn><mn\; id="EditorElement\_36049">5</mn><mi\; id="EditorElement\_36050">"</mi><mi\; id="EditorElement\_36051">)</mi>$

$=$ COUNT$($F$4$:F$10,25)$

$=$ COUNTIF$($F$4$:F$10,"<mn\; id="EditorElement\_35838">2</mn><mn\; id="EditorElement\_35839">5</mn><mi\; id="EditorElement\_35840">"</mi><mi\; id="EditorElement\_35841">)</mi>$

$=$ COUNTIF$($F$4$:F$10,$F$5)$