Lesson : ICT Day/Date: Wednesday, 16,3,2011
Class/Program :XI/IA &IS Session : 2
Semester :2 (Even) Hour : 08.40 - 10.10
Please, answer the following qeustions, 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 2003!
3. Please, specify the number of columns and rows in :
a. Microsoft Excel 2007!
b. Microsoft Excel 2003!
4. Whether its 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 value is less than 76, then "FAIL" and if its value is more than76,then "SUCCES".Please, write a formula that should be used!
Notice !
Strictly forbidden to operrate a laptop, notebook, and similar !!!
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")
Class/Program :XI/IA &IS Session : 2
Semester :2 (Even) Hour : 08.40 - 10.10
Please, answer the following qeustions, 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 2003!
3. Please, specify the number of columns and rows in :
a. Microsoft Excel 2007!
b. Microsoft Excel 2003!
4. Whether its 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 value is less than 76, then "FAIL" and if its value is more than76,then "SUCCES".Please, write a formula that should be used!
Notice !
Strictly forbidden to operrate a laptop, notebook, and similar !!!
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
* 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 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")
