Lesson : ICT

Class/Program : XI/IA 3

Semester : 2 (Even)

Please, answer the following questions, short and right ! Please, use Full English Version !

QUESTION :

1. Please, specify all the members of Microsoft Office 2007 and is Functions !

2. Please, specify all the members of Pull Down Menu in Ms Excel 2007 and is Function !

3. Please, specify the number of coloumns and rows in :

a. Microsoft Excel 2007 !

b. Microsoft Excel 2003 !

4. Whether is function in Ms Excel 2007 ?

a. Format Cells ?

b. Sum ?

c. Count Numbers ?

d. Max ?

e. Min ?

f. COUNTIF ?

g. VLOOKUP ?

h. HLOOKUP ?

i. MID ?

j. ROUND 0, ROUND 1, ROUND 2 ?

5. If the value is less than 76, then “FAIL” and if its value is more than 76, then “SUCCESS”. Please, write a formula that should be used !

answer...........!!!

1. Ms. Word 2007 ; Ms. Excel 2007 ; Ms. Power Point 2007 ; Ms. Access 2007 ; Ms. Office Info Path 2007 ; Ms. Office One Note 2007 ; Ms. Office Outlook 2007 ; Ms. Office Publisher 2007 ; Ms. Office Groove 2007

2.
a. New
b. Open
c. Save
d. Save As

• Word Document
• Word Template
• Word 97-2003 Document
• PDF or XPS
• Other Format

e. Print

• Print
• Quick Print
• Print Preview

f. Prepare

• Propertis
• Inspect Document
• Encrypt Document
• Restricr Permission
• Add a Digital Signature
• Mark as Final
• Run a Compatibility Checker

g. Send

• E-mail
• E-mail as PDF Attachment
• E-mail as XPS Attachment
• INternet Fax

h. Publish

• Blog
• Document Management Server
• Creat Document WOrkspace

i. Business Contack Manager

• Link to Record
• Creat Marketing Campaign
• Learning Center

j. Close
k. Word Option
l. Exit Word
3. Ms. Excel 2003

• Rows : 65.536
• coloumns : 256

Ms. Excel 2007

• Rows : 1.048.576
• Coloumns : 16.384

4. Function Of :

• Format Cell : For edit the active cell(s)
• Sum : Used to find the amount of content data in a certain range
• Count Number : Used to find thenumber of data from one range
• Max : Used to find the highest value from a range
• Min : Used to find the lowest value from a range
• Countif : Used to calculate the amount of data on a range of tables that meet the criteria of the conditions required by the function parameters.
• VLOOKUP : used to read in a vertical table
• HLOOKUP : used to read in a horizontal table
• Mid : used to take the character in the middle string
• Round 0 : Used to round off the numbers from 0 digits behind the data point
• Round 1 : Used to round off the numbers from 1 digits behind the data point
• Round 2 : Used to round off the numbers from 2 digits behind the data point

5. =IF(Range<76;"FAIL";"SUCCES")