Docstoc

CIN506 Lab Exercise 1

Document Sample
CIN506 Lab Exercise 1 Powered By Docstoc
					CIN506 Lab Exercise 1:
Create the following table in MS Word

                                                      Titan Corp Sales Log
Item                                    Year 1                   Year 2                  Year 3           Year 4
Dot Matrix Printers                    $2500.00                 $3500.00                $4500.00         $5500.00
Laser Printers                         $1750.89                 $2750.89                $3750.89         $4750.89
Flat Bed Scanner                       $1100.65                 $2100.65                $3100.65         $4100.65
Fax Scanner                            $1000.00                 $2000.00                $3000.00         $4000.00
Smart Phones                           $1250.00                 $2250.00                $3250.00         $4250.00
IP Security Cameras                    $1300.00                 $2300.00                $3300.00         $4300.00
21’’ LCD Monitors                      $1700.67                 $2700.67                $3700.67         $4700.67
Blue Ray DVDs                          $1312.00                 $2312.00                $3312.00         $4312.00
Scan Disk USB Flash (4G)               $2987.55                 $3987.55                $4987.55         $6987.55
Wireless Mouse                         $3150.50                 $4150.50                $5150.50         $7150.50
Flexible Keypads                       $4010.00                 $5010.00                $6010.00         $8010.00
DSI – XL                               $5987.23                 $6987.23                $7987.23         $9987.23


Questions:
   1. Insert a new column at the right end of the table and calculate total sales amount per all items

   2. Insert a new row at the end of the table and calculate total sales amount per all 4 years

   3. Insert another row at the bottom and calculate the minimum sales amounts per year

   4. Insert another row at the bottom and calculate the maximum sales amounts per year

   5. In cell (E15), calculate the grand total of all sales.
6. In cell (A18), ENTER the words: Total sales shared amongst 3 partners

7. In cell (B18), calculate the total sales shared amongst 3 partners

8. Apply Font size 16, Font Type: Arial and Bold features to the Title: Titan Corp Sales Log

9. Apply Font size 12, Font Type: Arial and Bold features to the column headings

10. Apply any table style of your choice to the entire table

11. Apply cellular borders of 1 point to all cells of the table

12. Apply Outside border to the table of 2 ¼ pts

13. Shade the Title header row to light blue

14. Shade the column header row to light green

15. Shade all cells with answers calculated to light purple

16. Shade the rest of the cells to light grey

17. Save the file as per your ID No on the desktop of your PC

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:5/16/2012
language:English
pages:2
fanzhongqing fanzhongqing http://
About