Please, answer the following question, short and right ! Please , use Full English Version !
QUESTION
1. Please . specify all members of Microsoft office 2007 !
2. Please . specify all members of pull down menu in Ms Excel 2007
3. Please . specify the number of columns and row in :
* Microsoft excel 2007 !
* Microsoft excel 2003 !
4. Whether its function in Ms Excel 2007
* a.Format cells ?
* b.Sum ?
* c.Count number ?
* d.Max ?
* e.Min ?
* f.Count if ?
* 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 tahan 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. Specify all the members of Pull Down Menu Microsoft Excel 2007
a. Home
- Clipboard
- Font
- Alignment
- Number
- Styles
- Cells
- Editing
b. Insert
- Tables
- Illustrations
- Charts
- Links
- Text
C. Page Layout
- Tames
- Page Setup
- Scale to Fit
- Sheet Options
- Arrange
d. Formulas
- Function Library
- Defined Names
- Formula Auditing
- Calculation
e. Data
- Get External Data
- Connections
- Sort & Filter
- Data Tools
- Outline
f. Review
- Proofing
- Comments
- Changes
g. 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")
