Class 12 Data Entry Operations (336) Solved Free Assignment 2024-25 (NIOS)

1. Answer any one of the following questions in about 40-60 words.

i. Sunidhi is entering the data in a spread sheet. She wants to change the format of the date and time. Help her with the steps to change date and time in a cell. (See Lesson 7)

Ans:- To change the format of the date and time in a spreadsheet, follow these steps:

1. Select the cell(s) containing the date or time.
2. Go to the Format menu and choose Number or right-click and select Format Cells.
3. From the options, select Date or Time and choose the desired format.
4. Click OK to apply the changes.

ii. Pravesh and his friends are living in the same at and they use the same computer. Pravesh has created a document and saved as “Personal Data” on the desktop. He wants to keep the document safe from his friends. Write down the steps mentioned in the protection feature provided by MS-Word that he must use. (See Lesson 3)

Ans:- To protect the "Personal Data" document in MS Word, Pravesh can follow these steps:

1. Open the document in MS Word.
2. Click on File and select Info.
3. Click on Protect Document and choose Encrypt with Password.
4. Enter a strong password and click OK.
5. Re-enter the password to confirm and click OK again.

Now, the document is password-protected.

2. Answer any one of the following questions in about 40-60 words.

i. Aman saved a document “Application” on his computer. He wants to take the print of the document but he is not able to nd the document. List the various steps to search for a le or a folder to help Aman. (See Lesson 2)

Ans:-  To help Aman search for his "Application" document, follow these steps:

1. Open the File Explorer on the computer.
2. In the search bar at the top right, type Application and press Enter.
3. Check the search results to locate the file.
4. If needed, refine the search by specifying the folder or drive where the file might be saved.

ii. Riya is working on a worksheet and changing the data in few columns. She wants to hide the other columns to prevent unwanted changes. List out the steps she should follow to hide those specic columns. (See Lesson 7)

Ans:- To hide specific columns in a worksheet, Riya can follow these steps:

1. Select the columns she wants to hide by clicking on their headers (e.g., A, B, C).
2. Right-click on the selected column headers.
3. From the context menu, choose Hide.

The selected columns will now be hidden and can be unhidden later if needed.

3. Answer any one of the following questions in about 40-60 words.

i. Mohini has created a le named “office ”. She wants to rename the le as “New Office ”. List out the various steps to rename or a folder. (See. (See Lesson 2)

Ans:- To rename the file "office" to "New Office," Mohini can follow these steps:

1. Locate the file "office" using File Explorer.
2. Right-click on the file and select Rename from the context menu.
3. Type the new name, New Office, and press Enter.

The file will now be renamed successfully.

ii. Write the keyboard shortcut keys of the following. (See Lesson 3) 

a) Close a  file

b) Save As 

c) Left Alignment 

d) Page Break 

Ans:- Here are the keyboard shortcuts for the mentioned actions:

a) Close a file: Ctrl + W
b) Save As: F12
c) Left Alignment: Ctrl + L
d) Page Break: Ctrl + Enter

4. Answer any one of the following questions in about 100-150 words.

i. What do you understand by Typing Screen Objects? Dene Insertion Point, Mouse Pointer and End-of-document Marker with reference to Typing Screen Objects. (See Lesson 3)

Ans:- Typing Screen Objects refer to the various elements visible on a typing interface, such as in a word processor, which help users interact with and manage their text efficiently. Key components include:

1. Insertion Point: The blinking vertical line on the screen that indicates where the next character will be typed or inserted. It moves as you type or when you reposition it using the keyboard or mouse.

2. Mouse Pointer: The arrow or cursor visible on the screen, controlled by the mouse. It allows users to select text, click on commands, or reposition the insertion point by clicking in the desired location.

3. End-of-document Marker: A small symbol or marker that indicates the end of the document. It helps users know where the content ends and provides a visual cue for navigation.

These objects enhance the user experience by providing clarity and control while working with text documents.

ii. Ramesh is working on a worksheet. He wants to do the following in the worksheet. Help him with the steps. (See Lesson 6) 

a) Delete cells , rows and columns 

b) Set a row to a specic Height

Ans:- Here are the steps to assist Ramesh with his tasks in a worksheet:

