MIDDLE TEST SEMESTER 2

MIDDLE TEST SEMESTER 2

please, answer the following questions, short and right! please, use full english version!!

question:

1. Please, specify and fuction all the members of microsoft office 2007!
2. Please, specify and fuction 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. a. Microsoft Word = program of word
b. Microsoft Excel = program of number
c. Microsoft Power Point = program of presentations with showing slide
d. Microsoft OutLock = program of processing date
e. Microsoft accer = program of processing database
f. Microsoft Publisher = program of publish the data.

2. a. File = to arrange manner of data
b. View = to show or hidden the toolbar
c. Edit = to editing the data
d. Format = to arrange the columns and rows
e. Tools = to corrected the data
f. data = to showing comparisson of data
g. Help = to help the dat for to corrected

3 a. microsoft Excel 2007:
Columns = XED
Rows = 1048576
b. microsoft Excel 2003:
Columns = V
Rows = 65536

4. a. Format cell = the function is arrange the columns and rows
b. Sum= the function is to get the total of data
c. Count Numbers = the function is to calculate of number in the data
d. Max = the function is to get the top score of data
e. Min = the function is to get the bottom (small) score of data
f. COUNTIF = the function is to total the number of data which agree with the
logic formula's setting
g. VLOOKUP = the function is to read the table Vertically
h. HLOOKUP = the function is to read the table Horizontally
i. MID = the function is to get the middle score of data
j. ROUND 0, ROUND 1, ROUND 2 = the function is Showing and to make to fraction
in data

5. The formula is
For example: the cell is A1
= if (A1<76"FAIL","SUCCESS")