Data Entry Operations (229)
Tutor Marked
Assignment
Note : (i) All questions are compulsory. The marks allotted
for each question
are given at same place.
(ii) Write your name enrollment numbers, AI name subject on the top of the first page of the answer
sheet.
1. Answer any one of the following
questions in about 40 to 60 words.
(a)
Differentiate between high level and low level languages. (Lesson-1)
(b)
Differentiate between compiler and interpreter. (Lesson-1)
2.
Answer any of the following questions in about 40 to 60 words.
(a)
Zubaida wants to install a printer
on her computer. How can she
complete her task? Write the
steps to do so. (Lesson-2)
(b)
Nimish has downloaded a programming software from the Internet. Help him to install the software on his computer.
Write the detailed steps
to complete the task. (Lesson-2)
3. Answer any of the following questions.
Write shortcut(s) for the following actions:
(i)
Spelling and Grammar Check
(ii)
Cut the selected
text
(iii)
Replace
(iv)
Undo
(Lesson-3)
(b)
Write shortcut key (s) for the following actions:
(i)
Paste
(ii)
To go to the top of the document
(iii)
Redo
(iv)
Select entire document
4. Answer any of the following
questions.
(a)
Explain the following features of a spreadsheet
(i)
Rich Conditional Formatting
(ii)
Freeze panes feature (Lesson-6)
(b)
Explain the following features of a spreadsheet
(i)
Auto format feature
(ii)
Auto sum feature
5. Answer any of the following questions.
How is
slide show view of a presentation different from slide
sorter view? Explain in detail.
(Lesson
- 9)
Write a short note on smart art graphics
feature in MS Excel
2007 (Lesson-6,7)
6. Prepare any one project out of the
two given below.
(a)
You are a sales
manager of a company that deals in cosmetics - soaps,
talcum powder, moisturizer, deodorant
and face pack. Prepare
a sales analysis
in Excel worksheet and then based on
that
create a presentation highlighting the most profitable products of your company.
(Lesson-6,
7, 8 and 9)
(b) An NGO is collecting donations
from various parts of your city for flood victims. The items collected are toys, blankets, bed-sheets, clothes, footwear, food items (biscuits, wafers, chocolates, bread)
etc. Prepare a comprehensive spreadsheet on the item collected
from all areas. Thereafter prepare an appropriate chart analyzing the collection made.
(Lesoon-6, 7, 8 and 9)
