MIDDLE TEXT

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 columns and rows in :
a.Microsoft Excel 2007 !
b.Microsoft Excel 2003 !
4.Whether its function in Ms. Excel 2007 !
a.Format Cell ?
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. Specify all the members of Microsoft Office 2007

a. Microsoft Access 2007

Microsoft Access 2007 is used mostly by businesses small and medium enterprises, in an even smaller organizations may also be used by large companies, and also the programmer to make a homemade system to handle the manufacture and manipulation of data.

b. Microsoft Excel 2007

Microsoft Excel 2007 is a software to process data automatically meliputiperhitungan basis, the use of functions, graphing and data management.

c. Microsoft OutLock 2007

Microsoft Outlook 2007 (one e-mail client software from MS families. Office 2007) has the functions and appearance of a very steady.

d. Microsoft PowerPoint 2007

Microsoft Powerpoint 2007 has a function to help us present the report. That could make powerpoint presentation material and presenting it in an interesting visual form in a short time.


e. Microsoft Publisher 2007

Microsoft Publisher 2007 has a function that is used for desktop publishing.


f. Microsoft Word 2007

Microsoft Word 2007 is a word processing application programs (word processor) that are commonly used to create reports, documents in the form of newspapers, mailing labels, create tables in the document. Microsoft Word 2007 is the latest word processing program from Microsoft.

g. Microsoft Groove 2007

Microsoft Groove 2007 is an application that can create a Virtual Office that increase productivity and reduce operating costs.


h. Microsoft InfoPath 2007

Microsoft InfoPath 2007 has a function of its ability to create and display XML documents with support for self-defined XML schema.


i. Microsoft OneNote 2007

Microsoft OneNote 2007 (formerly called Microsoft Office OneNote) is a computer program for free-form information gathering and multi-user collaboration. It can gather user's notes (handwritten or typed), drawings, and audio commentaries and share them with other users of Microsoft OneNote over the Internet.



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.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 (RANGE<=76;"FAIL";"SUCCESS")