samplequestion papers

Sample Question Papers 363

SAMPLE QUESTION PAPERS

Foundation oF inFormation technology Subject code: 0165

class iX (term i)Time: 3 hours Max. Marks: 90

SECTION–A

1. Yogyata has made documentation manual for her new 3D game. The content is ready but she wants to add attractive borders on each page. Name the feature of the Word Processor, which will help her to achieve the same without devoting much time to designing. 1

Ans. The Page Borders feature of the Word processor will help Yogyata to add attractive borders on each page.

2. Ramanuj Saman is interested in storing data in an organized manner of his monthly expenditure for a period of one year in his annual budget document. He does not wish to perform any calculations and analysis. Which feature of a word processor will you suggest Ramanuj to use for this purpose? 1

Ans. He should use tables as they are more suitable for storing and organizing any kind of numerical data.

3. Taruni Dhar, a chemistry teacher is typing her Chemistry Assignment and she needs to type in chemical representation of Sulphuric acid as H2SO4. But, when she is typing, it is appearing as H2SO4. Which formatting feature will help her to see the numbers 2 and 4 in the desired format? 1

Ans. The Subscript feature will help Taruni Dhar.

4. Kanan Ajawani is a computer professional and has started writing a book titled “Experiences on Computer”. He does not have a good command over English Language and cannot afford to hire an editor for the book. Which two features of Word Processor he should use for basic language corrections? 1

Ans. Spelling & Grammar feature, Thesaurus feature.

5. Name the toolbar, which has all the options of changing the font properties. 1

Ans. Formatting toolbar

6. Name the word processor tool that helps in copying formats and applying it to the selected text. 1

Ans. Format painter

7. Name the word processor feature that helps the user to add Graphical Images in the documents. 1

Ans. Picture

8. Rohit has to rename his folder from “class viii” to “class ix”. Write the steps that he should follow to do so. 1

Ans. Rohit should perform the following steps:

1. Right click the folder. A context menu appears.

2. Select the Rename option from the context menu.

3. Type class ix. The previous text is replaced with the new text.

9. Kalpana wants to check the file size of her document. With which click of mouse she can go to properties option of file? 1

Ans. She needs to right-click the mouse.

10. Name the software that is used to manage all the programs and resources of a computer. 1

Ans. Operating System

11. Where does all the files that are deleted from our computer go? 1

Ans. To the Recycle Bin folder

12. When we boot our computer, what is the first screen that we see called? 1

Ans. Desktop of the computer

13. Charu is working on her project. She has collected all the information and has typed it in a word document. Now she wants to add some images in her project. Using which menu of word processor she can do so? 1

Ans. The Insert menu is used to add images.

14. Kunal has typed a letter to his principal to take one day leave from school. He wants to underline the subject of the letter but his mouse has stopped working. Which shortcut he can use from his keyboard for underlining? 1

Ans. The Ctrl+U key combination is used to make the text underlined.

15. Smita has purchased new laptop. While working with it, she realized that the time that is being displayed on task bar is not correct. Suggest one way to set the correct time to her. 1

Ans. The Date and Time Settings dialog box will help Smita in setting the correct time. She needs to perform the following steps for setting the time of her laptop:

1. Open Control Panel. 2. Click the Date and Time link. The Date and Time dialog box

appears.

Foundation of Information Technology364

3. Click the Change date and time button. The Date and Time Settings dialog box appears.

4. Change the time in the spin box under the Time section according to your requirements.

16. Ms Ashu is a mathematics teacher. She is typing a maths paper. She is referring to a window where some formulas for sum, relations and functions are already given. What is the name of this window? 1

Ans. The Selection window of the OpenOffice.org Math application

or The Elements window of the OpenOffice 4.1.1 Math application

17. Radhika has created a text document using word processor. Now she wants to see how the document will look like when it will be printed. Which option of word processor she can use to do so. 1

Ans. The Print option

18. Name the input device used to sense and read thick and thin black stripes present on the items shown below. 1

Ans. Barcode Reader

19. Ms. Menon has bought a new Inkjet printer. She has connected it to her computer with the help of a USB cable and has switched the printer on. Now, when she is giving the Print command, the printer is not printing. What type of software is required to make the printer work? 1

Ans. Ms. Menon needs to install the device drivers for the new printer.

20. Phantom is a computer programmer, who is developing a small software for a retail chain. Unfortunately, the shop owner is not able to provide him an Internet connection. Phantom carries different modules of this software, installs in the computers connected in various shops and carries sample data back with him for testing. Which storage device will you suggest to him to use for this purpose? This device should have high storage capacity and should be rewritable. 1

