IT Assignment

INFORMATION TECHNOLOGY

TABLE OF CONTENTS
TASK 1............................................................................................................................................3

TASK 1
Figure 1: Data View
Figure 2: Formula View
Number of Profit and Loss over the Year
Profit 7 times in a year
Loss 5 times in a year
1

January
February
march
April
May
June
July
August
September
October
November
December
£-
£20,000.00
£40,000.00
£60,000.00
£80,000.00
£100,000.00
£120,000.00
Revenue Before VAT
January
February
march
April
May
June
July
August
September
October
November
December
£-
£10,000.00
£20,000.00
£30,000.00
£40,000.00
£50,000.00
£60,000.00
£70,000.00
£80,000.00
£90,000.00
Revenue After VAT
2