Middle Test Semester II 2010/2011

Question ...

1. Please, specify all the members of microsft office 2007!

2. Please, specify all the members of pull down menu in Ms Excel 2007!

3. Please, specify the number of columns and row in :
    a. Microsoft excel 2007!
    b. Microsoft excel 2003!

4. Whether its function in Ms Excel 2007?
    a. Format cells?
    b. Sum?
    c. Count number?
   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,”FAIL” and if its value is more than 76, then “SUCCES”. Please, write a formula that should be used!

Notice! Strictly forbidden to operate a laptop, note book, netbook, and similar!!! 

 Answer….. 


1. They are :
    a. Microsoft Office Access 2007, used to processing data base.
    b. Microsoft Office Excel 2007, is a spread sheet program for processing number.
    c. Microsoft Office Word 2007, is a word sheet program for processing word’s document.
    d. Microsoft Office PowerPoint 2007, used to presentating document, to make a document for      presentation.
    e. Microsoft Office OutLook 2007, used to send and receive e-mail.
    f. Microsoft Office Publisher 2007, used to make a brochure, poster, and banner.

 2. They are :
     a. New : to make a new document.
     b. Open : to open file, specially excel’s file.
     c. Save : to save the excel’s document.
    d. Save As: to save a file with another name or extention like*xlsx or *xls.
    e. Print: to printing document.
    f. Close: to exit from worksheet Microsoft Excel 2007.

 3. a. Columns : XED For Microsoft Excel 2007 Rows : 1048576
     b. Columns : IV For Microsoft Excel 2003 Rows: 65536

 4. a. Format cells : Used to setting the place, size, font, aligment of word, size of cell or range.
     b. Sum : used to total the number in the range of cell
     c. Count Number: used to total the number in the range, of cells
     d. Max : used to find the maximum in the range of cells
     e. Min : used to find the minimum in the range of cells
     f. COUNTIF : used to total number of data which agree with the logically formula’ settings.
     g. VLOOKUP : used to read the table vertically
     h. HLOOKUP : used to read the table Horizontally
     i. MID : used to find text on the cell as from the middle
     j. ROUND 0, ROUND 1, ROUND 2 : to make to fraction in data

5. =IF(data range<76,"FAIL",IF(data range>76,"SUCESS"))