Ans. Portable Hard Disk Drive

21. Define the term ‘encryption’. 1 Ans. Encryption refers to a method of converting data into an encrypted

form so that it cannot be understood by an unauthorized user.

22. Which of the following is essentially required for recording and playing back audio in a computer system?a. Bar Code Reader b. MICRc. Microphone d. Printere. Digital Camera f. Speakerg. Joystick h. Light Pen 1

Ans. Microphone is used for recording audio while speaker is used for playing back audio in a computer system.

23. Arrange the following memory units in the ascending order of their storage capacities.

Kilobyte, Byte, Terabyte, Megabyte 1 Ans. Byte, Kilobyte, Megabyte, Terabyte

24. Name one specific software/tool for each of the following category:a. Operating Systemb. Disk Utility Software 1

Ans. a. Windows 7 b. Disk Defragmenter

25. Name the primary memory with the following features:a. It is volatile in natureb. Before a program can be run, the program is

loaded into this memory, which allows the CPU direct access to the program. 1

Ans. RAM

26. Which of the following devices is the most suitable for regularly transferring files between home and school, possibly with graphics?a. CD ROMb. Memory Stickc. Floppy Disk 1

Ans. b. Memory Stick

27. Jolly Picson is a steno in a company. She has drafted a letter for her boss as follows: 2

Dear Sir,

With reference to your letter KTNR/PQ/2011-12/124 dated 15-April-2011. I am here to submit the response. Our gadget RT-2134 is made for electric supply of 110 volts and will not work at 220 volts. Special switch fitted inside the gadget trips when it gets a supply of 220 volts. Kindly use appropriate converter to use our gadget. If you need our engineer to come to rectify the problem, the additional charges will be `4500. We assure you for further assistance if so required.

Thanks for using our gadget.

Sincerely YoursRamtan Jhangaan

Now in this letter she wants spaced out lines for her boss so that he can read it and correct. Also she wants to add pound sign “`” in the letter as shown.


Dear Sir,

With reference to your letter KTNR/PQ/2011-12/124 dated 15-April-2011. I am here to submit the response. Our gadget RT-2134 is made for electric supply of 110 volts and will not work at 220 volts. Special switch fitted inside the gadget trips when it gets a supply of 220 volts. Kindly use appropriate converter to use our gadget. If you need our engineer to come to rectify the problem, the additional charges will be `4500. We assure you for further assistance if so required.

Thanks for using our gadget.

Sincerely Yours Ramtan Jhangaan

Suggest which two features of word processor she should use to get this.

Ans. Jolly Picson needs to use the line spacing feature to increase the spacing between the lines. Also, she needs to add the ` symbol by selecting the symbol from the Symbol dialog box and clicking the Insert button. The Symbol dialog box can be opened by selecting InsertWSymbolWMore Symbols.

28. Write one point of difference between a text editor and a word processor and give the name of any text editor or word processor. 2

Ans. A text editor is used to create, save, and edit a text document. The document cannot be formatted through text editor. On the other hand, a word processor can be used to create, save, edit, and format a text document. In the Windows operating system, the commonly used text editor is Notepad and the word processor is Microsoft Word.

29. Suraj has created a banner for his school Sports Day as shown. Write the name of the feature that he has used for marked features. 2

Ans. WordArt and Page Border

30. Manavi wants to create table as shown:

Which options she should use to do so? 2 Ans. She needs to use the Table icon under the Tables group of the

Insert tab. She also needs to select the cells of the first column and click the Merge Cells icon under the Merge group of the Format tab.

31. Which two documents are essential for mail merge? 2

Ans. Main document and data source

32. In a document all the occurrences of word “is” have to be changed to “are”. Which option is suitable for this and what is the shortcut key for the same option? 2

Ans. Replace option is used to change the occurrences of a word to another. To use this option, the Ctrl+H key combination is used.

33. Identify which of the following can be categorized as Secondary Memory devices: 2

� CD ROM � Hard Disk � Keyboard � Pen Drive � CD ROM � Mouse � Keyboard � Plotter � Printer � DVD

Ans. Hard Disk, Pen Drive and DVD are secondary memory devices.

34. Identify the correct application software (out of Accounting Management, Reservation System, HR Management, Attendance System, Payroll System, School Inventory Control System, Billing System) for performing the following tasks/places: 2a. Restaurant food order counterb. Computation of salary of workersc. Managing records of Purchase and Issue of items

in schoold. Booking for air tickets

Ans. a. Restaurant food order counter: Billing System

b. Computation of salary of workers: Payroll System

c. Managing records of Purchase and Issue of items in school: School Inventory Control System

d. Booking for air tickets: Reservation System

