Solved Paper-II
Data Entry Operations (336)
(Theory)
Time : 2 Hours
Marks : 40
1. Fill in the blanks of the following:
½×10=5
(i) ……..…packages are the application that are developed to meet the specific requirements of an organization.
(ii) There are ………. Types of elements inside the text box in a slide.
(iii) An URL indicates where the webpage is stored on the ………
(iv) We can log on to computer or to network Through………… screen.
(v) Word Processing Software is a software which falls under ………… packages.
(vi) The………. page of Website is called a homepage.
(vii) By default files gets downloaded in the ………….. folder of the user system.
(viii) An example of interactive web page is ………..
(ix) ………… monitors are also known as flat panel monitor.
(x) The program written by the programmer in high level language is called..…….. program.
Ans- (i) Customized packages are the application that are developed to meet the specific requirements of an organization.
(ii) There are many types of elements inside the text box in a slide.
(iii) An URL indicates where the webpage is stored on the internet.
(iv) We can log on to computer or to network through log-in screen.
(v) Word Processing Software is a software which falls under Ms Office packages.
(vi) The first page of Website is called a homepage.
(vii) By default files gets downloaded in the custom binders folder of the user system.
(viii) An example of interactive web page is home page.
(ix) Liquid crystal display (LCD) monitors are also known as flat panel monitor.
(x) The program written by the programmer in high level language is called source program.
2. State True or False :
½×10=5
(i) Chatting is a real time communication application of internet.
(ii) When you start a Computer system, Start and Taskbar appears on the top of the Screen.
(iii) It is possible to specify mathematical relationship between the numbers using the formula.
(iv) All data fields of a data source should be used for mail merge.
(v) Packets are never reassembled at the receiving end.
(vi) The cell address Bl denotes column B and Row 1.
(vii) CRT monitors looks like a TV screen and Works in the same way.
(viii) Mouse is an Input Device.
(ix) Under Edit Menu you can rename the file.
(x) It is not necessary to give password to protect a file from reviewers.
Ans- (i) True, (ii) False, (iii) True, (iv) False, (v) False, (vi) True, (vii) True, (viii) True, (ix) False, (x) False.
3. Define the following terms: (any two)
1×2=2
(a) Spreadsheet
(b) Recycle bin
(c) Task bar
Ans. (a) Spreadsheet: A spreadsheet is a large sheet having data and information arranged in rows and columns. Excel is one of the most widely used spreadsheet applications. It is a part of Microsoft Office suite. Spreadsheet is quite useful in entering, editing, analysing and storing data. Arithmatic operations with numerical data such as addition, subtraction, multiplication and division can be done using Excel. You can sort numbers/characters according to some given criteria (like ascending, descending etc.) and use simple financial, mathematical and statistical formulas.
(b) Recycle bin: Windows have a provision of trash can where you can keep all your deleted items. You can delete the object you do not need and window will put them in the trash can called recycle bin which is placed on your desktop. Windows keep 10% space of the hard disk for recycle bin. All the deleted items will remain in the recycle bin until you empty the bin.
(c) Task bar: When you start the computer system, then start and task bar appears on the bottom of the screen and by default remains visible when Windows is running. Whenever a program is run or a window is opened, an icon representing the program appears on the taskbar. To switch between windows or program, click on the icon representing the window on the task bar. When the program or window is closed, the icon disappears from the task bar.
4. Write short notes on the following:
2×5=10
(a) Rulers
(b) Input Devices
(c) Components of E-mail address
(d) Line Charts
(e) Steps to insert a text box in a slide
Ans- (a) Rulers: The rulers display horizontal and vertical scales that reflect the width and height of your typing area. The horizontal scale is invaluable when you want to quickly set tabs, margins, and indents.
(b) Input Devices: Input devices accept data and instructions from the user. Following are the examples of various input devices, which are connected to the computer for this purpose:
1. Keyboard
2. Mouse
3. Light Pen
4. Optical/magnetic
5. Touch Screen Scanner
6. Microphone for voice as input
7. Track Ball
(c) Components of E- mail address
theopenpublication@yahoo.com
First part is the User ID (theopenpublication) that refers to the recipient’s mailbox. Then there is an at sign (@). Next comes the host name (yahoo), also called the domain name. This refers to the mail server, the computer where the recipient has an electronic mailbox. It is usually the name of a company or organization. The end of the domain name consists of a dot (“”) followed by three or more letters (such as .com and .gov) that indicate the top-level domain (TLD). This part of the domain name indicates the type of organization or the country where the host server is located.
(d) Line Charts: Data represented in columns or rows in a worksheet can be plotted with the help of line chart. Line charts can be used to display continuous data over time with respect to a common scale. Thus Line Charts are best suitable for viewing data trends at equal intervals of time. The horizontal axis is used to represent the category data and all the value data is distributed uniformly along the vertical axis.
(e) Steps to insert a text box in a slide: If you want to add a new text box to the slide, select Insert Text Box command on the menu bar and then draw the text box with the mouse at a place where you want to insert the text box.
If you want to resize a text box, follow the Steps given below:
(i) Select the text box you wish to resize by clicking on it with the mouse. A border with eight handles will appear around the text box. The four handles on the corners will resize the length and width of the box at once while the handles on the sides will resize only in one direction.
(ii) Click one of the handles as per your requirement and drag it with the mouse. Release the mouse button when it is the size you want to be. Move the text box by clicking and dragging the thick dotted border with the mouse.
5. Differentiate between the following (specify two differences in each) :
2×5=10
(a) Sum () funclion and Sumif () Function
(b) Telnet and FTP
(c) Application Software and System Software
(d) Main Document and Data Source
(e) Windows Explorer and Controt Panel.
Ans. (a) Sum () funclion: Adds all the numbers in a range of cells.
Syntax SUM(number1,number2, …)
Maximum number of arguments can be 255 i.e.
Number1, number2… number 255.
Sum function is having different forms. You Can choose as per your need.
SUMIF (range, criteria, sum_range) : This form of sum functions is used to add the cells with respective to a given criteria.
Range: A group of adjacent cells within a range must be numbers or names, arrays, or references which are having numbers. In sumif function the blank and text values are ignored.
Criteria: It can be a number, expression, or text to define which cells will be considered for the addition e.g. criteria can be fixed as 12, “12”, “12”, or “mangoes”.
Sum_range: These are the actual cells to be added if their corresponding cells in range match criteria. In case the sum_range is avoided, then the cells in range are both evaluated by criterial and added if they match criteria.
(b) Telnet: Telnet is a network protocol used on the Internet or local area network LAN connections. The Telnet program runs on your computer and connects your PC to a server on the network. You can then enter commands through the Telnet program and they will be executed as if you are entering them directly on the server console. This enables you to control the server and communicate with other servers on the network. To start a Telnet session, you must log in to a server by entering a valid username and password. Telnet is a common way to remotely controlled Web servers.
FTP: FTP or File Transfer Protocol is a commonly used protocol for exchanging files over any network that supports the TCP/IP protocol (such as the Internet or an Intranet).
(c) Application Software: Application software is a set of programs, which are written to perform specific tasks, for example: An application package for managing library known as library information system is used to manage information of library such as: keeping book details, account holder details, book issue details, book return details exc. Another application package for managing student details is called student’s information system, manages student’s roll no, name, parents name, address, class, section, processing of examination results etc.
Application software can be broadly classified into two types:
(a) Generalized packages.
(b) Customized packages.
System Software: When you switch on the computer the programs stored in ROM are executed which activates different units of your computer and makes it ready for you to work on it. This set of programs can be called system software. System softwares are sets of programs, responsible for running the computer, controlling various operations of computer systems and management of computer resources. Operating System (OS) falls under this category.
(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.
Data Source : Data source is a file that contains the names and addresses or any other information that vary with each version of a mail-merge document. For example, a list of names and addresses for a form letter you want to send to a list of clients or other people.
(e) Windows Explorer: File management in windows can be done through Windows explorer or My Computer. Windows Explorer displays the hierarchical list of files, folders, and storage drives (both fixed and removable) on your computer. It also lists any network drives that have been mapped to as a drive letters on your computer. Windows Explorer can be used to copy, move, rename, and search for files and folders.
Controt Panel: Displays a list of utility configure the computer system and install software and hardware.
6. Answer the following:
(a) What is page formatting? List any 3 features/options used for page formatting and explain any 2 features/options in details?
4
Ans- In page formatting, we can design pages suiting to our needs. For instance, the page setup options which include paper size and page orintation etc. are normally set either by you on by default at the beginning of the opening a new document. These options are available under page layout tab and can eisily be changed at any time according to your needs.
The there features of page formating are:
1. Page size and Orientation: Change the orientation of a page within the Page Setup dialog box.
2. Select Page Layout : Size command on the main tab bar and choose from the available the Letter, Legal or A4 size as per requirement. Should need to look at more options, click on the More Paper Sizes from the size sub task.
3. Headers & Footers: A header is text that is added to the top margin of every page such as a document title on page number and footer is text added to the bottom margin.
(b) Based on the following data, find the Values of the expressions :
1×4=4
(i) (C1/2×D1)/A1
(ii) A2+(D2/2 +C3)
(iii) (A4+ B4)/((C4/2)-3)
(iv) [(A1-B4) + C1]/[(C4/2) + B4]
Ans. (i) 4, (ii) 53.5, (iii) 4, (iv) 7.