Data Entry Operations 229 Solved Assignment 2021 - 22 | NIOS Secondary Solved Assignment (2021 - 22)

 NIOS Solved Assignments (2021-22)
Data Entry Operations 229 Solved Assignment 2021 - 22
Tutor Marked Assignment
Max Marks: 20

Note: (i) All questions are compulsory. The Marks allotted for each question are given beside the questions.

(ii) Write your name, enrollment numbers, AI name and subject on the first page of the answer sheet.

1. Answer any one of the following questions.            2
(a) Write a note on Computer language and its Classification. (See Lesson 1)

Ans: Answer any one question

(b) Write down the steps to delete a file or folder from the computer. (See Lesson 2)

Ans: Delete a file or folder

1.    Click on Start, and then click on My Documents

2.    Click on the file or folder you want to delete

3.    Under File, click Delete.

4.    Files or folders can also be deleted by right-clicking the file or folder and then clicking Delete.

5.    Deleted files or folders are stored in the Recycle Bin, till they are permanently removed from the Recycle Bin.

6.    To retrieve a deleted file, double-click the Recycle Bin icon on the desktop. Right-click on the file to retrieved, and then click Restore.

7.    To permanently delete a file, press and hold down SHIFT and drag it to the Recycle Bin.

2. Answer any one of the following questions.                  2
(a) Write any two uses of ruler in Word Program. (See Lesson 3)

Ans: The rulers display horizontal and vertical scales that reflect the width and height of your typing area. The horizontal scale is in valuable when you want to quickly set tabs, margins and indents.

i)      It is used for draw the table, making results and assignments etc.

ii)    It is used for lining.

डाटा एंट्री ऑपरेशन (229) | Data Entry Operations 229 NIOS Free Solved Assignment 2021 – 22 (Hindi Medium)

(b) Describe the following: (See Lesson 2)

(i) Recycle Bin

(ii) Quitting a Programme

Ans: Answer any one question

3. Answer any one of the following questions.                   2
(a) Define: (i) Navigating worksheet (ii) Insert cells and rows (See Lesson 6)

Ans:

(i) Navigating worksheet: You can advance through your worksheet by rows with the vertical scrollbar or by columns with the horizontal scrollbar. When you click and drag the thumb tab on the scrollbar, a Screen Tip will appear alongside the bar identifying the row or column to which your view is advancing.

(ii) Insert cells and rows: Select the cell or the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells where you want to insert the new blank cells. Select the same number of cells as you want to insert. For example, to insert five blank cells, you need to select five cells.

(b) What are the shortcuts for selecting? (See Lesson 4)

(i) A whole word

(ii) Whole paragraph

(iii) Cutting the text

(iv) Printing the document

Ans: Answer any one question

4. Answer any one of the following questions.                    4
(a) Write the steps to set a password for a Workbook. (See Lesson 6)

Ans: Set a password for a workbook

1.    Click the Microsoft Office Button, and then click Save As.

2.    Click Tools, and then click General Options.

3.    Do one or both of the following:

a)    If you want reviewers to enter a password before they can view the workbook, type a password in the Password to open box.

b)   If you want reviewers to enter a password before they can save changes to the workbook, type a password in the Password to modify box.

4.    If you don’t want content reviewers to accidentally modify the file, select the Read-only recommended check box. When opening the file, reviewers will be asked whether or not they want to open the file as read-only.

5.    Click OK.

6.    When prompted, retype your passwords to confirm them, and then click OK.

7.    Click Save.

8.    If prompted, click Yes to replace the existing workbook.

(b) Explain briefly any five components of a chart. (See Lesson 8)

Ans: Answer any one question

5. Answer any one of the following questions.                   4

(a) How do you insert a picture bullet in slides? (See Lesson 9)

Ans: Picture bullets attract more attention to a slide than the normal number or dot bullets.

a)    Open a new or an existing presentation and go to the slide and select the text where bullets need to be added.

b)   Go to the Home tab on the ribbon and click on the arrow adjacent to ‘bullets’ button.

c)    There is a drop-down showing ‘Bullets and Numbering’ option. This will open another dialog box. On the right-hand bottom corner, there is a ‘Picture’ button.

d)   On clicking the ‘picture’ button, user is given three options from where a picture can be selected: online pictures, from a file, and icons.

e)   Choose an option and select the relevant picture. Once, back on the slide the bullet style would have changed as per our selection.

(b) “ABC School" is organising an Inter School competition. The Student Committee of the school have to design the brochure for the same. Help the students with the following options to be added on the banner: (See Lesson 4)

(i) Save the document with the name "Sports Day" on desktop.

(ii) Add the page border to the document.

(iii) Add colour to background of the page.

(iv) Set the margins to .4.

(v) Add the printable images from the internet to make it beautiful.

Ans: Answer any one question

6. Prepare any one project out of the following projects given below.       6
(a) Create an Excel sheet and answer the following questions: (See Lesson 8)

	A		B		C	D		E
1	ABC Grocery Shop
2	S. no	Item		Qty		Rate	Total
3	1	Soap		23		10
4	2	Detergent		24		45
5	3	Tooth Paste		8		12
6	4	Dettol		12		10
7	5	Butter		12		14
8	6	Refined		16		10

(i) Create the above sheet and save the file.

(ii) Write the formula in cell E3, to calculate the total amount which is Qty* Rate.

(iii) Write the formula in cell C3, to print the maximum qty.

(iv) Write the steps to create the bar chart of the rate with item on y axis.

(b) Create a PowerPoint presentation on “Operating Systems”. It must include the following (one slide each): (See Lesson 9)

(i) What is operating system? Add the image for the same.

(ii) Types of Operating System

(iii) Computer Operating System

(iv) Mobile Operating System

Solution: (i)

(ii)

(iii)

(iv)

***