This is the frst Excal Assignment. It is recommended that you waich the Excel Basics Wideo frat. Here are the instuctions:

First you must start with a blonk espel file.

We are creating a purchase order for a compary. in celAs, yoy must type in Purchase Order. This is the stle of the table.

Row hwo will contain the hendings for our table. The corumn names are as followk: Name, Quertioy. Frice, Coot and Tax. Thus, you shackd hare $5$ columns.

Under the Narme column, you wol put the folowing nemes; Proiter Peser $(1000$ sheets per pack$).$ Copier Toner. Printer link, Colored Pena $(10$ back$).$ Folders, Dy Erase Markers $(20$ pack$),$ Dry Erase Board

Under the Quamsty Colamn, you pue the following: $10,3,2,4,4,8,4.$ That is$,$ the cemppany is purchaning $10$ packs of Printer Paper $(1000$ s'enets per pack$).3$ packs of Coper Toner, wo

Under the Price column you should enter the folowing: $$8$$$99,530\mathrm{.}00,$$$15\mathrm{.}00,$$$7,99,52\mathrm{.}89,$$$20\mathrm{.}00,$$$400\mathrm{.}00($for example, this means that the company has perchased $4$ Dry Erine Bcards at $5400\mathrm{.}00$ eachl.

The columns for Cost and Tax wil require you to enter formulas. In the Cool column, you must creare a formuls that camputes the cont for the purchase of each individual ilem $($far iecemple, the cost of Copier Toner would Een $$90\mathrm{.}00).$ The Tax colums contains the sales lax for each purchase, corpured al a $5\%$ rase $($Eo$,$ a purctase of $$10$ would hive an added $$0\mathrm{.}50$ sales tar$)$

Next, you need so skip the next row and go is what should be row $11.$ In the first column of row $11,$ enler Tosal. Then, in each of the comesponding columra, you wil sum the astries of the corresporcing colimns together using functons wihin Ercal to pertorm this sum.

Ther, in cal D$12.$ type in ToLal Cost, and then in column E$12$ use a formula to compute the total cost of the order $($ this is cost plus sales tax:

Finishing Touches:

Make sure the the of the Labie is cantered are the columns $($see Ercel Basics Video$).$

Make sure every column is wide anough lo show the entios of every column, but no wider $($see Excel Basics Video$)$

Make sure whenever an enty should be in dolers, that the ertres are formatled as corrency $($make sure to use US dollars$).$

Lassyy. answer the frilowing quastion in cell GI$5$; In step $8$ you were asked to compute to sums of the columns for Quaraty. Price, Cost, and

Excel Assignmant $1$