Middel Test/ Semester 2 2010/2011

Lesson : ITC Day/Date :Wenesday, 10 03 2011
Class/Program :XI/IA 4 Session :2
Semester : 2 (even) Hour : 08.40-10.10

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


QUESTION :

1. Please, specify all the members of Microsoft Office 2007 !
2. Please, specify all the members of Pull Down Menu in Ms Exel 2007 !
3. Please, specify the number of coloumns and rows in :

• Microsoft Excel 2007 !
• Microsoft Excel 2003 !

4. Wheater it's function in Ms. Excel 2007 ?

• Format Cells ?
• Sum ?
• Count Numbers ?
• Max ?
• Min ?
• COUNTIF ?
• VLOOKUP ?
• HLOOKUP ?
• MID ?
• ROUND 0, ROUND 1, ROUND 2

5. If the value is less than 76, then "FAIL" and if it's value is more than 76, then "SUCCES". Please, write a formula thatshould 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")