a) Delete Cells, Rows, and Columns:

1. To delete cells:

   • Select the cells you want to delete.
   • Right-click and choose Delete.
   • Select Shift cells left or Shift cells up and click OK.

2. To delete rows:

   • Select the row(s) by clicking the row header on the left.
   • Right-click and choose Delete.

3. To delete columns:

   • Select the column(s) by clicking the column header on top.
   • Right-click and choose Delete.

b) Set a Row to a Specific Height:

1. Select the row(s) you want to adjust.
2. Right-click on the selected row header and choose Row Height.
3. Enter the desired height value in the box and click OK.

These steps will help Ramesh manage his worksheet effectively.

5. Answer any one of the following questions in about 100-150 words. 

i. Hina wants to install software in her computer. Help her to install the software, and state the steps to do so. But she made a mistake in installing the software, and now she wants to remove the installed software. List the steps to uninstall the software. (See Lesson 2) 

Ans:- Here’s how Hina can install and uninstall software on her computer:

Steps to Install Software:

1. Download the software installation file from a trusted source.
2. Double-click the downloaded file to open the installer.
3. Follow the on-screen instructions, such as selecting the installation location and agreeing to the terms.
4. Click Install to begin the installation process.
5. Wait for the installation to complete and click Finish.

Steps to Uninstall Software:

1. Open the Control Panel (search for it in the Start menu).
2. Navigate to Programs > Programs and Features.
3. Locate the software in the list of installed programs.
4. Select it and click Uninstall.
5. Follow the prompts to complete the uninstallation.

This process ensures proper installation and removal of software to keep the computer functioning optimally.

ii. Abhishek is working on a large worksheet. He wants to make the column headings visible all the time. Explain how he can use freeze pane and also mention the advantages of using freeze pane using suitable example. (See Lesson 6 )

Ans:- To ensure column headings are visible while working on a large worksheet, Abhishek can use the Freeze Panes feature. Here's how:

Steps to Use Freeze Panes:

1. Open the worksheet and scroll to ensure the column headings are visible.
2. Click on the cell just below the row containing the column headings (e.g., if headings are in Row 1, select cell A2).
3. Go to the View tab on the ribbon.
4. Click on Freeze Panes and select Freeze Panes from the dropdown menu.

Now, the column headings will remain visible as Abhishek scrolls through the worksheet.

Advantages of Freeze Panes:

• Improved Navigation: Helps identify data in rows or columns without losing track of headings.
• Better Data Management: Makes working with large datasets easier by ensuring key information (e.g., "Name," "ID," "Marks") is always accessible.

Example: In a student database with 500 rows, freezing the first row ensures that the column headers (e.g., "Name," "Roll Number") remain visible while scrolling down.)

6. Prepare any one of the following projects in about 500 words.

i. Radha needs to demonstrate to her friends, the functioning of a word processor. Help her in performing the following steps: (See Lesson 3)

a) Create a new document from the menu bar (using the prescribed short cut key). Also write the steps.

b) Save the created document with the name “My document” and then close it. Also write the steps.

c) Open the already created “My document” and rename it as “My renamed document”. Also write the steps.

Ans:-  

Demonstration of Word Processor Functionality for Radha

Radha can demonstrate the functioning of a word processor to her friends by performing the following tasks:

a) Create a New Document from the Menu Bar (Using Shortcut Key)

To create a new document in a word processor, follow these steps:

1. From the Menu Bar:

   • Open the word processor (e.g., Microsoft Word).
   • Click on the File tab in the menu bar.
   • From the dropdown menu, click New.
   • In the New Document window, select Blank Document and click Create.

2. Using the Shortcut Key:

   • Press Ctrl + N on the keyboard. This will immediately open a new blank document.

This action creates a fresh document where Radha can start typing or inserting any data she wishes.

b) Save the Created Document with the Name “My Document” and Close It

After creating a new document, Radha will save and close it by following these steps:

1. To Save the Document:

   • Click on the File tab in the menu bar.
   • Select Save As from the options.
   • Choose a location on the computer where the file should be saved (e.g., Desktop or Documents folder).
   • In the "File Name" field, type My Document.
   • Click Save.

   Alternatively, she can use the shortcut key Ctrl + S to save the document quickly. If it's the first time saving, it will prompt her to choose the file name and location.

