THOUSANDS OF FREE BLOGGER TEMPLATES

Jumat, 25 Maret 2011

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")

0 komentar: