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:
Home--->Exam_document--->Table_4.ots
Type Remark in F2 Column.
Type The formula in F3 :
=IF(E3>80,”Eligible”,”Not Eligible”)
Drag the Formula to below cells.
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:
Home--->Exam_document--->Table_4.ots
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:
Save tabele2.ots to Exam10 by
using Save As.
From certificate1.odt select
Tools-->Mailmerge Wizard-->Insert
Address blocks-->Select Address list-->Add--> Exam10
-->Table2.ots-->OK.
Yoy will reach on certificate1.ots
while click on Edit Document -->Edit Document.
View Data Source
-->Table2-->Tables-->Sheet1.
Drag the headings from Table to
certificate in corresponding locations.
Click on return to Mail Merge
Wizard.
Save Print or Sent-->Save
Merged Document-->Save as single document-->Save document.
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.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