PRACTICAL FILE
On Writer and Spreadsheet
Submitted by: ___________________
Class: ____________
Roll No: ___________
Index
S. No. Topic Page No.
1 Introduction to Writer 3-4
2 Features of Writer 5-6
3 Formatting in Writer (Stepwise) 7-9
4 Inserting Tables and Images 10-11
5 Page Layout & Mail Merge 12-13
6 Practical Exercises (Writer) 14-15
7 Introduction to Spreadsheet 16-17
8 Data Entry and Editing 18
9 Formulas and Functions 19-21
10 Charts and Graphs 22-23
11 Conditional Formatting 24
12 Advanced Features of Spreadsheet 25-26
13 Practical Exercises (Spreadsheet) 27-28
14 Conclusion 29
15 Viva Questions 30-31
Introduction to Writer
Writer is a word processing tool that allows users to create, format, and edit text documents. It is
commonly used for preparing letters, applications, reports, books, and official documents.
Uses:
- Preparing school/college reports
- Drafting official letters
- Designing resumes and CVs
- Creating project documentation
Features of Writer
- Easy text editing and formatting
- Multiple templates for ready-made documents
- Page setup options (margins, size, orientation)
- Styles for headings, titles, and paragraphs
- Supports tables, charts, and images
- Spelling and grammar correction
- Mail merge for bulk letters
- Export to PDF
- Compatible with different file formats
Formatting in Writer (Stepwise)
Steps to format text:
1. Select the text you want to format.
2. Go to the Format menu.
3. Choose Font and select style (Bold, Italic, Underline).
4. Change font size and color.
5. Align text (Left, Center, Right, Justify).
6. Add bullets and numbering.
7. Insert borders and shading.
Inserting Tables and Images
Tables and images make documents informative and attractive. For example:
Name Maths Science English
Ravi 80 75 78
Sita 90 88 92
Aman 70 65 68
You can also insert an image by choosing Insert → Image → From File.
Page Layout & Mail Merge
Steps for Page Layout:
1. Go to Format → Page Style.
2. Set margins and orientation.
3. Add header/footer.
4. Insert page numbers.
Steps for Mail Merge:
1. Create a main document (letter).
2. Connect it with a spreadsheet/database.
3. Insert merge fields (like Name, Address).
4. Preview and print letters.
Practical Exercises (Writer)
1. Draft an application for leave.
2. Create a resume with headings.
3. Insert a table of marks.
4. Perform a mail merge.
5. Add page numbers and header.
Introduction to Spreadsheet
Spreadsheet is used to organize and analyze data in tabular format. It allows mathematical
calculations, data analysis, and chart creation.
Data Entry and Editing
Data is entered in rows and columns. Each cell can hold text, numbers, or formulas. Editing options
include cut, copy, paste, delete, and autofill.
Formulas and Functions
Formulas are user-defined. Functions are predefined. Example functions:
- SUM(A1:A5)
- AVERAGE(B1:B10)
- MAX(C1:C5)
- MIN(D1:D5)
- IF(E1>40, "Pass", "Fail")
Charts and Graphs
Charts help visualize data. Example: Pie chart of expenses.
Item Cost
Food 4000
Rent 8000
Travel 2000
Others 1500
Conditional Formatting
Cells can be highlighted based on conditions. Example: Marks < 40 appear in red.
Advanced Features of Spreadsheet
- Pivot tables
- Data validation
- Sorting and filtering
- Protecting sheets
- Using macros
Practical Exercises (Spreadsheet)
1. Create a marksheet with total, average, and grade.
2. Make a monthly budget with SUM and AVERAGE.
3. Create a pie chart.
4. Apply IF() for Pass/Fail.
5. Create a pivot table.
Conclusion
Writer and Spreadsheet are vital tools for students and professionals. Writer helps in creating
well-structured documents, while Spreadsheet helps in calculations and analysis.
Viva Questions
1. What is Writer?
2. Write two formatting features in Writer.
3. What is Mail Merge?
4. Define Spreadsheet.
5. Write two functions in Spreadsheet.
6. What is a pivot table?
7. Define Conditional Formatting.