35. A document with the name FIT is stored in the folder D:\FIT\IX. How will you: [5]a. Open this document in a word processor? 1b. Make changes in it and save the changed

document with the name NewFIT so that the original document remains unchanged? 1

c. Change the word device with the word devices at all the places in the document? 1


d. Put the word ‘Modified’ at the top of each page? 1

e. Draw a triangle at a specific location in the document? 1

Ans. a. Double-click the D:\ drive W FIT W IX. The folder is opened. Right-click the FIT document and select the Open with option from the context menu. Select the word processor with which you want to open the document.

b. Make the desired changes in the document. To save it with a new name, select File W Save As. Type NewFIT in the File name combo box of the Save As dialog box.

c. Press Ctrl+H key combination on the keyboard. The Find and Replace dialog box appears with the Replace tab selected by default. Type device in the Find what combo box and devices in the Replace with combo box. Then, click the Replace All button to replace all the occurrences.

d. Select Insert W Header. A drop-down list appears. Select the template for the header from the drop-down list. Type Modified in the place of [Type text].

e. Select Insert W Shapes. A drop-down list appears. Select the shape of Triangle and draw it at the selected location.

36. Ansh was writing a story about Akbar and Birbal in Hindi. He created three different documents with different alignments. These documents are shown below: [5]

a. Identify all the three alignments. 1b. Tell him the steps to be followed for inserting an

image in the document. 2c. Name any 4 features that can be used to improve

the presentation of the story. 2 Ans. a. Left, Centre and Justify

b. To insert an image in the document, you need to perform the following steps:

1. Select the Insert tab.

2. Click the Picture icon under the Illustrations group. The Insert Picture dialog box appears.

3. Select the picture from the desired location.

4. Click the Insert button. The selected picture is inserted into the document.

c. Heading can be underlined. A background colour can be specified. An image can be inserted. A colourful border can be applied.

37. Dinesh Raghunath wants to design the poster as shown below: 5

Identify any 5 features which should be used to design the poster.

Ans. Picture, WordArt, Text box, Font colour and Shape

38. With reference to the following letter, written in a word processor, answer the questions that follow: [5]

The Principal,The ABC School,New Delhi-11001.

Sub: Conduct of classes for Math Olympiad

Respected Sir/Madam,

We are a group of profesional teachers preparing studants for various competitive classes. Our track record has been excellent. We condct classes in various schools in and around Delhi. We shall eel obliged if we get a chance to conduct these classes in your school also. This will help your students improve basic mathematical skils also.

In this regard we shall like to have a meeting with you to doscuss the detailed plan. Please contact the undersigned to fix the meeting date and time.

Regards,

Raj Kumar Pal, Marketing Manager, Excellent Educational Group. Phone: 5936365988


1. What changes will you make to the subject line so that it looks as follows:

Sub: Conduct of classes for Math Olympiad2. How will you set the alignment of letter body to

justify?3. How will you change the line spacing of letter

body to double line spacing (or 2.0)4. Which tool of the word processor will you use to

correct the spellings of all the misspelled words? Ans. 1. Select the word and make it Bold by clicking the B icon on

the Formatting toolbar. Now, select the sentence Conduct of classes for Math Olympiad and click the U icon on the Formatting toolbar to make the selected text underlined.

2. Select the body of the letter and click at the Justify icon.

3. Select the body of the letter and click the Line and Paragraph Spacing icon. A drop-down list appears. Select the 2.0 option from the drop-down list.

4. Spelling & Grammar

39. Ajay and Akshay, students of class IX, prepared their time table using a word processor as shown below:

Time Table: Class IX - D

Class Teacher: Mrs. S. Parashar

Mon Hindi Maths Maths Eng. S.Sc. Science SUPW SUPW

Tue Science Science S.Sc. Eng. Maths Maths Hindi S.Sc.

Wed S.Sc. Maths Science Eng. Sc. (Pr.) Sc.(Pr.) Hindi Games

Thu FIT FIT Maths Eng. Hindi Sc. S.Sc. Games

Fri Maths Maths Science Eng. S.Sc. Hindi Maths(lab.) CTP

Subject Teachers:

Hindi – Mrs. S. Parashar English – Mrs. G. Gupta Science – Mr. V. Bahl S.Sc. – Mrs. K. Walia Maths – Mrs. J. Khanna FIT – Mr. Y. Rastogi

SUPW – Mr. G. Prakash

When they showed this time table to their class teacher, she recommended some changes so that the time table looks as follows:

Time Table: Class IX - DClass Teacher: Mrs. S. Parashar

1 2 3 4 5 6 7 8

