TUGAS DARI SUHU PSPB RONGGOLAWEZ22

  TUGAS DARI SUHU PSPB RONGGOLAWEZ22

1.   harap, tentukan semua anggota dari Microsoft Office 2007 dan fungsi?
2.   silahkan, tentukan semua anggota Pull Down Menu di Microsoft Excel 2007 dan  fungsi?
3. Silakan, tentukan anggota kolom dan baris dalam:
    a. Microsoft Excel 2007
    b. Microsoft excel 2003
4. Apakah fungsi dalam Ms.Excel 2007
    a. Format Cells
    b. Jumlah
    c. Count Nomor
    d. Max
    e. Min
    f. COUNTIF
    g. VLOOKUP
    h. HLOOKUP
    i. MID
    j. ROUND 0, ROUND 1, ROUND 2
  5. Jika nilai kurang dari 76, kemudian "GAGAL" dan jika nilainya lebih dari 76, "SUKSES". silahkan menulis rumus yang kemudian harus digunakan

Simak

Baca secara fonetik

JAWABAN 

1. Ms. Word 2007 ; Ms. Excel 2007 ; Ms. Power Point 2007 ; Ms. Access 2007 ; Ms. Office Info Path 2007 ; Ms. Office One Note 2007 ; Ms. Office Outlook 2007 ; Ms. Office Publisher 2007 ; Ms. Office Groove 2007

2.
a. New
b. Open
c. Save
d. Save As

• Word Document
• Word Template
• Word 97-2003 Document
• PDF or XPS
• Other Format

e. Print

• Print
• Quick Print
• Print Preview

f. Prepare

• Propertis
• Inspect Document
• Encrypt Document
• Restricr Permission
• Add a Digital Signature
• Mark as Final
• Run a Compatibility Checker

g. Send

• E-mail
• E-mail as PDF Attachment
• E-mail as XPS Attachment
• INternet Fax

h. Publish

• Blog
• Document Management Server
• Creat Document WOrkspace

i. Business Contack Manager

• Link to Record
• Creat Marketing Campaign
• Learning Center

j. Close
k. Word Option
l. Exit Word
3. Ms. Excel 2003

• Rows : 65.536
• coloumns : 256

Ms. Excel 2007

• Rows : 1.048.576
• Coloumns : 16.384

4. Function Of :

• Format Cell : For edit the active cell(s)
• Sum : Used to find the amount of content data in a certain range
• Count Number : Used to find thenumber of data from one range
• Max : Used to find the highest value from a range
• Min : Used to find the lowest value from a range
• Countif : Used to calculate the amount of data on a range of tables that meet the criteria of the conditions required by the function parameters.
• VLOOKUP : used to read in a vertical table
• HLOOKUP : used to read in a horizontal table
• Mid : used to take the character in the middle string
• Round 0 : Used to round off the numbers from 0 digits behind the data point
• Round 1 : Used to round off the numbers from 1 digits behind the data point
• Round 2 : Used to round off the numbers from 2 digits behind the data point

5. =IF(Range<76;"FAIL";"SUCCES")

 

Posted in: CITtask-11-s-2