1. What is a memorandum ?

What are the advantages of this form of official

Correspondence?
2. Explain the points to be kept in mind at the time of typewriting a fair Copy from
manuscripts.
3. What is the significance of electronic spreadsheets ?
4. Different between Row and column ten points .
5. Why is formatting necessary ? What is the default alignment of number, Text and
formula in a spreadsheet ?
6. How can you create a presentation in PowerPoint ? Explain.
7. Differentiate between Semi-Blocked and Fully-Blocked styles of letters.
8. Different between e-business and e commerce.
9. What is the difference between Line chart and Pie-chart ?
10. Write down the names of the PowerPoint Window and explain any three .
11. What are the advantages of e-mail ?
12. What do you understand Excel ? Explain Average() Function and Sumif() Function.
13. Write the steps to modify animation effect Computers are very important nowadays
and everyone is using them.
14. This context, explain the following terms :
Merge and Center
Alignment Tab
Drag and Drop
Workbook
15. Nowadays Presentation is used in all offices and educational institutes. In this
context, give the definition of Presentation and its use.
16. Chart in MS Excel is used to represent data in graphical form.
17. Write a memorandum to an employee of the institute for the confirmation of his/
her job to the post of junior secretariat assistant (JSA)?
18. Draft an office order for an employee for grant/ sanction of earned leave for a period
of 5 days.
19. Write a D.O. ( demi-official) letter from the principal of the school to Directorate of
education registering a complain of the staff member.
20. Draft an office note inviting the teacher of the school for an urgent assembly in the
auditorium.
1. What is a memorandum? What are the advantages of this form of official
Correspondence?
* Memorandum: A memorandum, often abbreviated as “memo,” is a brief written
communication used for internal purposes within an organization. It’s typically used
to convey information, give instructions, or make requests within the same
department or between different departments.
* Advantages:
* Conciseness: Memos are known for their brevity and directness, making them
efficient for conveying information quickly.
* Internal Communication: They are specifically designed for internal use, ensuring
that information remains within the organization.
* Formal but Informal: Memos maintain a formal tone while still allowing for a
more informal and direct communication style compared to formal letters.
* Easy to Distribute: They can be easily distributed electronically or in hard copy
within the organization.
* Record Keeping: Memos serve as a written record of decisions, instructions, and
communications.
2. Explain the points to be kept in mind at the time of typewriting a fair Copy from
manuscripts.
* Accuracy: Ensure that the typed copy perfectly matches the original manuscript,
including spelling, punctuation, and formatting.
* Clarity: Maintain clear and consistent formatting, including font size, line spacing,
and margins, for easy readability.
* Presentation: Present the typed copy neatly and professionally, free from any
errors or smudges.
* Proofreading: Carefully proofread the typed copy for any errors before submitting
it.
* Following Instructions: Adhere to any specific instructions given regarding
formatting, font, or other requirements.
* Consistency: Maintain consistent formatting throughout the document.
3. What is the significance of electronic spreadsheets?
Electronic spreadsheets, such as Microsoft Excel, are powerful tools with numerous
applications in various fields. Their significance lies in their ability to:
* Organize and Analyze Data: Spreadsheets excel at organizing large datasets,
performing calculations, and analyzing trends.
 * Data Visualization: They provide various charting and graphing options to visualize
data effectively.
* Decision Making: Spreadsheets facilitate informed decision-making by enabling
“what-if” analysis and scenario modeling.
* Automation: They allow for the automation of repetitive tasks, such as
calculations and data entry, saving time and effort.
* Collaboration: Spreadsheets can be shared and collaboratively edited, enabling
teamwork and efficient data sharing.
4. Difference between Row and Column (ten points)
| Feature | Row | Column |

| Orientation | Horizontal | Vertical |

| Label | Number | Letter |
| Data Entry | Data is entered horizontally across rows | Data is entered vertically
down columns |
| Organization | Represents a single record or observation | Represents a specific
category or variable |
| Sorting | Can be sorted by row number | Can be sorted by column letter |
| Filtering | Can be filtered by row values | Can be filtered by column values |
| Charting | Data from rows can be used as data series in charts | Data from columns
often forms the basis for chart categories |
| Formulas | Formulas can reference data from multiple rows within a column |
Formulas can reference data from multiple columns within a row |
| Appearance | Often represented by horizontal lines | Often represented by vertical
lines |
| Spreadsheet Structure | Forms the horizontal axis of the spreadsheet | Forms the
vertical axis of the spreadsheet |
5. Why is formatting necessary? What is the default alignment of number, Text and
formula in a spreadsheet?
* Formatting Necessity:
* Readability: Proper formatting enhances readability by making the data
organized, clear, and easy to understand.
* Professionalism: Well-formatted spreadsheets convey a professional image and
make a good impression.
* Data Analysis: Formatting helps to highlight important data, identify patterns,
and make data analysis more effective.
* Data Entry: Consistent formatting can help to prevent errors during data entry.
* Default Alignment:
 * Numbers: Right-aligned