Mon Hindi Maths Eng. B S.Sc. Science SUPW

Tue Science S.Sc. Eng. R Maths Hindi S.Sc.

Wed S.Sc. Maths Science Eng. Sc. (Pr.) Hindi Games

Thu FIT Maths Eng. E Hindi Sc. S.Sc. Games

Fri Maths Science Eng. A S.Sc. Hindi Maths(lab.) CTP

Sat Meditation CTP Activity K House Meeting Bal Sabha

Subject Teachers: � Hindi – Mrs. S. Parashar � English – Mrs. G. Gupta � Science – Mr. V. Bahl � S.Sc. – Mrs. K. Walia � Maths – Mrs. J. Khanna � FIT – Mr. Y. Rastogi � SUPW – Mr. G. Prakash

Name the word processing features that Ajay and Akshay should use to make the changes. The changes recommended are listed below:a. The headline should be centre aligned 1b. The Class Teacher’s name should span along all

the columns in the first row. 1c. Add another row after the first row to indicate

period number. 1d. The day names should be in Italics. 1e. At all the places in the table where a subject

occurs twice for consecutive columns, it should be displayed only once spread over the two columns. 1

f. There should be a column after 4th period to accommodate ‘BREAK’. 1

g. There should be a row for Saturday. 1h. The Subject-Teacher list should be a bulleted

list. 1i. Period numbers and ‘BR EAK’ should be in Bold. 1j. The table should be centre aligned. 1

Ans. a. Centre Align b. Merge Cells c. Insert Row d. Italics e. Merge Cells f. Insert Column g. Insert Row h. Bullets i. Bold j. Centre Align


SECTION–B

40. This port is generally found in modern PCs and Laptops. What is the name of this port? 1

a. Serial b. Parallelc. USB d. Linear

Ans. c. USB

41. After assembling a computer system, the very first software to be installed is: 1a. AntiVirus Software b. Operating Systemc. Application Software d. Utility Software

Ans. b. Operating System

42. A student wants to create a ‘digital story’ on the famous storyline ‘The Monkey and the Wedge’ from Panchtantra. He has downloaded all the required images. We want to create the story using watermarks, stylish text, and navigation keys so that the story can be shown to a big group. Which of the following tools should she use? 1a. Word Processorb. Presentation Softwarec. Spreadsheet Softwared. Database Management Software

Ans. b. Presentation Software

43. Which of the following is not a storage device? 1a. Memory Cardb. Random Access Memory c. Pen Drived. CD-ROM

Ans. d. CD-ROM

44. Saving an existing document with some other name using the Save As option: 1a. Replaces the current documentb. Leaves the current document intactc. Is not possibled. Closes the document

Ans. b. Leaves the current document intact

45. Keyboard shortcut to italicise the selected text is 1a. Ctrl + U b. Shift + Uc. Ctrl + I d. Shift + I

Ans. c. Ctrl + I

46. Suresh wants to right align a picture in a word processing document. Which icon should he click on? 1

a. b.

c. d.

Ans. c.

47. Aashish is an executive in a bank. He was typing the daily transaction report and wanted to copy the selected text. He suddenly realised that the mouse was not working. Suggest how could he select the text without using the mouse. 1a. It is impossible to perform the operation

without the mouseb. Use the F5 keyc. Use the arrow key while holding down a Ctrl keyd. Use the arrow keys while holding down a Shift

key Ans. d. Use the arrow keys while holding down a Shift key

48. Anuradha wants to print a document in such a way that the height of the page is less than its width. Help her to select the correct page orientation. 1a. Landscape b. Portraitc. Indent d. Tab setting

Ans. a. Landscape

49. In a document, we want to change the word ‘Books’ and want to place the word ‘Copies’ instead. For this purpose, the option to be used is 1a. Findb. Find and Replacec. Spell checkd. Spelling and grammar check

Ans. b. Find and Replace

50. If we don’t select any part of the document and click on the icon to change line spacing, then 1a. It won’t have any effectb. Current sentence’s line spacing will be changedc. Current paragraph’s line spacing will be changedd. Whole document’s line spacing will be changed

Ans. c. Current paragraph’s line spacing will be changed

51. At one place in a document, Siddharth wants to type H2O, but he is not able to get 2 at its proper place. Which option should he use for this purpose? 1a. Bold b. Superscriptc. Underline d. Subscript

Ans. d. Subscript


52. Keyboard shortcut for right alignment is 1a. Ctrl+R b. Ctrl+Ac. Ctrl+E d. Ctrl+T

Ans. a. Ctrl+R

53. A bulleted list: 1a. Can be converted to a numbered listb. Cannot be converted to a numbered listc. Is better than a numbered listd. Cannot be printed

