O Level M1 Pratical Questions
Information Technology Tools And Network (M1-R5.1)
LibreOffice Writer Questions
Question - 1
In LibreOffice , use mail merge feature to create invitation letter for Republic Day Flag hoisting to all the employees in the organization.
(a) Create your own Address List which will contain First name, Last name, Designation,
Department.
(b) Content of the main body of email should describe the time, date and venue of the
parade.
(c) All documents need to be sent through Email.
Question - 2
Create a document in Word. Format the document with various fonts (minimum 12, maximum 15) and margins (minimum 2, maximum 4). The document should include:
a) A bulleted or numbered list
b) A table containing name, address, basic pay, department as column
heading
c) A picture of an animal using the clip art gallery
d) A header with your name and the date
e) A footer with pagination
Question - 3
Create a List of Restaurant Menu Items using following features of LibreOffice Writer:
a) Create a numbered list
b) Change the style and formatting of the numbered list
c) Introduce a nested list in the menu
Question - 4
Below is given a letter and some addresses. This letter is to be sent to all these addresses.
User mail merge
Addresses are:
1) Amit, H No 424 sector 8D,Lajpat Nagar, New Delhi
2) Rohit, H No 444, Sector 125C,Chandigarh
3) Jyoti, H NO 550, Sector 16A, Gomti Nagar, Lucknow
The Letter is
To
<<Name>>
<<Address>>
Dear <<Name>>You are advised to appear for an interview on the <>at 9:00 A.M with your original documents.Yours Sincerely ABC Limited,Industrial Phase –7, New Delhi.LibreOffice Calc Questions
Question - 1
(a) Create a worksheet "employee" with the following information.
| Name | Phone | Floor | Office | Dept. | Design | Salary |
|---|---|---|---|---|---|---|
| Neha | 5834 | 2 | 11 | Admin | PM | 8000 |
| Sucheta | 2812 | 2 | 21 | Admin | CL | 9000 |
| Amrit | 3477 | 1 | 17 | Mkt | CL | 10000 |
| Arunesh | 6992 | 3 | 14 | Mkt | MM | 8500 |
| Ashwin | 1538 | 3 | 12 | Mkt | SI | 5000 |
(b) To find floor in which there is no person whose name starts with A.
(c) To display name and office for the persons in office 11 and 14.
(d) To extract name and phone for the persons on the floor between 2 and 4.
(e) To extract name and office for persons of Admin department.
(f) To extract name and phone for the persons having salary more than 8000/-.
Question - 2
(a) In Spreadsheet, Enter the following data
| Employee Name | Basic Pay | DA | HRA | Gross Pay | Insurance | P.F. | Net Salary |
|---|---|---|---|---|---|---|---|
| Anil Kumar | 8500 | ||||||
| Sunita Devi | 12500 | ||||||
| Roji Sharma | 16500 | ||||||
| Farida Khan | 18500 | ||||||
| Gunita Devi | 24000 | ||||||
| Total Amount | |||||||
| Highest Employee Salary | |||||||
| Lowest Employee Salary | |||||||
| Total Insurance Collected | |||||||
(b) Calculate DA as 80% of Basic Pay and HRA as 10% of basic pay + DA.
(c) Find out Net Salary (giving the deductions of Insurance 10% of Basic pay and P.F. 5%
of Basic pay).
(d) Find out the Highest and lowest Salary of the Employee.
(e) Calculate the total Insurance collected from all the employee.
(f) Apply two decimal notations to all the numeric values.
Question - 3
Create the worksheet shown above and save the file with name “Employees_Detail”.
| EMPLOYEE'S DATABASE | ||||
|---|---|---|---|---|
| Name | Department | Designation | Salary | Address |
| JUHI | SBI | BM | 100000 | LKO |
| HARISH | LIC | AD | 80000 | KANPUR |
| ANANYA | SBI | RM | 200000 | BAREILLY |
| GAURAV | LIC | MD | 90000 | LKO |
| KAJAL | FCI | RM | 200000 | KANPUR |
| MAYANK | LIC | MD | 80000 | MEERUT |
Do the followings :
(a) Merge and center the Heading "EMPLOYEE'S DATABASE". Apply the cell style to
Accent2.
(b) Make the Column headings in BOLD format.
(c) Count the total no. of employees DEPARTMENT WISE.
(d) List the name of employees whose salary is greater than 120000
(e) Count the total no. of employees who have salary greater than 100000
(f) Sort the data DEPARTMENT wise in ascending order
(g) Generate a Column chart and Line chart to highlight employee name and their
salary.
(h) Generate a Pie chart along the salary contribution by each DEPARTMENT.
Question - 4
A university maintains a year wise result for three courses and then generates an average report as given below :
| SR NO | YEAR | COURSE 1 | COURSE 2 | COURSE 3 | AVERAGE |
|---|---|---|---|---|---|
| 1 | 2014 | 300 | 650 | 560 | |
| 2 | 2015 | 450 | 500 | 400 | |
| 3 | 2016 | 490 | 400 | 250 | |
| 4 | 2017 | 600 | 650 | 350 | |
| 5 | 2018 | 500 | 550 | 450 | |
| Course Wise Average | |||||
(a) Create the worksheet shown above.
(b) Save the file with name "Courses".
(c) Use the AutoFill to put the SR NO. into cells.
(d) Set the column widths as follows : Column A : 8, Column B : 14, Columns C & D : 15,
Columns E & F : 14.
(e) Complete the report to calculate the course wise average in row 6.
(f) Provide formula to calculate year wise average in column F.
Question - 5
Create Student Data Sheet in Calc for eligibility in class Sixth admission, as given below:
| Form No. | Stud Name | Class | Date of Birth | Last Date of Submission | Age as on Date of Admission | Eligibility |
|---|---|---|---|---|---|---|
a)Enter data for 5 students up to Last Date of Submission
b) Calculate Age of students
c) Eligibility of admission (if age> 27 & 26 or <27
then eligible of next year, else not eligible)
d) Filter the Student list as per eligibility
Question - 6
Create a table in MS-Excel as shown below:
| Roll No. | Name | Marks in English | Marks in Maths | Total Marks |
|---|---|---|---|---|
| 1 | Rahul | 85 | 95 | 180 |
| 2 | Ronit | 65 | 50 | 115 |
| 3 | Amit | 72 | 80 | 152 |
| 4 | Rupesh | 40 | 60 | 100 |
| 5 | Shivika | 35 | 70 | 105 |
| 6 | Garima | 87 | 91 | 178 |
Do the following:
a) In the total marks column, entries should be calculated using formulas and it is
the sum of marks in physics and marks in chemistry.
b) Insert a new row at the end of the table and also find grand total using formula.
c) Sort the table based on total marks.
d) All columns should be center aligned.
e) Heading should be in bold and underlined
Question - 7
Create a table in word as shown below with following fields.
| Roll No | Name | Marks | Total Marks | |
|---|---|---|---|---|
| Physics | Chemistry | |||
| 1 | Ritu | 78 | 88 | 166 |
| 2 | Amit | 90 | 92 | 182 |
| 3 | Rakesh | 67 | 78 | 145 |
| 4 | Rohit | 50 | 50 | 100 |
| 5 | Niti | 60 | 65 | 125 |
| 6 | Garima | 89 | 67 | 156 |
Do the following:
a. In the total marks column, entries should be calculated using formulas and it is the
sum of marks in physics and marks in chemistry.
b. Insert a new row at the end of the table and also find grand total using formula.
c. Sort the table based on total marks
d. The date and heading should be center aligned
e. Heading should be in bold and underlined
Question - 8
Create an EXCEL sheet with following data and perform the operation listed below
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
| 234 | 45 | |||||
| 244 | 567 | |||||
| 43 | 568 | |||||
| 456 | 679 | |||||
| 2345 | 345 | |||||
| 4567 | 590 |
Do the following:
(a) Sort the content of column A in descending order
(b) Perform subtraction of column C from column A and put result in column E
(c) Do total of column A and E
(d) Copy only content of Column E in column G
Question - 9
A company records the details of total sales (in Rs.) Item and in the following format:
| Sector | Jan | Feb | March | April |
|---|---|---|---|---|
| PCs | 12000 | 17000 | 15000 | 20000 |
| Laptops | 14000 | 18000 | 15000 | 16000 |
| Printers | 15000 | 18000 | 13000 | 12000 |
| Scanners | 16000 | 15000 | 14000 | 23000 |
Do the following:
(a) Enter the data using spreadsheet and save it as sector
(b) Using appropriate formula, calculate total sale for each sector
(c) Create a 3-D column chart to show sector wise data for all four months
(d) Create a 3-D pie chart to show sales in Jan in all sectors