Nios Class 10th Data Entry Operations Solved Previous Year Question Paper in English Medium

Answer: (a) – (iv)

(b) – (v)

(c) – (vi)

(d) – (i)

(e) – (ii)

(f) – (iii)

Question 2.

Answer: (a) False, the program written by the programmer in a high-level language is called the source code. The source code is then compiled or interpreted to create an executable object program that can be run on a computer.

An object program is typically the result of the compilation process in which the source code is translated into machine code or bytecode. Object programs are usually not directly executable by the computer but require further processing, such as linking with other object programs and libraries, to create an executable program.

(b) True, utilities are an example of system software.

System software refers to software programs that provide a platform or environment for application software to run. It includes operating systems, device drivers, firmware, and various system utilities.

Utilities are system software programs that perform specific tasks related to the maintenance and management of a computer system. Examples of utilities include disk defragmenters, antivirus software, backup and recovery tools, file compression programs, system cleanup and optimization tools, and many others.

Utilities are typically designed to be run by system administrators or advanced users to manage and optimize system performance and functionality.

(c) True, the indexing service provided by the search function maintains an index of all files on a computer.

When a user performs a search for a specific file or keyword, the search function uses the index to quickly locate the relevant files, instead of scanning the entire hard drive. The index contains information about the file name, location, size, and other attributes that help the search function to retrieve the desired results quickly.

The indexing service periodically updates the index to include new files and changes to existing files, ensuring that the search function provides up-to-date search results. The indexing service is typically built into the operating system and can be configured to exclude certain files or directories from the index.

(d) False, this statement is not accurate. Windows does allow you to add new hardware components to your computer.

When you add new hardware to your computer, such as a graphics card, sound card, or printer, Windows can detect the new hardware and automatically install the necessary drivers for it. If Windows is not able to detect the new hardware automatically, you can manually install the drivers using the Device Manager.

(e) False, In Excel worksheet, columns are designated by letters, not numbers.

Each column in an Excel worksheet is identified by a letter or a combination of letters starting with “A” and ending with “XFD” (in Excel 2019 and later versions). For example, the first column in a worksheet is column A, the second column is column B, and so on.

Rows, on the other hand, are designated by numbers. The first row in a worksheet is row 1, the second row is row 2, and so on.

The combination of a column letter and a row number specifies a cell in the worksheet. For example, cell A1 refers to the top-left cell in the worksheet, cell B3 refers to the cell in the second column and the third row, and so on.

(f) True, it is possible to save a presentation as a webpage in some presentation software programs.

For example, in Microsoft PowerPoint, you can save a presentation as a webpage by following these steps:

Click on the File menu and select Save As.

Choose a location where you want to save the webpage and give it a name.

In the “Save as type” dropdown list, select “Web Page (*.htm; *.html)”.

Click the Save button to save the presentation as a webpage.

Question 3.

Answer: (a) Define COBOL: COBOL (Common Business-Oriented Language) is a high-level programming language designed primarily for business applications. It was first introduced in 1959 and has since become one of the most widely used programming languages in the world. COBOL is known for its readability and ease of use, as it was designed to be easily understood by non-technical personnel, such as business managers and accountants. COBOL programs are commonly used for processing large amounts of data and performing complex calculations, such as those required for financial, accounting, and inventory management systems. Despite being over 60 years old, COBOL is still widely used in many industries and continues to play an important role in modern business computing.

(b) Windows Explorer?

Ans. Windows Explorer is a file management tool that is included with the Microsoft Windows operating system. It provides users with an interface for navigating and managing files and folders on their computer or network. Windows Explorer allows users to create, delete, rename, copy, and move files and folders, as well as search for files based on various criteria such as name, date modified, or file type. It also provides access to system files and settings, control panel, and other administrative tools. In more recent versions of Windows, such as Windows 10, Windows Explorer has been replaced by File Explorer, which provides similar functionality with a more modern user interface.

(c) Elements of formula in Excel Spreadsheet?

Ans. Elements of a formula in an Excel spreadsheet are the individual components that make up the formula. These elements include:

1. Cell references: These are references to specific cells in the spreadsheet. Cell references are identified by their column letter and row number, such as A1, B2, etc.
2. Operators: These are symbols that perform mathematical operations such as addition (+), subtraction (-), multiplication (*), division (/), and exponentiation (^).
3. Functions: These are predefined formulas that perform specific operations, such as calculating the average of a range of cells, counting the number of cells that meet certain criteria, or finding the maximum or minimum value in a range of cells. Functions are identified by their name, such as SUM, AVERAGE, MAX, etc.
4. Parentheses: These are used to group elements of a formula together and control the order of operations.
5. Constants: These are fixed values that are used in a formula, such as numbers or text strings.
6. Cell ranges: These are a group of cells that can be referred to as a range, such as A1:A10.

By combining these elements in different ways, you can create complex formulas in Excel that perform a wide range of calculations and data manipulations.

Top of Form

(d) Title Slide?

A title slide is the opening slide of a presentation, typically used to introduce the topic, presenter, and other key information about the presentation. It often includes the title of the presentation, the name of the presenter, and the date of the presentation. The title slide is important because it sets the tone for the rest of the presentation and helps the audience to understand what to expect. In addition to the title and presenter information, a title slide may also include a background image or graphic, a logo or branding element, or other visual elements that help to convey the theme or topic of the presentation.

Question 4.

Answer:

• Optical scanner?

An optical scanner, also known as a document scanner or image scanner, is a device that uses optical technology to create digital images of physical documents, images or objects. Optical scanners work by shining a light source onto the document or object and then using a series of mirrors and lenses to capture the reflected light and create a digital image. This digital image can then be saved and manipulated on a computer, allowing for easy storage and sharing of information. Optical scanners can be used to scan a wide range of materials, including paper documents, photographs, negatives, and even three-dimensional objects. They are commonly used in offices, libraries, and other organizations to create digital archives of important documents, as well as in medical facilities to create digital copies of X-rays and other medical images. Optical scanners can be standalone devices or can be integrated into other equipment, such as photocopiers or fax machines.

• Rename an existing folder?

Renaming an existing folder involves changing the name of the folder to a new name. To rename a folder in a computer file system, follow these steps:

1. Open the file explorer or folder that contains the folder you want to rename.
2. Find the folder you want to rename and right-click on it.
3. From the context menu, select “Rename” or left-click once on the folder name to highlight it and press the “F2” key on your keyboard.
4. The folder name will become editable. Type in the new name for the folder.
5. Press “Enter” or click outside the folder name to save the new name.

The folder will now have the new name that you provided. Note that renaming a folder does not affect the contents of the folder – only the name of the folder itself

• Options available in font dialog box?

The Font dialog box is a tool in many software applications that allows users to select a font and customize its appearance. Some of the options available in the Font dialog box may include:

1. Font type: This allows you to select the font that you want to use for the selected text. It may include options such as Arial, Times New Roman, and Calibri.
2. Font style: This allows you to select the style of the font, such as bold, italic, or underline.
3. Font size: This allows you to select the size of the font, typically measured in points.
4. Color: This allows you to select the color of the font, which can be customized by selecting a specific color or using a color picker.
5. Effects: This may include options such as strikethrough, subscript, and superscript.
6. Character spacing: This allows you to adjust the spacing between characters, such as by increasing or decreasing the letter spacing.
7. Language: This allows you to select the language for the selected text, which can affect the spell checker and other language-specific features.
8. Preview: This shows a preview of how the selected font and settings will look, allowing you to see the changes before applying them.

By using the options available in the Font dialog box, you can customize the appearance of your text to better suit your needs and preferences.

• Hiding slides in PowerPoint?

Hiding slides in PowerPoint means making certain slides in a presentation invisible during the presentation without deleting them. This can be useful when you have some slides that you want to keep in your presentation file, but do not want to show to your audience. Here are the steps to hide slides in PowerPoint:

1. Open the PowerPoint presentation that you want to edit.
2. Go to the slide sorter view by clicking on the “Slide Sorter” button in the bottom right corner of the PowerPoint window.
3. Select the slide or slides that you want to hide by clicking on them while holding down the “Ctrl” key on your keyboard.
4. Right-click on the selected slide(s) and choose “Hide Slide” from the context menu.
5. The selected slide(s) will now be grayed out and labeled “Hidden” in the slide sorter view.

When you run the slideshow, the hidden slide(s) will not be displayed. To unhide a slide, simply right-click on the slide in slide sorter view and select “Hide Slide” again to remove the checkmark.

Question 5.

Answer:

(a) Main Document and Data Source in Mailmerge.

Mail merge, the main document and data source are two important components that are used to create customized documents, such as form letters, mailing labels, or envelopes, for a large number of recipients.