Ans. a. Can be converted to a numbered list

54. Harshul has created a document and now in some parts of the document’s text, he wants to apply the same type of formatting: Bold, Underline, Font size 14 and colour red. He can do it by: 1a. Using format painterb. Using paint brushc. Using cut copy pasted. Using Windows

Ans. a. Using format painter

55. Arunita told Arnav that Bold, Italic and Underline buttons are toggles. Arnav was unable to understand its meaning. Can you help Arnav to understand the meaning of toggle by telling him the meaning of toggle? 1

a. One click carries out the operation while the other click undoes it

b. After the first click, every click follows the effect of the previous click

c. Every click follows the operation carried out by the first click

d. None of the above Ans. a. One click carries out the operation while the other click

undoes it

56. Kadambari has placed four objects in a document and she wants to ensure that these objects move together when she makes any changes in the document. Which feature will help her to achieve the desired effect? 1

a. Tab stops b. Grouping

c. Page Margin d. All of these Ans. b. Grouping

57. At one place in a document, Renu wants to type x3+8x–2, but she is not able to get 3 at its proper place. Which option should she use for this purpose? 1

a. Bold b. Superscript

c. Underline d. Subscript Ans. b. Superscript


Foundation oF inFormation technology Subject code: 0165 class iX (term ii)

Time: 3 hours Max. Marks: 90

SECTION–A

1. Rimika wants to ensure that there is consistency in design and colour in the presentation that she is making. What should she do to achieve this? 1

Ans. She should use either templates or Master slides.

2. Nilesh Aiyar is interested in storing his salary details and he also wants to perform some calculations and analysis. Which Office application, will you suggest Nilesh should use for this purpose? 1

Ans. The Excel application will help him.

3. Technoware Systems wants to train its sales personnel so that they can create a slideshow for their customers showing the product range offered by the company. State two features of presentation software that will make the presentation interesting. 1

Ans. Custom animation and slide transition feature

4. Slide Transition and Custom animations are two options available in Presentation Tools. Which of these options helps you to include special effects on various text boxes and images during designing a slide? 1

Ans. Custom animations

5. Kanan wants to see all the slides in her presentation simultaneously. Suggest which view she should use to see all the slides simultaneously. 1

Ans. Slide Sorter view

6. Out of the following external file(s), which one(s) will help you include sound in your presentation?

JPEG, WAV, GIF, BMP, MP3 1 Ans. WAV and MP3

7. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, what will the formula be? 1

Ans. The formula in the cell C2 will be =D2+E3

8. What will be the cell address of the cell formed by the intersection of the ninth column and the eighth row? 1

Ans. As the ninth column is I and number of row is 8, the cell address of the cell formed at the intersection will be I8.

9. Give an example of mixed referencing with respect to spreadsheet software. 1

Ans. $A1$B2

10. Solil Harrit wants to insert graphics objects in his presentation. Provide him names of two graphics objects which he can insert in his presentation. 1

Ans. AutoShapes and SmartArts

11. What extra hardware is required for adding and testing narration in a presentation tool? 1

Ans. Mikes and Speakers

12. Out of the following list, pick out the option(s) that is not a type of Plagiarism:

Adding New Content, Potluck Paper, Ghost Writer, Photocopy 1

Ans. Adding New Content

13. In Spreadsheet software, what is the column immediately next to column “Z”? 1

Ans. AA

14. What is the default extension of a workbook created using a spreadsheet package? Give your answer with reference to any one spreadsheet package. 1

Ans. In Excel 2010, the default extension of a workbook is .xlsx.

15. If the values in the cells is as given A1 = 5, A2 = 10, A3 = 15 then to continue the series up to A20 which feature can we use? 1

Ans. Fill Handle

16. Kunal has stored the formula =MIN(C1:C5) in cell C6. How will the formula change when copied to cell D6? 1

Ans. =MIN(D1:D5)

17. Anurag is interested in developing content for World Wide Web using programming and development tools. Suggest an appropriate career for him. 1

Ans. Web Developer

18. Kadambari wants to book an airline ticket. Can you tell why should she book the ticket using Internet? 1

Ans. Booking the ticket through the Internet will save her time.

19. Write appropriate formula for calculating percentage of marks of a student. Marks obtained are given in the cell D8 and Maximum Marks are given in the cell D2. 1

Ans. =D8*100/D2

20. Irene doesn’t know how to move from one slide to the next in a slide show. Tell two methods do to so? 1


Ans. 1. Using arrow keys on the keyboard

2. Clicking the left-mouse button

21. Keerit doesn’t know the meaning of handouts. Explain the meaning of handouts to him. 1

