You may use the worksheet (see the attachment)

in the Excel file, use the 5 different Excel functions listed below (you must use all 5):

?Absolute cell referencing and Relative cell referencing

?NestedIF Function i.e. multiple IF functions in the one formula

?VLOOKUP Function

?PivotTable and PivotChart

?Filters and the Subtotal function

When using the functions, make the purpose of their use relevant to the business. As an example of an idea you could do something like the below:

-Forecasted income statement based on different future sale achievements (e.g., poor, moderate, good)

Format your spreadsheet appropriately. You may use colours, styles and fonts of your choice to enhance the readability of your workbook. Formatting is part of the marking.

Country State/Province Actual Predicted Product Produc Your Month Sales Sales Type U. S. A California $726. 0 $509. 00 FURNITURE SOFA 2012 Jan U. S. A California $1, 311. 00 418. 00 FURNITURE SOFA 2012 Feb U. S. A California $24. 00 $12. 00 FURNITURE SOFA 2012 Mar U. S. A California $1, 342. 00 $556. 00 FURNITURE SOF 2012 Apr U. S. A California $552. 00 $532. 00 FURNITURE SOF 2012 May U. S. A California $1, 784. 00 $1, 786. 00 FURNITURE SOFA 2012 Jun . S. A California $1. 317. 00 $1, 655, 00 FURNITURE SOFA 2012 Jul U. S. A California $1, 678. 00 SOFA 2012 Aug U. S. A California $1, 852. 00 $1, 277. 00 FURNITURE SOFA 2012 Sep U. S. A California $1, 056. 0 $1, 594. 00 FURNITURE SOFA 2012 Oct U. S. A California $1, 702. 00 $46. 00 FURNITURE SOFA 2012 Nov U. S. A California $1, 037. 00 $1, 228. 00 FURNITURE SOFA 2012 Dec U. S. A California $1, 923. 90 $222. 20 FURNITURE SOFA 2013 Jan U. S. A California $975. 70 $990. 00 FURNITURE SOF 2013 Feb U. S. A California $973. 50 $949. 30 FURNITURE SOFA 2013 Mar California $566. 50 $902. 00 FURNITURE SOFA 2013 Apr California $1, 456. 40 SOFA 2013 May U. S. A California $848. 10 214. 50 FURNITURE SOFA 2013 Jun U. S. A. California $1, 203. 40 $69. 30 FURNITURE SOFA 2013 Jul U. S. California $1, 933. 80 $674. 30 FURNITURE SOFA 2013 Aug U. S. A California $1, 981. 10 $1, 105. 50 FURNITURE SOFA 2013 Sep U. S. A California $1. 298. 00 $306. 90 FURNITURE SOFA 2013 Oct U. S. A California $1, 560. 90 $13. 20 FURNITURE SOFA 2013 Nov J. S. A California $1. 678. 60 $525. 80 FURNITURE SOFA 2013 Dec U. S. A California $272. 00 $1, 004. 00 FURNITURE BED 2012 Jan California $1, 481. 00 TURE BED 2012 Feb U. S. A California $63. 00 $1, 908. 00 FURNITURE BED 2012 Mar U. S. A. California $1, 981. 00 $1, 032. 00 FURNITURE BED 2012 Apr U. S. A California $1, 481. 00 $520. 00 FURNITURE BED 2012 May U. S. A California $1, 103. 00 $1, 810. 00 FURNITURE BED 2012 Jun U. S. A California $1, 569. 00 $1, 828. 00 FURNITURE BED 2012 Jul U. S. A California $1, 349. 00 $2, 121. 00 FURNITURE BED 2012 Aug U. S. A California $1. 976. 00 $900, 00 FURNITURE BED 2012 Sep U. S. A California $475. 00 $699. 00 FURNITURE BE 2012 Oct California 1. 759. 00 $1, 733. 00 FURNITURE BED 2012 Nov U. S. A California $672. 00 $1, 131. 00 FURNITURE BED 2012 Dec U. S. A. California $719. 40 $1, 958. 00 FURNITURE BED 2013 Jan U. S. A California $201. 30 $694. 10 FURNITURE BED 2013 Feb U. S. A California $1, 290. 30 $1, 541. 10 FURNITURE BED 2013 Mar U. S. A California $1, 026. 30 $1, 052. 70 FURNITURE BED 2013 Apr U. S. A California $2, 035. 00 $1, 905. 20 FURNITURE BED 2013 May J. S. A California $1. 016. 40 $1. 787. 50 FURNITURE BED 2013 Jun U. S. A California $1. 347. 50 $534. 60 FURNITURE BE 2013 Jul U. S. A California $1, 514. 70 $591. 80 FURNITURE BED 2013 Aug U. S. A California $1, 021. 90 $1, 848. 00 FURNITURE BED 2013 Sop U. S. A. California $261. 80 $2, 172. 50 FURNITURE BED 2013 Oct U. S. A California $1, 320. 00 $760. 10 FURNITURE BED 2013 Nov U. S. A California $426. 80 1, 967. 90 FURNITURE BED 2013 Dec U. S. A California $802. 00 $276. 00 OFFICE CHAIR 2012 Jan U. S. A California $1, 582. 00 $754. 00 OFFICE CHAIR 2012 Feb IS. A California $898. 00 $195. 00 OFFICE CHAIR 2012 Mar U. S. A California $1. 008. 00 $1, 679. 00 OFFICE CHAIR 2012 Apr California $1, 873. 00 $1, 416, 00 OFFICE CHAIR 2012 May U. S. A California $813. 00 $1, 389. 00 OFFICE CHAIR 2012 Jun U. S. A. California $1, 454. 00 $446. 00 OFFICE CHAIR 2012 Jul U. S. A California $1, 522. 00 $698. 00 OFFICE CHAIR 2012 Aug U. S. A California $242. 00 $1, 661. 00 OFFICE CHAIR 2012 Sep U. S. A California $1, 312. 00 $1, 673. 00 OFFICE CHAIR 2012 Oct U. S. A California $1, 206. 00 $1, 403. 00 OFFICE CHAIR 2012 Nov .S. A California $258. 00 $108. 00 OFFICE CHAIR 2012 Dec U. S. A California $1. 287. 00 $397. 10 OFFICE CHAIR 2013 Jan California $59. 40 $1, 811. 70 OFFICE CHAIR 2013 Feb U. S. A. California $1, 653. 30 $1, 406. 90 OFFICE CHAIR 2013 Mar U. S. A. California $1, 618. 10 $1, 884. 30 OFFICE CHAIR 2013 Apr U. S. California $135. 30 $2, 215. 40 OFFICE CHAIR 2013 May U. S. A California $11. 00 $2, 105. 40 OFFICE CHAIR 2013 Jun U. S. A California $524. 70 $1, 358. 50 OFFICE CHAIR 2013 Jul U. S. A California $887. 70 $401. 50 OFFICE CHAIR 2013 Aug S. A California $1. 195. 70 $2. 139. 50 OFFICE CHAIR 2013 Sep U. S. A California $2. 059. 20 $152. 90 OFFICE CHAIR 2013 Oct U. S. A California $1, 274. 90 $764. 50 OFFICE CHAIR 2013 Nov U. S. A California $821. 70 $2, 306. 70 OFFICE CHAIR 2013 Dec U. S. A California $610. 00 $1, 788. 00 OFFICE DESK 2012 Jan U. S. California $1, 900. 00 $1, 568. 00 OFFICE DESK 2012 Feb U. S. A. California $1, 634. 00 2, 120. 00 OFFICE DESK 2012 Mar U. S. A California $328. 00 $2, 034. 00 OFFICE DESK 2012 Apr U. S. A California $1, 096. 0 $1, 659. 00 OFFICE DESK 2012 May S. A California $220. 00 $901. 00 OFFICE DESK 2012 Jun U. S. A California $941. 00 1, 574. 00 OFFICE DESK 2012 Jul U. S. A. California 566. 00 $263, 00 OFFICE DESK 2012 Aug U. S. A California $207. 00 2, 051. 00 OFFICE DESK 2012 Sep U. S. A California $1, 582. 00 $551. 00 OFFICE DESK 2012 Oct U. S. A California $976. 00 $1, 285. 00 OFFICE DESK 2012 Nov U. S. A. California $297. 00 $784. 00 OFFICE DESK 2012 Dec U. S. A California $273. 90 $2, 335. 30 OFFICE DESK 2013 Jan U. S. A California $248. 6 $1, 255. 10 OFFICE DESK 2013 Feb U. S. A California $1. 417. 90 $1, 659. 90 OFFICE DESK 2013 Mar U. S. A California $129. 80 899. 80 OFFICE DESK 2013 Apr I. S, A California $2. 190. 10 598. 40 OFFICE DESK 2013 May U. S. A California $2, 016. 30 $2, 249. 50 OFFICE DESK 2013 Jun U. S. A California $502. 70 $1, 986. 60 OFFICE DESK 2013 Jul U. S. A California $1, 648. 90 $1, 266. 10 OFFICE DESK 2013 Aug U. S. A. California $609. 40 1, 133. 00 OFFICE DESK 2013 Sep U. S. A California $2, 114. 20 $656. 70 OFFICE DESK 2013 Oct U. S. A California $2, 033. 90 $1, 042. 80 OFFICE DESK 2013 Nov U. S. A California $1. 158. 30 $1. 333. 20 OFFICE DESK 2013 Dec U. S. A California $1, 090. 00 FURNITURE SOFA 2012 Jan California $1. 365. 00 $962. 00 FURNITURE SOFA 2012 Feb U. S. A California $699. 00 $904. 00 FURNITURE SOFA 2012 Mar U. S. A California $1, 028. 00 $1, 881. 00 FURNITURE SOFA 2012 Apr U. S. A California $870. 00 $965. 00 FURNITURE SOFA 2012 May U. S. A. California $ 157. 00 $1, 111. 00 FURNITURE SOF 2012 Jun U. S. A California $1, 256. 00 $1, 700. 00 FURNITURE SOFA 2012 Jul U. S. A California $167. 00 $2, 055. 00 FURNITURE SOFA 2012 Aug U. S. A California $997. 00 $330. 00 FURNITURE SOFA 2012 Sep U. S. A. California $1. 725. 00 $1, 701. 00 FURNITURE SOFA 2012 Oct