Data Entry (336)

Tutor Marked Assignment

20% Marks Of Theory

PDF is Paid

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

(a) Deepak has created one file “STUDENT” and kept this under another folder “SCHOOL”. After few days he wants to open the file “STUDENT” but he forgot the exact location of the said file. Write down the steps to locate the file “STUDENT”. 

(b) What do you mean by vertical and horizontal scroll bars in word processor?

2. What do you mean by vertical and horizontal scroll bars in word processor?

(a) List the various steps to rename a file or folder.

(b) Differentiate between move cell, and copy cell.

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

(a) Write the keyboard shortcut keys of the following.

(i) All Caps

(ii) Go to end of column

(iii) Apply bulleted list

(iv) Font Face

(b) Sachin and his sister use the same computer at home. Sachin has created a document, and saved as “NOTES” on the desktop. He wants to keep the file safe from his sister and others. Write the steps for protection feature provided by MS-WORD.

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

(a) Write down the features of MS-EXCEL.

(b) Write the steps to modify the given password to protect a document.

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

(a) Explain in detail the advantages and disadvantages of recycle bin.

(b) Write the steps for the following in the worksheet.

(i) To navigate the worksheet

(ii) To enter a cell, row, and column

6. Prepare any one Project out of the following projects given below:

(a) Create a spreadsheet according to the points given below:

• Record the data like Roll No., First Name, Last Name, Date of Birth, Father’s Name, Mother’s Name for at least 15 students. 
• Enter Roll No as “S001” and “S002” for first 2 students. Use Autofill feature to fill remaining students roll nos.
• Save this worksheet as “Student.xls”
• Specify the new worksheet, and rename as “Periodical test I”, and “Periodical test II” respectively.
• Make a reference for the Roll Number, First Name, and Last Name columns from the Student Profile using the keyboard in the Periodic Test I worksheet.
• In the Periodic Test II worksheet, use the mouse to make reference for the Roll Number, First Name and Last Name columns from the Student Profile.

(b) Write down the steps to protect the document from accessing.

(i) Protecting a document as Read only document.

(ii) Modifying a password given to protect a document.