Ans. Handouts are the smaller printed versions of slides. They are given to the viewers at the time of creating a presentation. These handouts help the viewers to easily understand the presentation.

22. Anahita wants to reorganize the slides in her presentation. Which view can she use to reorganize the slides? 1

Ans. Slide Sorter view

23. How would you refer to the range starting from 1st column, 1st row and spread till 4th column and 5th row? 1

Ans. A1:D5

24. Reena wants to give her audience a paper copy of her presentation. What should she create and print? 1

Ans. Handouts

25. Three types of masters exist in presentation software; two of them are slide master and notes master. Which is the third master? 1

Ans. Handouts master

26. In which view can we apply animation on the text or objects. 1

Ans. Normal view

27. Define the terms Plagiarism and Intellectual Property Rights. 2

Ans. Plagiarism refers to the method of copying someone else’s work (ideas and research) and describing it as own original work.

Intellectual Property Rights refer to the rights given to the original creator of content or the developer of the technology for its usage.

28. Kamini wants to change the background colour of a slide. Help her by telling her steps to do so. 2

Ans. She needs to perform the following steps to change the background colour of a slide in OpenOffice Impress:

1. Select the Format W Page option from the Menu bar. The Page Setup dialog box appears.

2. Select the Background tab. 3. Select the Colour option from the drop-down list under the

Fill section to set the background colour of a slide. 4. Select the desired background colour from the list box under

the Fill section. 5. Click the OK button to apply the selected settings. Now, the

Page Settings message box appears. 6. Click the Yes button if you want to change the background

settings in the presentation.

29. Carefully read the news articles given below. What has the writer of the second article done? What should be done to avoid such a situation?

Daily News, August 26, 1997: Sheep rearing (original)

“The sheep was put on its back and pinned it between the workers legs. Then, reaching for his clippers, he went to work.”

Network News, December 16, 2010: Ladakh Sheep rearing

“With a little persuasion, the worker pulled the sheep onto its back and pinned it between his legs. Then, reaching for his clippers, he went to work.” 2

Ans. The writer of the second article copied the content of the first article. This leads to plagiarism.

To avoid the issue of plagiarism, the writer of the second article needs to take proper permissions for the use of the article from the holder of the first article and must need to mention the source of information in his article.

30. Define the following terms:i. Hacking ii. Piracy 2

Ans. i. Hacking: The process of accessing the computer/network/resource of a person without informing him/her with the malicious intention is called hacking.

ii. Piracy: The process of unauthorized duplication of software is known as piracy.

31. From the following list, identify the features which are available in both Presentation Tool and Spreadsheet Software: 2i. Spell Check facilityii. Header and Footeriii. Adding Watermarks/Backgroundsiv. Macros

Ans. i. Header and Footer ii. Macros

32. Tarini Fancy Inc. is planning to connect all computers in their Office Building spread over 50 metres of area. Suggest the most economical cable type having high data transfer speed which can be used to connect these computers. Which type of Network (out of WAN, LAN and MAN) will be formed by connecting these computers? Justify your answer. 2

Ans. To connect computers, Ethernet cable is used.

As the area to be covered is limited to a building, the network formed will be LAN.

33. From the following techniques, which one is suitable for maintaining data integrity and which one is suitable for ensuring security of information? 2

� Data encryption and Password protection � Backing up data regularly

Ans. The data encryption and password protection technique is suitable for ensuring security of information while backing up data regularly helps in maintaining data integrity.

34. Jayant Dhal has created a bar chart in the spreadsheet tool, now he is making a presentation; he wants the same bar chart to be included in one of the slide of the presentation. Suggest two ways to him for the same. Also tell the difference between the two. 2

Ans. Linking and Embedding are the two ways that can be used to include the same bar chart in one of the slide of the presentation. Using the linking between spreadsheet and presentation, the change made to the chart in the spreadsheet also affects the


presentation. On the other hand, while embedding, the change to the chart in the spreadsheet does not affect the presentation.

35. Margaret Baxter has written a letter which she wants to send to 4 banks. 5

12/23, Nehru Place New Delhi 12-March-2015

Dear <title> <surname><Address line>

I am Margaret Baxter, the general manager of the “Technological solutions LTD” and the holder of the current account number <account_no>. I would like ask you to send me the statement of the account for the last 3 months. I need to present this statement to the tax authorities next week. I request you to kindly send the statement at the earliest.

In reference to the above, I would like to point out that I need the statement from 01.05.14 until 01.08.14.

A prompt reply will be highly appreciated.

Thanking in advance,

Margaret Baxter (General Manager) “Technological solutions LTD”

