Solved Paper – 1
Data Entry Operations (336)
(Theory)
Time : 2 Hours Marks : 40
1. Fill in the blanks of the following:
½×10=5
(i) If you drag an item (file/folder) from one folder to another, it is………….. to the destination.
(ii) FORTRAN stands for Formula……….
(iii) O’s and I’s in Machine language are known as…………..number.
(iv) Shortcut key………. is used to underline a word.
(v) The………. tab contains the groups and commands used in Mail Merge.
(vi) The Software lying in a web server can only used offline at the user’s end only when it gets……….
(vii) Host name is also called………. name in E-mail address.
(viii)…………….case capitalizes the first letter of the first word in each sentence.
(ix)…………..slide layouts are available in New Slide Dialog box.
(x) Internet connections are provided by the internet……….. provides of your locality.
Ans. (i) If you drag an item (file/folder) from one folder to another, it is source to the destination.
(ii) FORTRAN stands for Formula Translation.
(iii) 0’s and I’s in Machine language are known as binary number.
(iv) Shortcut key Ctrl + U is used to underline a word.
(v) The mailing tab contains the groups and commands used in Mail Merge.
(vi) The Software lying in a web server can only used offline at the user’s end only when it gets web browser.
(vii) Host name is also called domain name in E-mail address.
(viii) Sentence case capitalizes the first letter of the first word in each sentence.
(ix) All slide layouts are available in New Slide Dialog box.
(x) Internet connections are provided by the internet service provides of your locality.
2. State True or False :
½×10=5
(i) Keyboard is an Input Device.
(ii) A database table cannot be used as a data source for mail merge.
(iii) The cell address D1 denotes column 1 and Row B.
(iv) Under File Menu you can print the file.
(v) It is necessary to give password to protect a file from reviewers.
(vi) It is not possible to specify mathematical relationship between the numbers using the formula.
(vii) Only Line Charts can be drawn in Worksheet.
(viii) LCD are flat panel monitor.
(ix) Machine Language is low level language.
(x) Slides are used for presentation.
Ans. (i) True, (ii) False, (iii) False, (iv) True, (v) True, (vi) False, (vii) False, (viii) True, (ix) True, (x) True.
3. Define the following terms (any two):
1×2=2
(a) Operating System
(b) Borders and Shading
(c) Cell References.
Ans. (a) Operating System: An operating system is a system software that provides an interface for a user to communicate with the computer, manages hardware devices (disk drives, keyboard, monitor, etc), manages and maintains disk file systems and supports application programs.
(b) Borders and Shading: You can add borders, to any side of a paragraph, and you can add background shading. You can also add borders and shading to ordinary text and to the paragraphs in table cells and frames. Choose Home Paragraphs sub task menu and click on the button to display Border and Shading submenu. The Borders and Shading dialog box appears. Click on the appropriate borders box after selecting Borders tab to select border, select Paragraph under Apply to: drop down submenu, click OK. To shade a paragraph, click on Shading tab in Borders and Shading dialog box, select appropriate shade under Fill, and select Paragraph under Apply to: drop down submenu, click OK.
(c) Cell References: Each worksheet contains a number of columns and rows. Each cell of the worksheet has a unique reference. For example, A8, refers to the cell containing column number A and row number 8.
4. Write shorts notes on the following:
2×5=10
(a) Optical Scanner
(b) Vertical and Horizontal Scroll Bars
(C) What are the Control Panel’s Tools?
(d) World Wide Web (www)
(e) Outline View in Presentation.
Ans. (a) Optical Scanner: These devices are used for automatic data collection. The devices of this category completely eliminate manual input of data. For example, the bar-code reader is actually just a special type of image scanner An image scanner translates printed images into an electronic format that can be stored in a computer’s memory, and with the right kind of software, one can alter a stored image. Another example of scanner is optical character recognition (OCR) device, used by banks to convert the scanned image of a typed or printed page into text that can be edited on the computer.
(b) Vertical and Horizontal Scroll Bars: The typing area is bordered on the right side by the vertical scroll bar with a scroll button and arrows. You can drag the vertical scroll button up and down the scroll bar to move up and down through the document. The first bar along the bottom of the typing area is the horizontal scroll bar. To see the text that it off the right side of the screen, use the left arrow button. You can drag the horizontal scroll button to move left or right of the document.
(c) Control Panel’s Tools: By using Control Panel’s tools you can customize the way Windows look and work! Also you can install new hardware, add and remove (install/uninstall) software programs, change the look and feel of your desktop and much more. It also includes a number of administrative tools in Administrative Tools option for better administration of Windows in terms of User Management, Event viewer, Component Service etc.
(d) World Wide Web (www): The World Wide Web (“WWW” or simply the “web”) is all collection of electronic documents (called web pages) that are linked together like a spider web. These documents are stored on computers called servers located around the world.
(e) Outline View in Presentation: To reorder a slide in Slide Sorter View, simply click on the slide you wish to move and drag it to the new location. In Normal or Outline View, click on the slide in the slide pane and move and drag the slide to a new location.
5. Differentiate between the following (specify two differences in each):
2×5=10
(a) Radar Charts and Bubble Charts
(b) HTTP and HTML
(C) Save As and Save as Webpage command.
(d) Main Document and Merged Document.
(e) Compiler and Assembler.
Ans: (a) Radar charts: The radar charts compare the aggregate values of a number of data series. Radar chart can be plotted with the data which is arranged in columns or rows on a worksheet.
Bubble charts: A bubble chart can be used to plot the data values which are arranged in the columns of a worksheet so that x values are listed in the first column and matching y values and bubble size values are listed in adjacent columns.
(b) HTTP: The Hyper text transfer protocol (HTTP), is an application protocol for distributed, collaborative and hyper media information system. HTTP is the foundation of data communication for the word wide web. Hyper text is structword text that use logical link (hyperlinks) between nodes containing text.
HTML (Hypertext Markup Language): It is a language that consists of cedrtain key words called “Tags”, used for writing the documents on the web.
(c) Save As: Presentations can be saved by selecting Office button Save As command on the menu bar as explained earlier.
Save as Webpage: However, if you want to post PowerPoint presentations on the Internet, you may want to save them as Web pages so that the visitors to your web site can view the presentation even if they do not have Power Point installed on their computers. Select Office Save As and select Web Page command from the drop down. Choose your web page directory on the network from the Look in: drop-down menu and name the file in the File name: box. Click Save to save the presentation in web format.
(d) Main Document: In a Mail Merge operation, the personalized document (such as, a standard letter, or envelope, or mailing label) is known as the main document.
Merge Document: When you merge the main document with data source, a third document called merge document.
(e) Compiler: The software (set of programs) that reads a program written in high level language and translates it into an equivalent program in machine language is called as Compiler.
Assembler: Assembly language programming is simpler and less time consuming than machine level programming, it is easier to locate and correct errors in assembly language than in machine language programs. It is also machine dependent. Programmers must have knowledge of the machine on which the program will run.
6. Answer the following:
(a) There is a document which has been edited and
saved in three word documents of Page 5, 10 and 15 respectively with files name
as NIOS-1, NIOS-2 and NIOS-3.
Write the steps for: 4
(i) To print the document as a single document having page numbers in the bottom of the page and starting from second page.
(ii) Page Header should have National institute of Open Schooling.
(iii) Page Footer should have Printed by: SSS Printers.
Ans. (a) (i) Changing start value of page number in a document:
(a) Place the cursor in the bottom of the page.
(b) Select insert page number subtask on the main tab and the page numbers dialog box appears.
(c) Uncheck show number on first page and click on format in page numbers dialog box. The page number format dialog box appears.
(d) At the bottom of the page Number Format dialog box, click on the start at option box simple type ‘2’.
Printing a Document: To print a document follow the following steps:
(a) Open the document to be printed.
(b) Choose office buttonPrint command on the menu bar. The print dialog box will open. Select the option link print range, number of copes, printer name etc. see that printer is switched on and the paper is available in the printer tray.
(c) Click ok.
(ii) Follow these steps to add header in the Document:
(a) Select Insert ->Header and
Footer subtask menus on the main tab bar. Click on the Header or Footer option
as per the requirement.
(b) On selecting Header option, header toolbar will appear and the top of the page will highlighted as shown below.
(c) Type National Institute of Open Schooling in the header box.
(d) Click Ok.
(iii) Follow these steps to add Footer in the document:
(a) Select InsertHeader and Footer sub task menu on the main tab bar. Click on the Header or Footer option as per the requirement.
(b) On selecting Footer option Footer toolbar will appear.
(c) Type “SSS Printers in the Footer box.
(d) Click ok.
(b) Based on the following answer the following:
4
(i) (C1/2×D1)/A1
(ii) A2+(D2/2+C3)
(iii) (A4+ B4)/(C4/2)
(iv) [(A1-B4) + C1]/[(C4/2) + B4]
Ans. (i) 4, (ii) 66, (iii) 5, (iv) 1.66.
Solved Paper-III
Data Entry
Operations (336)
Time : 2 Hours Marks : 40
1. Mach the following and write your answer in the book:
½×6=3
2. Write in your answer book True/False for the following statements:
½×6=3
(a) Latest printers are slow and produce poor quality print.
(b) A file cannot be retrieved from Recycle Bin.
(c) Start -> All Programs -> Accessories -> Windows Explorer
Above sequence of commands is to be followed, if you want to open Windows Explorer window.
(d) Tools menu helps to see file details.
(e) Spell check feature can be used in Power Point presentation.
(f) Excel’s filtering and sorting techniques are used to arrange worksheet data more quickly and find desired result.
Ans- (a) (False)
(b) (False)
(c) (False)
(d) (False)
(e) (True)
(f) (True)
3. Define the following:
1×4=4
(a) Object Program
(b) Chart
(c) File Management
(d) Slide layout
Ans. (a) Object Program: The program written by the programmer in high level language is called source program and the program generated by the compiler after translation is called an object program.
(b) Chart: Charts are visual representations of data: Which help you understand, language and compare data. Excel allows to create 2 and 3 dimensional chart.
(c) File Management: The operating system manages creation and deletion of fills in the secondary storage devices, provides tools to maintain fills and controls the access to fills through file access authorization authentication.
(d) Slide Layout: The way different types of objects are arranged on slide is called the slide layout.
4. Write short notes on the following:
2×4=8
(a) Line Printer
(b) ISDN
(c) Selecting Text
(d) Format Painter
Ans (a) Line Printer: This printer prints one line at a time. The speed of line printers is measured in line per minute. Printing speed of these printers varies from 300-3000 lines per minute. The width of line is 15 Inches and the line has 96 to 160 characters. Different types of line printers are drum printers, chain printers and bond printers.
(b) ISDN (Integrated Services Digital character at the place where you want to insert Network): The process of connecting to server to access Internet is almost same as Dial-up, but it offers connectivity through the use of digital phone lines instead of Analog. It offers Internet connectivity at speeds of up to 128 Kbps, allows the user to receive or make calls simultaneously on the same line. ISDN comes through a regular telephone wire from the telephone pole on the street. The line combines two 64 Kbps channels to offer 128 Kbps bandwidth broken into three bands: One band for the ringing signal of your phone, one band for your telephone conversation, and one band for data transfer.
(c) Selecting Text: To make changes in a document it requires the selection of next before performing any operation on it. We can select text using the keyboard or the mouse in Ms-word.
(d) Format Painter: Microsoft word has a feature called format painter that allows a user to copy and paste formats much in the same way as text is copied and pasted.
5. Differentiate between the following:
2×2=4
(a) Inserting Text and Deleting Text
(b) Numbered List and Bulleted List
Ans. (a) Inserting Text and Deleting Text
Inserting Text: (i) Sometimes you need so insert text lines in a document without losing the previous information.
(ii) To insert text in between the per-typed text, place the mouse pointer to the right of the character at the place where you want to insert the text and start typing.
(iii) As you start typing the text, your existing text automatically keeps moving to the right.
Deleting Text: erax/delete unwanted character, text, sentence or paragraphs, you can do the following:
(i) Place the position of the mouse pointer to the left side of the character/word to be deleted.
(ii) Press the delete key.
(iii) Place the mouse pointer to the right side of the character/word to be deleted.
(iv) Press back space key.
(v) To delete a text, select the text to be deleted and press delete key.
(b) Numbered List and Bulleted List
Ans-
6. Answer the following questions:
2×5=10
(a) Write the steps to delete a file or a folder.
(b) Write the steps to move the selected text.
(c) How is a merge document created?
(d) What is the importance of formulas in any spread-sheet program ?
(e) Write the steps to create a Bulleted list.
Ans. (a) The steps to delete a file or Folder are:
Step 1: Double-click “My Computer”. Find the File or Folder you want to delete, and then click it.
Step 2: On the File menu, Click delete or choose delete from shortcut menu.
(b) To move the selected text in word, follow these steps:
Step 1: Select the text.
Step 2: Choose out either from short and menu (that gets displayed by light clicking on the mouse) or from standard tool bar.
Step 3: Place the cursor (Insertion point) where the text is to be moved.
Step 4: Click paste (either from shorthand menu or from standard toolbar).
And your selected text gets moved at the desired position.
(c) Mail merge feature actually merges main document, with a data source. The main document stores the original text with data area at appropriate places. These data areas are successively filled by the information in the data source and the merged document is printed.
(d) Formulas are the entries or expressions in a worksheet that define relationship between two or more cells or values. An excel formula always begins with an equal to (=) sign and may include cell references, values and functions combined with the help of Mathematical or logical operators.
(e) To create a Bulleted list follows the given steps:
Step 1: Select the paragraphs to which you want to apply bullets.
Step 2: Select format Bullets and numbering option. The bullets and numbering dialog box will open.
Step 3: Click on the bulleted tab and selected the type of bullets that you want to apply.
Step 4: Click on the OK button.
7. (a) Write the key combinations which you will press to do the following actions in a word document:
2×2=4
(i) To make the text bold.
(ii) To make the text all caps.
(iii) To replace a word.
(iv) To create a new file.
(b) “Screen saver is a program that starts a animation after a period of inactivity.”
In the above sentence two words are missing which are to be inserted before the Bold words. Write the steps to insert these words which are given below:
(i) utility before program.
(ii) predefined before animation.
Ans. (a) (i) To make the text Bold -> Ctrl + B
(ii) To make the text all caps -> Shift + Ctrl + A
(iii) To replace a word -> Ctrl + H
(iv) To create a new file -> Ctrl + N
Ans- (b) Sometimes we need to insert text lines in a document without losing the previous Information. To insert text in between “screen saver is a and program” place the mouse pointer to the right of the sentence i.e. “screen saver is a * and start typing the missing word “utility” As cell start typing the text, our existing text automatically keeps moving to the right. All will repeat the same process to insert the another missing world “Predefined” before “animation”.
8. Answer the following:
2×2=4
(a) Write the steps to plot a column chart for the data given in the table below which shows the distance of five cities from Chandigarh:
Ans. To create a column chart enter the given data which shows the distance of five cities from Chandigarh.
(i) Select the range of cells containing data.
(ii) Click chart from standard tool bar.
(iii) A window of chart wizard appear on the screen along with the chart type. A preview is shown, of a chart, on which the type is selected. By default, it is set to column chart and the preview is shown on the right side of the window.
(iv) Select the column chart and click next.
(v) Select the row or column and click next.
(vi) Enter the chart title, x-axis and y-axis, title etc. and click next.
(vii) Specify whether you want to place it in a new sheet or in same sheet click finish. Thus the required chart is placed at the desired position.
(b) Based on the above data write the formula to calculate the following:
(i) Net pay of GM by using the formula as Net
Pay = (Basic+DA+HRA)
Ans- Select the cell E6 and type the formula
= sum (B6:D6)
(ii) Net pay of clerk using the above formula.
Ans- Select the cell E2 and type the formula
= sum (B2:D2)
(iii) Average Net pay of AGM & DGM.
Ans- Select the cell E4 and type the formula
= Average (B4:D5)
(iv) Net pay of a Manager.
Ans- Select the cell E3 and type the formula
= sum (B3:D3)