MIDDLE TEST

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 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. 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")