The main document is the template document that contains the text and formatting of the final merged document. It typically includes placeholders or fields for the recipient information, such as name and address, that will be populated with data from the data source during the merge process. The main document may also include other text, graphics, and formatting that will be common to all merged documents.

The data source is the external file that contains the recipient information that will be merged into the main document. It is typically a spreadsheet or database that contains a list of recipients, along with their corresponding data fields, such as name, address, city, state, and ZIP code. The data source may also include other fields, such as email addresses, phone numbers, or other customized data that can be used in the merged document.

During the mail merge process, the main document and data source are combined to create customized documents for each recipient. The mail merge software uses the recipient data from the data source to fill in the placeholders or fields in the main document, creating a final merged document for each recipient.

(b) Find and Find ® Replace in Spreadsheet.

Top of Form

The Find Replace function allows users to search for specific data and replace it with new data. To use Find Replace, follow these steps:

1. Click on the “Find and Replace” button or press “Ctrl+H” on your keyboard to open the Find and Replace dialog box.
2. Enter the data you want to find in the “Find what” field and the data you want to replace it with in the “Replace with” field.
3. Choose any other options, such as searching for whole words only or matching case, if desired.
4. Click on “Replace” to replace the first instance of the data or click “Replace All” to replace all instances of the data.

By using the Find and Replace functions, users can quickly and easily find and modify data in their spreadsheets, saving time and improving accuracy.

Question 6.

• Write the steps to Autofit rows in Spreadsheet?

“Autofit Row Height” feature in Excel to automatically adjust the height of all rows in the worksheet based on their contents. Here are the steps to do this:

1. Select all the rows in the worksheet. You can do this by clicking on the “Select All” button (located above the row numbers and to the left of the column letters) or by pressing “Ctrl+A” on your keyboard.
2. Right-click on any of the selected row numbers and choose “Row Height” from the context menu.
3. In the “Row Height” dialog box, check the “Autofit” checkbox and click “OK”.
4. Excel will adjust the height of all rows in the worksheet based on the contents of the cells within them.

Autofitting rows can make your spreadsheet easier to read and more professional-looking, as it ensures that all content is visible and not hidden by row height limitations.

• Write the steps to highlight text in Microsoft Word?

You can highlight text in Microsoft Word to emphasize specific words or phrases, or to mark important sections of a document. Here are the steps to highlight text in Microsoft Word:

1. Open your Word document and select the text that you want to highlight. You can do this by clicking and dragging your mouse over the text, or by holding down the “Shift” key and using the arrow keys to select the text.
2. Click on the “Home” tab in the ribbon menu at the top of the screen.
3. Look for the “Font” group, which contains the “Text Highlight Color” button. It is represented by an icon that looks like a highlighter pen.
4. Click on the “Text Highlight Color” button to open the drop-down menu.
5. Choose the color you want to use to highlight the selected text. You can choose from several pre-set colors, or click “More Colors” to select a custom color.
6. The selected text will now be highlighted in the color you chose. You can also remove the highlighting by selecting the text and clicking the “Text Highlight Color” button, then choosing “No Color.”

By highlighting text in Microsoft Word, you can make important information stand out and improve the readability of your document.

• Write the steps to create numbered list in Microsoft Word?

You can highlight text in Microsoft Word to emphasize specific words or phrases, or to mark important sections of a document. Here are the steps to highlight text in Microsoft Word:

1. Open your Word document and select the text that you want to highlight. You can do this by clicking and dragging your mouse over the text, or by holding down the “Shift” key and using the arrow keys to select the text.
2. Click on the “Home” tab in the ribbon menu at the top of the screen.
3. Look for the “Font” group, which contains the “Text Highlight Color” button. It is represented by an icon that looks like a highlighter pen.
4. Click on the “Text Highlight Color” button to open the drop-down menu.
5. Choose the color you want to use to highlight the selected text. You can choose from several pre-set colors, or click “More Colors” to select a custom color.
6. The selected text will now be highlighted in the color you chose. You can also remove the highlighting by selecting the text and clicking the “Text Highlight Color” button, then choosing “No Color.”

By highlighting text in Microsoft Word, you can make important information stand out and improve the readability of your document

• Write the steps to rename a Worksheet in Excel Spreadsheet?

