CS-612 PC Software and Application Skills Assignment Questions

Question 1: Explain in detail all the options/items on the Menu bar and Tool bar of any Internet Browser (Internet Explorer or Netscape Navigator).

Question 2: a) Prove that the sum of fourth powers of the first n integers is
1/30n(n+1) (2n+1)(3n²+3n+1).
b) Prove that the sum of the squares of the first n integers is
1/24 (2n) (2n+1) (2n+2).

Question 3: You have decided to purchase a new pickup truck but want to compare various dealer prices. You are ordering a Ford Ranger XLT with the seven options (air conditioning, automatic transmission, stereo, power steering, anti-lock braking system, cruise control, and an extended warranty) listed in Table 1 below. Create a worksheet to compare prices for this vehicle among the three different dealers. Include a 3-D column chart that compares the Grand Total prices of dealers A, B, and C . Print the workbook and the chart.

Cost Comparison Sheet
Make: Ford Color: Red Model: Ranger XLT
Pricing Information	Dealer A	Dealer B	Dealer C
Air conditioning	699	705	739
Automatic transmission	375	379	397
AM/FM, CD, cassette	819	625	655
Power steering	229	231	243
ABS	797	804	1144
Cruise control	184	486	196
Extended Warranty	114	114	1019
Base price	14070	14015	11639
Grand totals

Question 4: Give detailed information on the topic “E-Governance” by browsing the Internet. List the browsed URLs and the information associated with them.

Question 5: a) Show whether: If n >=4 then find whether 2.n is less than 4.n or not.

b) Create chat account with any chat service provider website (like yahoo, msn, etc.) and explain the different component of this account.

Question 6: Explain the use of chart wizard of MS-Excel with the help 7 an example.