* Text: Left-aligned
* Formulas: Left-aligned
6. How can you create a presentation in PowerPoint? Explain.
* Open PowerPoint: Launch the PowerPoint application.
* Choose a Template (Optional): Select a pre-designed template to provide a
professional starting point.
* Create Slides: Add new slides by clicking the “New Slide” button or using
keyboard shortcuts.
* Add Content: Insert text, images, shapes, charts, videos, and other multimedia
elements into your slides.
* Design and Format: Customize the appearance of your slides by choosing
themes, colors, fonts, and layouts.
* Add Animations and Transitions: Enhance the visual appeal of your presentation
by adding animations to objects and transitions between slides.
* Rehearse and Time: Rehearse your presentation and use the “Rehearse Timings”
feature to practice your delivery and time each slide.
* Present: Deliver your presentation using “Slide Show” mode.
7. Differentiate between Semi-Blocked and Fully-Blocked styles of letters.
* Semi-Blocked:
* Date, Complimentary Close, and Signature are aligned to the right margin.
* All other lines are aligned to the left margin.
* Fully-Blocked:
* All lines, including Date, Complimentary Close, and Signature, are aligned to the
left margin.
8. Differentiate between e-business and e-commerce.
* E-business:
* A broader term encompassing all business activities conducted electronically,
including online marketing, customer service, and internal operations.
* E-commerce:
* Specifically refers to the buying and selling of goods and services over the
internet. It’s a subset of e-business.
9. What is the difference between Line chart and Pie-chart?
* Line Chart:
* Used to show trends and changes over time.
* Ideal for visualizing data that has a sequential order, such as monthly sales or
temperature readings.
* Pie Chart:
 * Used to show the proportion of different parts to the whole.
* Effective for visualizing data that represents percentages or shares of a total.
10. Write down the names of the PowerPoint Window and explain any three.
* Title Bar: Displays the name of the presentation file and the PowerPoint
application name.
* Ribbon: Contains tabs with groups of related commands for formatting and
editing slides.
* Slide Pane: Displays the current slide, allowing you to add and edit content.
* Notes Pane: Allows you to add speaker notes for reference during the
presentation.
* Task Pane: Displays various options and settings related to the current task, such
as formatting options or slide layouts.
* Status Bar: Displays information about the current slide, such as slide number
and zoom level.
11. What are the advantages of e-mail?
* Speed and Efficiency: Allows for rapid communication across distances.
* Low Cost: Generally inexpensive or free to send and receive.
* Accessibility: Can be accessed from anywhere with an internet connection.
* Convenience: Allows for flexible scheduling and asynchronous communication.
* Attachments: Enables easy sharing of documents, images, and other files.
* Record Keeping: Provides a record of all sent and received emails.
* Mass Communication: Allows for easy communication with multiple recipients.
12. What do you understand by Excel? Explain Average() Function and Sumif()
Function.
* Excel:
* A powerful spreadsheet program used for organizing, analyzing, and visualizing
data.
* Average() Function:
* Used to calculate the average (mean) of a range of cells.
* Syntax: =AVERAGE(number1, number2, …)
* Example: =AVERAGE(A1:A10) calculates the average of the values in cells A1 to
A10.
* Sumif() Function:
* Used to sum the values in a range that meet a specific criterion.
* Syntax: =SUMIF(range, criteria, sum_range)
* Example: =SUMIF(B1:B10,”>10”,C1:C10) sums the values in column C if the
corresponding value in column B is greater than 10.
13. Write the steps to modify animation effect Computers are very important
nowadays and everyone is using them.
* Select the object: Click on the object you want to animate.
* Open Animation Pane: Click on the “Animation Pane” button in the “Animations”
group on the “Animations” tab.
* Select the animation: Click on the animation effect you want to modify in the
Animation Pane.
* Access Effect Options: Click on the “Effect Options” button that appears next to
the selected animation.
* Modify Settings: Adjust the animation settings, such as direction, speed, and
timing, in the Effect Options dialog box.
* Preview: Click the “Preview” button to see how the modified animation looks.
* Apply Changes: Click “OK” to apply the changes.
14. In this context, explain the following terms:
* Merge and Center: Combines multiple cells into a single cell and centers the
content within that cell.
* Alignment Tab: A group of options within the “Home” tab of the Ribbon in
Certainly, let’s continue with the explanations:
14. In this context, explain the following terms:
* Alignment Tab: This is a group of options within the “Home” tab of the Ribbon in a
spreadsheet program like Excel. It provides tools for aligning text and numbers
within cells, such as:
* Left Align: Aligns text to the left side of the cell.
* Center: Centers text or numbers within the cell.
* Right Align: Aligns text to the right side of the cell.
* Top Align: Aligns text to the top of the cell.
* Middle: Centers text vertically within the cell.
* Bottom Align: Aligns text to the bottom of the cell.
* Drag and Drop: This is a user interface technique where you physically “grab” an
object (such as a file, icon, or cell data) with your mouse and “drop” it into a
different location. This allows for intuitive and efficient movement and manipulation
of objects within the software.
* Workbook: In a spreadsheet program like Excel, a workbook is a single file that
can contain multiple worksheets. Each worksheet is like a separate sheet of paper
within the workbook, allowing you to organize and analyze different sets of data.
15. Nowadays Presentation is used in all offices and educational institutes. In this
context, give the definition of Presentation and its use.
 * Presentation: A presentation is a structured and persuasive communication
delivered to an audience. It typically involves conveying information, ideas, or
arguments using a combination of visual aids, such as slides, and spoken or written
words.
* Uses of Presentation:
* Business:
* Sales pitches
* Marketing campaigns
* Project proposals
* Training sessions
* Board meetings
* Conferences
* Education:
* Classroom lectures
* Student projects
* Research presentations
* Seminars
* Workshops
16. Chart in MS Excel is used to represent data in graphical form.
This statement is correct.
Charts in MS Excel provide a visual representation of data, making it easier to
understand trends, patterns, and relationships within the data. Different chart
types, such as line charts, bar charts, pie charts, and scatter plots, are available to
best suit the type of data being presented.
I hope this comprehensive explanation helps! Let me know if you have any further
questions.