1. (a) Make a pivot chart with table and show me Energy Incorporated by considering Invoice Number, Customer, Description, and Sales Amount.

(b) What is conditional formatting? Write briefly in excel. Use the question 1(a) data for showing the example of conditional formatting.

These 2 questions are from MSC142 (Visual Programming For Business) course. This is a course on Microsoft excel. Kindly solve these 2 question on Microsoft excel and show me your workings step by step. You can solve it on Microsoft Excel and click picture and send me step by step. I am giving you the data below. Kindly work with these data. If you have any question kindly knock me and then solve the question. Take yourTime. Thanks.

Data:

	Invoice Number	Invoice Date	Customer	Description	Sales Amount	Tax Code	Bank Code	Account Code
	INV0051	41061	DF Manufacturing	Stock Sales	8000	A	B1	IS-100
	INV0052	41061	CC Supplies	Stock Sales	15000	A	B1	IS-100
	INV0053	41064	IT Solutions	Stock Sales	11200	E	B1	IS-100
	INV0054	41064	IQ Bonds	Stock Sales	10200	A	B1	IS-100
	INV0055	41064	WC Financial Advisors	Stock Sales	17000	A	B1	IS-100
	INV0056	41065	DF Manufacturing	Stock Sales	17420	A	B1	IS-100
	INV0057	41065	GP Accountants	Stock Sales	3000	A	B1	IS-100
	INV0058	41068	Energy Incorporated	Stock Sales	8230	A	B1	IS-100
	INV0059	41068	Energy Incorporated	Stock Sales	22800	A	B1	IS-100
	INV0060	41069	CC Supplies	Stock Sales	19050	A	B1	IS-100
	INV0061	41069	DF Manufacturing	Stock Sales	34000	A	B1	IS-100
	INV0062	41069	WC Financial Advisors	Stock Sales	12540	A	B1	IS-100
	INV0063	41071	PTY Consultants	Stock Sales	18000	A	B1	IS-100
	INV0064	41072	WW Retail	Stock Sales	15200	A	B1	IS-100
	INV0065	41072	EC Estate Agents	Stock Sales	14000	A	B1	IS-100
	INV0066	41072	The Paint Shop	Stock Sales	12970	A	B1	IS-100
	CN00018	41073	IT Solutions	Stock Sales	-3100	E	B1	IS-100
	INV0067	41073	Energy Incorporated	Stock Sales	28000	A	B1	IS-100