Question

1. Create a pivot table that shows all the invoices that are less than $60. Answer the following three questions and type your answers in cells A19, A20 and A21 respectively:
   1. [3 points] Which vendors had invoices less than $60?
   2. [3 points] How many invoices less than $60 each of the above vendor had?
   3. [3 points] What was the total amount (the grand total) of invoices less than $60 from all of these vendors?

Invoice. Vendor. Amount Date recieved paid

10054	Aligni	$60	2/16/17	no
10102	Trilogy	$58	4/3/17	no
10115	Aligni	$56	4/13/17	no
10117	Aligni	$59	4/16/17	no
10158	SPI	$59	5/27/17	no

Answer 1

Ans a) From the given pivot table Trilogy, Aligni and SPI are three vendors which had invoices less than $60.

Row Labels	Max of Amount
Aligni	59
SPI	59
Trilogy	58
Grand Total	59

Asn b) Trilogy has one invoice, Aligni has 2 invoices and SPI has 1 invoice less than $60

Row Labels	Count of Vendor
Aligni	2
SPI	1
Trilogy	1
Grand Total	4

Asn c) total amount (the grand total) of invoices less than $60 from all of these vendors = $58 + $56 + $59 + $59

= $232

Row Labels	Sum of Amount
10102	58
10115	56
10117	59
10158	59
Grand Total	232