i. Margaret wants to send the letter with same content to 4 banks with similar request. The addresses of all such banks along with corresponding account numbers are stored in a separate document. Name the feature which will help Margaret achieve the same.

ii. Name the two files that Margaret has to use to be able to send letters to all the banks.

iii. Identify the placeholders/merge fields in the given document.

iv. Margaret wants to keep a record of all the changes/corrections that she makes in this document. Name the feature used to achieve the same.

Ans. i. Mail Merge

ii. Letter and Data Source

iii. The placeholders/merge fields in the given document are as follows:

<title>, <surname>, <Address line>, <account_no>

iv. Track Changes

36. Name and explain any 5 components of a chart in a spreadsheet package. 5

Ans. i. Chart Title: Defines the title of the chart that describes the idea about the representation of chart.

ii. Axes Titles: Defines the titles for the axes of the chart.

iii. Chart Area: Refers to an area of a chart including titles and legends.

iv. Data Series: Refers to the set of values for which the chart is drawn.

v. Legend: Refers to a small component that describes the meaning of different columns/lines/points of a chart.

37. Give the following answers with respect to a spreadsheet: 5i. Cell A1 contains the number 20 and B1 contains

3. What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?

ii. The contents of Cell A1, B1, C1 and D1 are 10, –20, 30 & –40 respectively. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1)

iii. Cell D3 contains the formula =$B$3+C3 and this formula is copied to cell E3, what will be the copied formula in cell E3?

iv. Cell D3 contains the formula =$B3 + C3 and this formula is copied to cell E3, what will be the copied formula in cell E3?

v. Cell D3 contains the formula =$B3 + C$3 and this formula is copied to cell E4, what will be the copied formula in cell E4?

Ans. i. 44 ii. –40

iii. =$B$3 + D3 iv. =$B3 + D3

v. =$B4+D$3

38. Neel has recently joined an insurance company as Marketing Executive. She is making a presentation on the company in which she wants to incorporate the following features: 5i. Add the company’s logo (stored as a file on her

computer) on the first slide.ii. Add the name of the company on the top of

each slide.iii. Add a movie clip in the 5th slide.iv. Connect Slide 4 to Slide 9 directly. v. Add slide numbers automatically at the bottom

of each page.

Write commands/features of presentation package using which she can achieve this.

Ans. i. Insert picture by clicking Insert W Picture. Then, select the desired picture from the file and click the Open button.

ii. Using Slide Master that can be opened by clicking View W Slide Master.

iii. Select the 5th slide and click Insert W Video W Video from File. Now, select the video clip and click the Insert button.

iv. In the 4th slide, she can insert hyperlink to the 9th slide by clicking Insert W Hyperlink. Now, click the Place in This Document button in the Link to section of the Insert Hyperlink dialog box. Select Slide 9 under Slide Titles and click the OK button.

v. Add slide numbers in the footer of each page by opening the Slide Master by clicking View W Slide Master.

39. Tariq Fashions maintains their employee salary details in a spreadsheet as shown below. A sample data of 7 employees is shown below. Write steps for the operations (i) to (v) and answer the questions


(vi) to (viii) based on the spreadsheet given below along with the relevant cell address: [10]

i. To calculate the DA as 25 % of BASIC+HRA for

each employee and display in column D. ii. To calculate the NETSALARY as

BASIC+HRA+DA+PF for each employee and display in column F.

iii. To find the maximum NETSALARY and display in cell F9.

iv. To count the number of employees and display in cell B10.

v. The Manager wants to know how many employees from the above data are eligible for bonus. The criteria being that the employees

