Question 2: a) Prove that the sum of fourth powers of the first n integers is
1/30n(n+1) (2n+1)(3n^{2}+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 |
|||
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.