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
- Quick Print
- Print Preview
- Propertis
- Inspect Document
- Encrypt Document
- Restricr Permission
- Add a Digital Signature
- Mark as Final
- Run a Compatibility Checker
- E-mail as PDF Attachment
- E-mail as XPS Attachment
- INternet Fax
- Blog
- Document Management Server
- Creat Document WOrkspace
- Link to Record
- Creat Marketing Campaign
- Learning Center
k. Word Option
l. Exit Word
3. Ms. Excel 2003
- Rows : 65.536
- coloumns : 256
- Rows : 1.048.576
- Coloumns : 16.384
- 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