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

(i) In Windows you can open several applications simultaneously.
(v) The opening page of a Website is called Home Page.
(vi) Search engines are websites, which helps you to search text on Internet.

(b) ans the subsequent in MS-EXCEL: four
define the 3 various ways of referencing a cell in a formula
(c) ans the subsequent in MS-EXCEL six

In a Worksheet data about Name and Marks (out of hundred) in 6 subjects has been entered in columns A, B, C, D, E, F, G respectively in 1st 26 rows. In 1st row headings are entered, in remaining 25 rows data of 25 students has been entered. discuss the step to perform the following:
(i) To obtain the total marks of every learner in column H.
(ii) To organize the worksheet in descending order of total marks and further in the alphabetical order of names.
(iii) Display those rows where the total marks are above 450.

Q.5 (a) discuss briefly about the following: six
(i) MONITOR (ii) UNIX (iii) BBS.
(b) ans the subsequent in MS-EXCEL. four
State whether the subsequent are actual or False:
(i) A macro can be created using Insert menu.
(ii) INT() is used to round off a provided number.
(iii) It is necessary to sort the list before using Subtotal command.
(iv) Paste special can be used with Cut choice.
(c) ans the subsequent in MS-EXCEL6
worksheet contains the subsequent info. Item Name, Opening Stock, Purchase and sales are entered for seven items in columns A, B, C and D respectively in 1st eight rows. In 1st row headings are entered and in remaining rows data has been entered. discuss steps to perform the following:
(i) To obtain closing stock in Column E.
(ii) To draw bar chart of opening stock and sales.
(iii)To draw Pie Chart of closing stock.

part II
Q.6 (a) elaborate the choices available on the begin menu of Windows 95? two
(b) What is the use of Edit menu in MS–WORD? Mention any 3 choices. four
(c) Write FoxPro commands for the following: 10
(i) To cancel the marking of deletion of all records.

Earning:   Approval pending.