Kamis, 14 April 2011

Middle Test/Semester 2/2010-2011

Lesson : ICT
Day/Date : 3 16 2011
Class/Program: XI/IA & IS
Session : 2
Semester : 2(Even)
Hour : 08.40 - 10.10

Please, answer the following question, 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. Excel 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")

Tidak ada komentar:

Posting Komentar