Lesson : ICT
Class/Program : XI/IA & IS
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 each function !

2. Please, specify all the members of Pull Down Menu in Ms Excel 2007, and each function !

3. Please, specify the number of columns and rows in and each function :

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 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 !


Notice !

Strictly forbidden to operate a Laptop, Notebook, Netbook, and similar !!!

*************

JAWABAN............

1. a. Microsoft Access 2007
function : Is one of the database processing program is quite sophisticated with a variety of existing facilities such as setting the data, creation of forms, making reports, filter data and others.

b. Microsoft Excel 2007
function : to perform arithmetic operations and can present the data into a table.
Microsoft Excel is a software to process data automatically meliputiperhitungan basis, the use of functions, graphing and data.Perangkat management software is very helpful to solve administrative problems from the most sedernaha to the more complex.

c. Microsoft Outlook 2007
function : is an application used to megelola e-mail, create and manage schedules, create address book, make contact, and various other functions. We can organize and classify e-mails by adding its own color, so that our work will become easier.

d. Microsoft Power Point 2007
function : is an application used to create presentations. We can set the display presentation we want to the sound. We also can set the form view, background, and others. Microsoft PowerPoint to create presentations that we make it more attractive.

e. Microsoft Publiser 2007

f. Microsoft Word 2007
function : s a word processing application program. We can type text, insert images, process table, create a mass of documents, as well as other applications. Display Microsoft Word 2007 is very different from the version that never existed before.

2. Home : Clipboard, Font, Aligment, Number, Styles, Cells, Editing.
Insert : Tables, Illustrations, Charts, Links, Text
Page Layout : Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
Formulas : Function library, Defined Names, Formula Auditing, Calculation.
Data : Get External Data, Connections, Sort & Filter, Data Tools, Outline.
Review : Proofing, Comments, Changes
View : Workbook Views, Show/Hide, Zoom, Window, Macros

3. a. Microsoft Excel 2007
Columns: 16.384 columns
Rows : 1.048.576 rows
b. Microsoft Excel 2003
Columns: 256 columns
Rows : 65.536 rows

4. a. Format Cells : To change cell or do formatting cell
b.Sum : To sum the data in range
c.Count Numbers : to sum the rows in one list
d.Max : The MAX function, one of Excel's statistical functions, is used to find the largest or maximum value in a given list of numbers
e.Min : The MIN function, one of Excel's statistical functions, is used to find the smallest or minimum value in a given list of numbers
f.COUNTIF : to calculate the more data in the list or range
g.VLOOKUP : to read yhe table with vertical
h.HLOOKUP : to read the table with horizontal
i.MID : The MEDIAN function, one of Excel's statistical functions, gives you the middle value from a list of numbers.
j.ROUND 0, ROUND 1, ROUND 2 : to round the numbers with decimal number who wanted

5. = IF (C7<=76;"FAIL";"SUCCESS")