Home » E-Books » NCERT » Class 11 » Accountancy » Computer Applications in Financial Markets Solved Sample Paper for class 11

Computer Applications in Financial Markets Solved Sample Paper for class 11

SAMPLE QUESTION PAPER 1

Computer Applications in Financial Markets

        Class XI

 

   Time allowed : 2 hours                                                                                   Maximum Marks : 40

 

Note :

(i) All questions are compulsory.

(ii) Question 1 consists of 10 questions of 1 mark each.

(iii) Question 2 consists of 5 questions of 2 marks each.

(iv) Question 3 consists of 5 questions of 4 marks each.

(v) Answer the questions after carefully reading the text.

 

 

1. Answer the following questions:

 

  (a)

 

Ans

Expand the terms DVD and USB.

 

DVD stands for Digital Versatile Disc and USB stands for Universal Serial Bus.

( ½ Mark each for each correct full form)

 

1
  (b)

 

 

Ans

Which function key is used as a toggle key for changing cell referencing modes?

 

The F4 key is used to toggle between the absolute and relative modes of referencing cells.

(1 mark for the correct answer)

 

 

1

  (c)

 

Ans

Name any two view options available in PowerPoint.

 

Two view options available in PowerPoint are Normal view and Outline view.

(Note: Other view options available are Slide view, Slide Sorter view and Slide Show view.)

( ½ Mark each for writing ANY TWO views)

 

1
  (d)

 

 

Ans

 

Name the operator similar to the Boolean AND operator while using Search engines.

 

Plus operator (+ sign) is similar to the Boolean AND operator while using Search engines.

(1 mark for the correct answer)

 

 

1

  (e)

 

 

Ans

Name the type of printer to be used for printing text and graphics with high speed but at low cost.

 

Laser printers are most suitable for uses involving high-speed quality prints at low cost.

(1 mark for the correct answer)

 

 

1

  (f)

 

 

 

Ans

Ramesh Ahuja wants to store data of his monthly expenditure over the last financial year. Which of the Office application is most suitable for this purpose?

 

MS Excel application is most suitable for storing any kind of numerical data.

(1 mark for the correct answer)

 

 

 

1

  (g)

 

Ans

Explain the usage of the Network Places component of the windows operating system.

The Network Places component of the Windows operating system displays shortcuts to other computers and shared resources on the computer network. My Network Places also provides links for viewing your network connections, setting up a small business or home network with the Network Setup Wizard, and viewing computers in your workgroup.

(1 mark for the correct answer)

 

 

1

  (h)

 

Ans

Name the tool used for finding synonyms and antonyms in Word.

 

The Thesaurus tool can be used for finding synonyms and antonyms in Word.

(1 mark for the correct answer)

 

1
  (i)

 

Ans

Define the term hit in reference to a search engine.

 

The results returned by Search engines are called “hits”.

(1 mark for the correct answer)

 

1
  (j)

 

Ans

Briefly explain the usage of the crop option of the Picture toolbar.

 

The Crop option can be used to delete outer portions of the selected image.

(1 mark for the correct answer)

1
 
2. Answer the following questions briefly:
  (a)

 

Ans

How is the Switch User option different from the Log Off option?

 

It is sometimes required for two users to work on the same system. In such a situation either of the two options – Switch User or the Log Off option can be used.   In case the Log Off option is used then the first user can Log Off and the second user can only then Log in. This means that the programs of the first user are closed and the windows session ends for the first user. But if the first user does not want to close his windows session and needs to resume his work after the second user has completed his task, then the Switch User option should be used.

(2 marks for the correct difference)

 

2
  (b)

 

 

Ans

Explain the usage of the EXT and OVR modes while entering text in Word.

 

The “OVR” mode indicates that the Overtype mode is ON which means that the new text is overwritten over the previous text. The EXT mode is used to select text for modifying or manipulating (cutting, copying or changing its attributes) it.

(1 mark for each of the correct usage)

 

 

2

  (c)

 

 

 

Ans

Mention the shortcut key combinations used for navigating

i)        to the top of the Worksheet (cell A1) and

ii)      to the end of a column.

 

The shortcut key combinations used for navigating

i)        to the top of the Worksheet (cell A1) are CTRL + HOME and

ii)      to the end of a column are CTRL + down arrow key (↓) or END + down arrow key (↓).

(1 mark for each correct key combination)

 

1

1

  (d)

 

 

Ans

What is the difference between replying to a message and forwarding it?

 

The difference is:

Replying to a message Forwarding a message
1. Replying to an email means sending an answer to a mail received from a person 1. Forwarding an email means sending a received email to someone else to read who wasn’t on the original addressee list.
2. Automatically copies the original Subject in the Subject box prefixed with “RE:” 2. Automatically copies the original Subject in the Subject box prefixed with “FWD:”
3. Mail can be replied to by clicking the Reply button. 3. Mail can be forwarded by clicking the Forward button.
4. Automatically copies the sender’s email address into the “To:” field. 4. The email address of the person to whom it has to be forwarded is to be typed in the “To” field.
 

2

  (1 mark each for ANY TWO correct differences)

 

  (e)

 

 

Ans

Write names of any two websites where information about latest viruses, anti-virus software etc can be found.

 