2. To Close the Document:

   • Click on the File tab and select Close.
   • Alternatively, Radha can click the X button on the top right corner of the word processor window to close the document.

c) Open the Already Created “My Document” and Rename It as “My Renamed Document”

To open an existing document and rename it, Radha can follow these steps:

1. To Open the Document:

   • Click on the File tab in the menu bar.
   • Select Open from the options.
   • Browse the location where the document "My Document" was saved (e.g., Desktop or Documents folder).
   • Select My Document and click Open.

2. To Rename the Document:

   • Once the document is open, click on the File tab again.
   • Select Save As to save a copy of the document under a new name.
   • In the "File Name" field, change the name to My Renamed Document.
   • Choose the same location or a different one and click Save.
   • After saving the new file with the desired name, Radha can delete or move the original document, if necessary, to avoid confusion.

By following these steps, Radha can demonstrate how to create, save, open, and rename documents in a word processor. These basic functions are essential for working with digital documents and will help her friends understand the core features of word processing software.

ii. A class teacher keeps a spreadsheet for student’s data on his laptop showing with the basic details and their marks. Below is the table showing a part of the spreadsheet: (See Lesson 6, 7)

a) Create and save the above le as “Class 12 Record”. 

b) Write the formula in cell I3 to calculate the Total. 

c)  Name the column which the spreadsheet has been sorted on. 

d)  Write the steps to sort the data on Student Name 

e)  Write the formula in cell J3 to calculate Avg by adding cells from E3 to H3 and then divide by 4.

f) Write the steps to delete this spreadsheet. 

Ans: - 

a) Create and Save the Above File as "Class 12 Record"

To create and save the file as "Class 12 Record," follow these steps:

1. Open a spreadsheet program like Microsoft Excel or Google Sheets.
2. Enter the student data in the cells as shown:
   • A1: Student Name
   • B1: Class
   • C1: Gender
   • D1: Hindi
   • E1: English
   • F1: Maths
   • G1: Science
   • H1: Total
3. Fill in the data for each student in rows 2 to 7.
4. After entering all the data, click on File > Save As (in Excel) or File > Download (in Google Sheets).
5. Name the file as "Class 12 Record" and choose a location to save it.

b) Write the Formula in Cell I3 to Calculate the Total

To calculate the total marks, use the following formula in cell I3:

=SUM(D3:G3)

This formula adds the marks from Hindi (D3), English (E3), Maths (F3), and Science (G3) for the first student and displays the total in cell I3. Copy this formula for other students in the rows below.

c) Name the Column Which the Spreadsheet Has Been Sorted On

If the spreadsheet has been sorted by Student Name, the Student Name column (Column A) is the one on which the sorting is done.

d) Write the Steps to Sort the Data on Student Name

To sort the data based on Student Name, follow these steps:

1. Select all the data, including the headers (A1:H7).
2. Click on the Data tab in the menu.
3. Click on Sort.
4. In the dialog box, select Student Name (Column A) from the "Sort by" dropdown list.
5. Choose the order (A-Z for ascending or Z-A for descending).
6. Click OK.

The data will now be sorted based on the student names.

e) Write the Formula in Cell J3 to Calculate Average by Adding Cells from E3 to H3 and Then Divide by 4

To calculate the average of the marks from E3 to H3, use this formula in cell J3:

=AVERAGE(E3:H3)

This formula calculates the average of the marks for the first student in the range of cells from E3 to H3. You can drag this formula down to calculate the average for all students.

f) Write the Steps to Delete This Spreadsheet

To delete the spreadsheet, follow these steps:

1. If you're using Microsoft Excel, close the file.
2. Go to the folder where the file is saved (e.g., Desktop or Documents).
3. Right-click on the file "Class 12 Record".
4. Click on Delete from the context menu.
5. The file will be moved to the Recycle Bin. To permanently delete it, empty the Recycle Bin.

If you're using Google Sheets, you can delete the file by:

1. Going to Google Drive.
2. Right-click on the "Class 12 Record" file.
3. Click Remove.
4. The file will be moved to the Trash. To permanently delete it, go to Trash and click Empty Trash.