PRODUCT SALE RECORD
Open Microsoft Excel!Type on spreadsheet "Product Sales Record" and take it on center of the worksheet. For taking on Center ! we will go there , Where we type the heading "Product Sales Record" just take cursor on the side of that cell and drag to the straight and go on Alignment tool. Click on "Merge & Center" then it will be automatically show on Center. For Attractive look!We also change Background Color, Font Face, Font Color and Font Size. first we select the text and click on Background Color and select any color what we want on background, Font Face use for change the text style, Font Color for text color and Font Size for increase or decrease the text size. These all are available on Home Tool.
Microsoft Excel - Advanced Excel Formulas & Functions
In next Row, we type the heading! ITEM CODE, PRODUCT, RATE, QUANTITY, AMOUNT, TAX AND TOTAL. These will show at left side and we want it on Center then Select Heading Row and click on center. This "Center" icon on "Alignment Tool". we are looking our "ITEM CODE" not fit on cell then we will increase the width. Click on cell whose cell we want to increase then go on up where A,B,C,D,E,F.... are written and A plus sign will show. This plus sign just put on that line who we want to increase and click on the line & drag the cell. The width pixel will be increase. here the Image is :
Microsoft Excel - Excel from Beginner to Advanced
We can apply same method for all there. Who we want to increase. After that fill all columns and rows of item code, product, rate, quantity. On Amount! we will apply formula by using "=" sign & first we should know the formula of Amount is (Rate*Quantity). here we type (=D3*C3) because on D3 has Quantity and C3 has Rate values. For Eg:
Microsoft Excel - From Beginner to Expert in 6 Hours
To take easily other Amount values. We take the cursor on the cell and drag to downward. This type! all Amount Value will come.
When we come on TAX. For TAX Formula is (Amount*Tax) {like (=E3*4%)} here we write E3! On E3 has Amount value So we type it then we give multiplication sign and after that 4%. 4% is a rate of tax like we seem that we are imposing 4% tax, so we write it.
we can type also 2% or 5% if we are imposing tax on that then we type this value. Type this formula and press "Enter". The value will come and drag to downward for place other tax values. At last, on Total Cell we apply "Sum" formula to add the value of amount and tax. we type =sum(E3:F3) on E3 has amount value and F3 has tax value.
This according we applied all formula. We can place LOGO also click on Insert. Insert tool has Picture, Clip Art if we have any picture like suitable for logo in our personal computer then take it from picture or we don't want Logo just a simple image then we can take from Clip Art. Apply border on data, go on "Font" and click on any border what you want. This according we can create a attractive data record.
Microsoft Excel - Advanced Excel Formulas & Functions
In next Row, we type the heading! ITEM CODE, PRODUCT, RATE, QUANTITY, AMOUNT, TAX AND TOTAL. These will show at left side and we want it on Center then Select Heading Row and click on center. This "Center" icon on "Alignment Tool". we are looking our "ITEM CODE" not fit on cell then we will increase the width. Click on cell whose cell we want to increase then go on up where A,B,C,D,E,F.... are written and A plus sign will show. This plus sign just put on that line who we want to increase and click on the line & drag the cell. The width pixel will be increase. here the Image is :
We can apply same method for all there. Who we want to increase. After that fill all columns and rows of item code, product, rate, quantity. On Amount! we will apply formula by using "=" sign & first we should know the formula of Amount is (Rate*Quantity). here we type (=D3*C3) because on D3 has Quantity and C3 has Rate values. For Eg:
Microsoft Excel - From Beginner to Expert in 6 Hours
To take easily other Amount values. We take the cursor on the cell and drag to downward. This type! all Amount Value will come.
When we come on TAX. For TAX Formula is (Amount*Tax) {like (=E3*4%)} here we write E3! On E3 has Amount value So we type it then we give multiplication sign and after that 4%. 4% is a rate of tax like we seem that we are imposing 4% tax, so we write it.
we can type also 2% or 5% if we are imposing tax on that then we type this value. Type this formula and press "Enter". The value will come and drag to downward for place other tax values. At last, on Total Cell we apply "Sum" formula to add the value of amount and tax. we type =sum(E3:F3) on E3 has amount value and F3 has tax value.
This according we applied all formula. We can place LOGO also click on Insert. Insert tool has Picture, Clip Art if we have any picture like suitable for logo in our personal computer then take it from picture or we don't want Logo just a simple image then we can take from Clip Art. Apply border on data, go on "Font" and click on any border what you want. This according we can create a attractive data record.
Comments
Post a Comment