Renaming a worksheet in an Excel spreadsheet can be useful when you want to give it a more descriptive or relevant name. Here are the steps to rename a worksheet in Excel:

1. Open the Excel spreadsheet that contains the worksheet you want to rename.
2. Click on the worksheet tab that you want to rename. The worksheet tabs are located at the bottom of the Excel window, and are labeled with the default name “Sheet1,” “Sheet2,” and so on.
3. Right-click on the worksheet tab and choose “Rename” from the context menu. Alternatively, you can double-click on the worksheet tab to activate the rename mode.
4. The current worksheet name will be highlighted. Type the new name you want to give the worksheet and press “Enter” on your keyboard.
5. The worksheet will now be renamed with the new name you provided.

Alternatively, you can also rename a worksheet by clicking on the “Home” tab in the ribbon menu at the top of the screen, then selecting the “Format” drop-down menu in the “Cells” group. From there, choose “Rename Sheet” and type in the new name.

By renaming worksheets in Excel, you can help organize your spreadsheet and make it easier to navigate and understand

• Write any two ways by which you will be able to move between slides?

There are several ways to move between slides in Microsoft PowerPoint, but here are two common methods:

1. Using the Slide Navigation Pane: The Slide Navigation Pane is a panel that shows a thumbnail image of each slide in your presentation. To move between slides using the Slide Navigation Pane, follow these steps:

1. • Click on the “View” tab in the ribbon menu at the top of the screen.
   • Look for the “Presentation Views” group, which contains the “Normal” button. Click on the “Normal” button to switch to Normal View.
   • The Slide Navigation Pane should be visible on the left side of the screen. To move between slides, click on the thumbnail image of the slide you want to view.

1. Using Keyboard Shortcuts: Keyboard shortcuts can be a quick and efficient way to move between slides in PowerPoint. Here are some common keyboard shortcuts to try:

1. • To move to the next slide, press the “Page Down” or “Down Arrow” key on your keyboard.
   • To move to the previous slide, press the “Page Up” or “Up Arrow” key on your keyboard.
   • To jump to a specific slide, press “Ctrl” + “G” on your keyboard to open the “Go To Slide” dialog box. Then, type in the slide number you want to view and click “OK.”

By using these methods to move between slides in PowerPoint, you can easily navigate your presentation and keep your audience engaged.

Question 7.

Write the key combinations which you will press to do the following actions in a Word document :

• To make the text italic: Press “Ctrl” + “I” on your keyboard.
• To get the help menu: Windows + F1
• To go to the end of the line: Ctrl+End
• To open a file: Ctrl + O

 Answer (b) A paragraph containing text in Microsoft Word is written in Arial font and

aligned as center alignment. Write the steps to make the text in Times New Roman and justified.

Question 8. Answer the following : 2  2 = 4

(a) The following table shows the marks scored by a student in 5 subjects (English,

Hindi, Science, Maths and SST). Write the steps for creating a line chart with

the below given data to understand his performance in visual form.

The chart should have Title as “Performance Analysis”.

X axis should show “Subject”.

Y axis should show “Score”

Answer (a)

To create a line chart with the given data, follow these steps:

1. Open a spreadsheet software like Microsoft Excel or Google Sheets.
2. Enter the data in a table format. The table should have two columns, one for subjects and the other for scores. The table should look like this:

3. Select the two columns of data (subject and score).
4. Click on the “Insert” tab on the menu bar.
5. Select “Line Chart” from the “Charts” section.
6. A basic line chart will be created. Customize the chart by adding a title, labeling the x-axis and y-axis, and formatting the chart as needed.
7. To add a title to the chart, click on the “Chart Title” text box and type “Performance Analysis.”
8. To label the x-axis, click on the “Axis Titles” text box below the chart and type “Subject.”
9. To label the y-axis, click on the “Axis Titles” text box to the left of the chart and type “Score.”
10. Format the chart as desired, such as changing the colors of the lines or the style of the gridlines.

(b) The following table shows the rainfall recorded in five states during Oct. 2020.

Based on this data write function or formulas to find the following :

7. Total rainfall of all 5 states in cell B7.

 Ans : =SUM(B2:B6)

   = 2975

8. Maximum rainfall in cell B8.

  Ans : =MAX(B2:B6)

             = 800

• Average rainfall in cell B9.

Ans : =AVG(B2:B6)

 = 595

10. Minimum rainfall in cell B10.

Ans : =MIN(B2:B6)

 = 400