MIDDLE TEST EVEN SEMESTER

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. Ms. Excel 2007, Ms. Word 2007, Ms. Power Point 2007, Ms. Publisher 2007, Ms. Outlook 2007, and Ms. Access 2007.
2. Home:

* Clipboard
* Font
* Alignment
* 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 and Filter
* Data Tools
* Outline

Review

* Proofing
* Comments
* Changes

View

* Workbook Views
* Show/Hide
* Zoom
* Window
* Macros

3. a. Ms. Excel 2007
Columns: 16.384
Rows: 1.048.576
b. Ms. Excel 2003
Columns: 256
Rows: 65.536

4. a. Format Cells: To change cells or do formatting cells.
b. Sum: To sum the data in range or list.
c. Count Numbers: To calculate the data in range.
d. Max: To find maximun of data in range or list.
e. Min: To find minimun of data in the range or list.
f. Countif: To calculate the more data in the list or range.
g. Vlookup: To read the table with vertical.
h. Hlookup: To read the table with horizontal.
i. Mid: To find middle number in the range.
j. Round 0, Round 1, Round 2: To round the numbers with decimal number who wanted.

5. =IF(cell<76;"FAIL";"SUCCESS") By : ich in ich-error.blogspot.com