having a salary greater than ` 75000 are not eligible for bonus. Write the formula the Manager should use for achieving the same and display the number of employees in cell F10.

vi. The manager inserts a column for S. No. in the above spreadsheet. Which feature will help him automate the typing of sequential numbers in this column?

vii. The manager wants to graphically represent a comparative analysis of the salaries of employees. Suggest the most suitable chart type for achieving the same.

viii. If the Basic salary of an employee changes, will the manager have to redo all the calculations for that particular employee? Explain.

Ans. i. Insert the formula =(B2+C2)*25% in the cell D2 and copy it in the cells D3 to D8.

ii. Insert the formula =SUM(B2:E2) in the cell F2 and copy it in the cells F3 to F8.

iii. Insert the formula =MAX(F2:F8) in cell F9.

iv. Insert the formula =COUNT(B2:B8) in the cell B10.

v. Insert the formula =COUNTIF(F2:F8;“<=75000”) in the cell F10.

vi. Autofill

vii. Column Chart

viii. No. The formulas applied in the worksheet calculate the results automatically.

40. Great Bazaar has employed Yunus Kumar to manage and maintain their networking architecture and wide area connectivity. Which of these best describes his job profile? 1a. Networking Engineer b. Database Analystc. Web Designer d. Programmer

Ans. a. Networking Engineer

41. Sumriddhi is logging in to her gmail account and one of her friends is trying to peep in and figure out her password. Which of the following issues is being infringed? 1a. Plagiarism b. Privacyc. Intellectual Rights d. None of these

Ans. b. Privacy

42. The double arrow at the right end of a toolbar means _____.? 1a. You can drag the toolbar from here to make it floatb. The Help button is hidden to the rightc. The toolbar is floatingd. There are hidden buttons

Ans. d. There are hidden buttons

SECTION–B

43. In a presentation, Sachin has to change all occurrences of the word ‘Calcutta’ with ‘Kolkata’. Which one of the following options is most appropriate to do the task? 1

a. Copy & Paste b. Find & Replace

c. Cut & paste d. All of these Ans. b. Find & Replace

44. Members of ‘Nibbles & Bytes’, the computer club of a school wants to prepare and print Participation Certificate for all the participants in their annual interschool symposium using a spreadsheet, where the details of the participating students along with the events and schools are entered. Which of the following office techniques is most appropriate to get the desired results? 1

a. Copy & Paste

b. Find & Replace

c. Mail Merge

d. Cut & Paste Ans. c. Mail Merge


45. Rehman is making his Science Project Presentation on ‘Force and Motion’ using a presentation software. He wants to add the phrase ‘Force and Motion Presentation’ at the bottom of each page. Which option should he use? 1a. Footer b. Headerc. Watermark d. Bullets

Ans. a. Footer

46. A student wants to create a ‘Digital Story Teller’ on the famous storyline ‘Rabbit & the Tortoise’. He has downloaded some images of Rabbit, Tortoise and forest. He wants to add background music, voice over and animation. Which one of the office tool he should use? 1a. Word Processing Software b. Presentation Softwarec. Spreadsheet Softwared. Database Management System

Ans. b. Presentation Software

47. Spell Check will find errors in which of the following?a. It in a beautiful, sunny dayb. It is a beautiful sunnyc. It isa beautiful, sunny dayd. Is a beautiful sunny day 1

Ans. c. It isa beautiful, sunny day

48. Ananya wants to create a new slide show with the current slides but presented in a different order. Which feature can she use to achieve the same? 1a. Rehearsal b. Custom Slide showc. Slide Show Setup d. Slide Show View

Ans. b. Custom Slide show

49. Vanya has made a presentation on ‘Global Warming’. She wants to progress her slide show automatically while she speaks on the topic in the class. Which of the following features should she use to deliver her presentation? 1a. Custom Animation b. Rehearse Timingc. Slide Transition d. Either (a) or (b)

Ans. b. Rehearse Timing

50. Computer Teacher of ‘Shanti Education School’ wants to graphically analyze the performance of her students over the last three Computer Tests. Which one of the following office tools she should use to get graphical report in most effective manner with minimum effort? 1a. Word Processing Softwareb. Presentation Softwarec. Spreadsheet Softwared. Database Management System

Ans. c. Spreadsheet Software

51. Why does the SUM function in B6 show an error?

a. Manual calculation is turned on and the cell has

not been re-calculatedb. Someone has keyed the number 0 into B7c. The function contains a circular referenced. The function is still being edited so hasn’t

calculated a result yet 1 Ans. c. The function contains a circular reference

52. In a Spreadsheet, the following reference changes rows and columns automatically when it is copied to a new cell. 1a. Relative Reference b. Absolute Referencec. Mixed Reference d. All of these

Ans. a. Relative Reference

53. Numbers entered into a cell are automatically 1

a. Left-aligned b. Right-alignedc. Center-aligned d. Justified

Ans. b. Right-aligned

54. Chhaya writes a really good essay on ‘Global Warming’ for her class. Her teacher encourages her to submit it to a journal for publication and it gets accepted. Who would own the copyright? 1a. Teacherb. Schoolc. Chhayad. The Publication that printed her essay

Ans. c. Chhaya

55. Sam Niza, who was born in 1995, is thinking of a password for her online bank account. Which one of the following you would suggest for strengthening the security of her account? 1a. sam95 b. a99p54c66c. samniza1995 d. sam1995

Ans. a. sam95

56. Which of the following is not a transition effect? 1a. Box in b. Venetian Blindsc. Cover down d. Slide sorter

Ans. d. Slide sorter

57. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display 1a. 16 b. 25c. 20 d. 18

Ans. c. 20

samplequestion papers

Documents