Description

Data Entry Operations (336)
Tutor Marked Assignment
Maximum marks: 20

Note:
i. All questions are compulsory. The marks allotted for each question are given alongside the questions.
ii. Write your name, enrolment number, AI name and subject on the first page of the answer sheet.

1. Answer any one of the following questions in about 40-60 words.
a) Neha wants to make her Excel sheet look more professional by applying a consistent table design. How can she use AutoFormat to achieve this? (See Lesson 7)
b) Priya needs to print her document on A5-sized paper instead of the default A4. What steps should she follow in the Print dialog box? (See Lesson 3)

2. Answer any one of the following questions in about 40-60 words.
a) Ravi accidentally deleted an important file named “TMA336.doc” from his desktop. He wants to restore it. What steps should he follow to recover the file from the Recycle Bin? (See Lesson 2)
b) Meera has formatted a table with specific borders, font colors, and cell shading. She wants to apply the same formatting to another table in the same sheet. What steps should she follow? (See Lesson 7)

3. Answer any one of the following questions in about 40-60 words.
a) Anita wants to create a shortcut to her “project” folder on the desktop for quick access. Mention the steps she should take? (See Lesson 2)
b) Write the keyboard shortcut keys of the following (See Lesson 2)
i) Print Preview
ii) Help
iii) Select all – entire document
iv) Cut

4. Answer any one of the following questions in about 100-150 words.
a) What are the steps to protect a document in MS Word using a password? How can you modify or remove the password later? (See Lesson 3)
b) Shaan has a large worksheet with thousands of names and numbers. He wants to find a specific name “Meha Verghese” and replace it with “Mehak Verma”. Mention the steps Shaan must use in his worksheet to complete the said task? (See Lesson 6)

5. Answer any one of the following questions in about 100-150 words.
a) Ramesh is working on a worksheet in Excel. Mention the steps Ramesh must follow in order to perform the following tasks using a computer mouse: (See Lesson 6)
i) change the row height of one row only
ii) change the row height of all rows in the worksheet
b) Tanu has MS Office 2007 installed on her Computer System. She wants to upgrade to MS Office 2013. Mention the steps Tanu must follow in order to firstly, remove MS Office 2007 and then install MS Office 2013? (See Lesson 3)

6. Prepare any one of the following projects in about 500 words.
a) As a learner, you want to organize the digital learning material of “Data Entry Operations”. In order to do so, perform the following tasks and also mention the steps:
i) Create Folder named “Data Entry Operations” in My documents.
ii) Inside the Data Entry Operations folder, create four folders named “pdf”, “ppt”, “videos” & “notes”.
iii) Put any relevant pdf document in the “pdf” folder (using copy and paste)
iv) Rename the ppt folder as “presentation”
v) Put the “pdf” and “presentation” folders inside the “notes” folder (using drag and drop)
vi) Delete the “videos” folder

b) Manager of a grocery store wants to create a spreadsheet for storing basic details of the grocery items. Mentioned below is the table containing the details he wants to store: (See Lesson 6, 7)
Perform the following tasks on behalf of the grocery store manage and also mention the steps:
i) Create a worksheet as mentioned in the above mentioned table and save it as “grocery.xls”
ii) Hide the column F
iii) Insert a column H with name “Date of Manufacturing”
iv) Freeze the column name using freeze pane
v) Change the Date format of column G to dd/mm/yyyy
vi) Protect the worksheet with any password of your choice.