Two of the most popular websites where information about latest viruses, anti-virus software etc can be found are:

  1. http://www.symantec.com
  2. http://www.Mcafee.com

 

(1 mark each for ANY TWO correct website names)

 

2

 
3. Answer the following questions:
  (a)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Ans

Mr. Rattan is a trainee editor working with BBB Publishers. He is currently working on a book related to Computer Hardware. Read the following paragraph carefully and help Mr. Rattan in his job by answering the questions that follow:

 

The term computer hw refers to the physical components of a computer, namely Keyboard, Monitor, Mouse, and Printer, including the digital circuitry. Computer hw is an integral part embedded in all modern day automobiles, microwave ovens, electrocardiograph machines, compact disc players, and other devices. The hw of a computer is not changed frequently, in contrast with software and data. The present computers are much advanced in terms of processing speed and have an efficient memory structure. The present lesson aims at providing an insight into the various hw concepts of a Computer System.

 

i)        All the occurrences of the word “hw” need to be substituted by the word “hardware”. Name the feature to be used for achieving the same.

ii)      The editor needs to create a list of errors at the end of the paragraph. Name the feature to be used for achieving the same.

iii)    To simplify editing selected words, suggest the mouse shortcut for selecting a complete word.

iv)    The word formatting of the words “computer hw” in the first line needs to be copied on certain other words in the paragraph. Name the feature to be used for achieving the same.

 

i)        The Find and Replace feature should be used for achieving the same.

ii)      Numbered List option can be used.

iii)    The mouse shortcut for selecting a complete word is to double-click within the word.

iv)    The Format Painter feature can be used for this purpose.

(1 mark each for each correct answer)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

1

 

1

 

 

1

  (b)

 

 

Ans

Differentiate between relative and absolute cell referencing techniques with the help of sample data.

 

With relative cell addressing, when you copy a formula from one area of the worksheet to another, Excel records the position of the cell relative to the cell that originally contained the formula. This is the default mode of referencing in a spreadsheet. Absolute referencing, on the other hand, implies that the coordinates of a cell are not changed when a formula is copied from one cell to another. To make a cell address an absolute cell address place a dollar sign in front of both the row and column identifiers.

 

For example, if the formula =A1+B1 is copied from cell C1 to cell C3, then it automatically changes to =A3+B3. But if the formula =$A$1+$B$1 is copied from cell C1 to cell C3, then it remains unchanged. The dollar sign locks the cell location to a fixed position. Therefore, when it is copied and pasted it remains exactly the same.

(2 marks  for the correct difference)

(1 mark each for each correct example)

 

 

4

  (c)

 

 

Ans

How are charts useful in Excel? Compare any three chart types available in Excel.

 

Charts are useful as they are an excellent tool to present data in a worksheet in a visually appealing format which aids in analyzing and comparing data. Three chart types available in Excel are:

1.      Pie Chart – It shows the proportional size of data that make up a data series and is useful when we want to emphasize a significant element.

2.      Column Chart – A column chart shows data changes over a period of time or illustrates comparisons among items.

3.      Bar Chart – It illustrates comparisons among individual items. Categories are organized vertically, values horizontally to focus on comparing values and to place less emphasis on time.

(1 mark  for the correct advantage)

(1 mark each for each chart type explanation)

 

 

4

  (d)

 

 

 

 

Ans

What is the difference between Animation and Transition? Which view can be used to insert and test the:

  1. Animation effects and
  2. Transition effects

 

Animation refers to special sound and visual effects that can be added to text or other objects to make them appear as dynamic rather than static images. Transition on the other hand refers to special effects that can be added on the entrance of a slide during a slide show. Each slide can have only a single transition effect but multiple animation effects as each object on the slide can have different effects.

  1. The Slide view can be used to insert and test the Animation effects
  2. The Slide view  and the Slide Sorter View can be used to insert and test the Transition effects.

(2 marks  for the correct difference)

(1 mark each for naming each correct view)

 

 

4

  (e)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Ans

Write formulas for the operations (i) – (iv) based on the spreadsheet given below along with the relevant cell address:

 

A B C D E F G
1 SNO Name Science Maths Computers Total Average
2 1 Swati 70 80 87
3 2 Shruti 90 98 89
4 3 Neelu 90 90 98
5 4 Rosy 60 76 79
6 5 Shreya 50 45 67
7 Max
8 Total

 

a) To calculate the Total Marks as sum of Science, Maths & Computers for each student and display them in column F.

b) To calculate the average marks for each student and display them in column G.

c) To calculate the highest marks in Computers and display it in cell E7.

d) To calculate the total number of students appearing for the Science test and display it in cell C8.

 

a)      In cell F2 enter the formula   = C2 + D2 + E2. Now copy this formula to cells F3, F4, F5 and F6.

b)      In cell G2 enter the formula  = AVERAGE(C2:E2). Now copy this formula to cells G3, G4, G5 and G6.

c)       In cell E7 enter the formula  = MAX(E2:E6)

d)      In cell C8 enter the formula = COUNT(C2:C6) or enter the formula = COUNTA(B2:B6)

 

(1 Mark each for each correct answer)

 

 

 

 

 

 

 

 

 

 

 

 

 

1

 

1

 

1

 

1

 

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

Leave a Reply

Your email address will not be published. Required fields are marked *