Question and Answer from spredsheet

Use of IF Fuction

Eligibility to Write National Merit scholarship exam is 80% marks in Annual Examination. Open Table_4.ots from Exam_documents in Home folder and use IF function to print Eligible against the name of student How are eligible and Not Eligible against those how are not eligible.

Answer:

1. Home--->Exam_document--->Table_4.ots
2. Type Remark in F2 Column.
3. Type The formula in F3 : =IF(E3>80,”Eligible”,”Not Eligible”)
4. Drag the Formula to below cells.
5. Save in Exam10 by giving register no. as file name.
   
   

-->

Use of LOOKUP chart.

List of students those how are interested to join are listed in Table_5.ots in Exam_documents in Home.

By using following criteria classify the students.

Less then 12 Sub Junior

12 to 15 Junior

16 to 18 Senior

Answer:

1. Home--->Exam_document--->Table_4.ots
2. Prepare a lookup chart as given below in the same sheet.
   

-->

Select Lookup chart.

Data --->Define Range --->Chart1 as name and click OK

Select the cell below Category.

Type formula : =LOOKUP(D2,chart1).

Drag down.

-->

Use of Mail Merge

Distribute conduct certificate by using mail merge technique. Details from table_2.ots to be mail merged with certificate1.ods .

Answer:

• Open certificate.ods and table2_ots from exam_documents.

1. Save tabele2.ots to Exam10 by using Save As.
2. From certificate1.odt select
   Tools-->Mailmerge Wizard-->Insert Address blocks-->Select Address list-->Add--> Exam10 -->Table2.ots-->OK.
3. Yoy will reach on certificate1.ots while click on Edit Document -->Edit Document.
4. View Data Source -->Table2-->Tables-->Sheet1.
5. Drag the headings from Table to certificate in corresponding locations.
6. Click on return to Mail Merge Wizard.
7. Save Print or Sent-->Save Merged Document-->Save as single document-->Save document.
8. Give Reg.No and Question No. as file name and save in Exam10 folder.

Question and Answer from Database

The details of students participating in the sub district level Youth Festival is given below.Tabulate the details in open office Database using table and form. Set 'item Code' asprimary key. Save the file with the file name that includes your register number and question number in the folder Exam 10 in home.

1. 

1.Application-->Office-->Open Office -->Database-->Finish-->Save-->Create table in Design View.

2.Enter Sl.No, Admn No., Name , Class, Item Code And Item in Field Name column.

3.Give field type for all the field.

4.Right click on Item code and select primary Key.

5.File -->Save as -->Table1-->Ok

6.Forms-->Use Wizard to create form

7.Include all field.

8.Click on the first option in Arrangement of Main Form -->Finish.

9.Enter the details given is Question.

10.Open Table in form.

11.File -->Save Copy as in Exam10