University of Mumbai 2007 B.A Economics Computer Systems and Applications - Question Paper

(i) MODEM is a software.
(ii) RAM is non - volatile memory.
(iii) Every computer requires an Operating system.
(iv) AOL is a commercial on line service.
(v) Hard disk can be write protected.
(vi) Bulletin Board Service is not part of Internet.
(b) ans the subsequent in MS-EXCEL: four
discuss with examples the subsequent functions. (i) NPV() (ii) ROUND() (iii) SUM() (iv) TRIM()
(c) ans the subsequent in MS-EXCEL six

There is a worksheet containing cricketer's details such as name, country, no. of matches played in columns A, B, C respectively. This worksheet contains details of 60 players entered in columns two to 61. Write steps to,
(i) Rearrange the worksheet in alphabetical order of country and in country in the descending order of no. of matches played.
(ii) Show records of players from "Sri Lanka"
(iii)Show records of players who have played more than 100 matches.

Q.5 (a) discuss briefly about the following: six
(i) ALU (ii) UNIX (iii) Search Engines.
(b) ans the subsequent in MS-EXCEL. four
State whether the subsequent are actual or False:
(i)Paste special cannot be used with Cut choice.
(ii) A Pivot tables are updated automatically.
(iii) Once the file is saved it closes the file and provide a blank sheet.
(iv) A work book can contain at most 3 worksheets.
(v) A function cannot contain a different function in its argument.
(c) ans the subsequent in MS-EXCEL four
The subsequent data of No. of students in a College has been entered in a MS Excel worksheet: A B C D E
1 Year F.Y.B.Com S.Y.B.Com T.Y.B.Com Total
2 2001 1200 920 650
3 2002 1220 1000 900
4 2003 1320 1100 970


Based on these values write steps to
(i) obtain total number of students for every year.
(ii) Pie chart of number of students for the year 2003.
(iii) Line chart for F.Y.B. Com and T.Y.B.Com students.

part II
Q.6 (a) What is the use of begin button in Windows 95? two

Earning:   Approval pending.