SAMPLE QUESTION PAPER 1 - CBSE



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) |Expand the terms DVD and USB. |1 |

| |(b) |Which function key is used as a toggle key for changing cell referencing modes? | |

| | | |1 |

| |(c) |Name any two view options available in PowerPoint. |1 |

| |(d) |Name the operator similar to the Boolean AND operator while using Search engines. | |

| | | |1 |

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

| | | |1 |

| |(f) |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? | |

| | | |1 |

| |(g) |Explain the usage of the Network Places component of the windows operating system. | |

| | | |1 |

| |(h) |Name the tool used for finding synonyms and antonyms in Word. |1 |

| |(i) |Define the term hit in reference to a search engine. |1 |

| |(j) |Briefly explain the usage of the crop option of the Picture toolbar. |1 |

| | | | |

|2. |Answer the following questions briefly: |

| |(a) |How is the Switch User option different from the Log Off option? |2 |

| |(b) |Explain the usage of the EXT and OVR modes while entering text in Word. | |

| | | |2 |

| |(c) |Mention the shortcut key combinations used for navigating | |

| | |to the top of the Worksheet (cell A1) and |1 |

| | |to the end of a column. |1 |

| |(d) |What is the difference between replying to a message and forwarding it? | |

| | | |2 |

| |(e) |Write names of any two websites where information about latest viruses, anti-virus software etc can be | |

| | |found. |2 |

| | | | |

|3. |Answer the following questions: |

| |(a) |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. | |

| | | | |

| | |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. | |

| | |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. | |

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

| | |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. | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | |1 |

| | | | |

| | | |1 |

| | | | |

| | | |1 |

| | | | |

| | | | |

| | | |1 |

| |(b) |Differentiate between relative and absolute cell referencing techniques with the help of sample data. | |

| | | |4 |

| |(c) |How are charts useful in Excel? Compare any three chart types available in Excel. | |

| | | |4 |

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

| | |Animation effects and |4 |

| | |Transition effects | |

| |(e) |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 |1 |

| | |SNO | |

| | |Name |1 |

| | |Science | |

| | |Maths |1 |

| | |Computers | |

| | |Total |1 |

| | |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 | |

| | | | |

| | |-- | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | | | |

| | |To calculate the Total Marks as sum of Science, Maths & Computers for each student and display them in | |

| | |column F. | |

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

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

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

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download