Pratikum Teknologi Infomatika ( Dasar - Dasar Komputer MS Office Dan Aplikasi Statistik SPSS

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Bayuiman23
B
Bayuiman23
Community Contributor
Quizzes Created: 1 | Total Attempts: 534
Questions: 72 | Attempts: 534

SettingsSettingsSettings
Pratikum Teknologi Infomatika ( Dasar - Dasar Komputer MS Office Dan Aplikasi Statistik SPSS - Quiz

Ujian ini mengunakan waktu 80 Menit mahasiswa/i yang mengerjakan yang sudah melakukan / lengkap melakukan mengumpulkan tugas. tetap fokus dan Disiplin..


Questions and Answers
  • 1. 

    NAMA

  • 2. 

    NIM

  • 3. 

    1. Fasilitas footnote dan endnote, jika footnote akan tercetak dibagian footer halaman, dan endnote berada dibawah paragraf terakhir sebuah halaman. Semua fasilitas endnote dan footnote aktif jika diklik menu ....

    • A.

      A. Page Layout

    • B.

      B. References

    • C.

      C. Insert

    • D.

      D. Home

    • E.

      E. Mailings

    Correct Answer
    B. B. References
    Explanation
    The correct answer is "b. References." The question is asking about the menu where the active features for endnotes and footnotes can be found. The References menu in Microsoft Word typically contains options for managing citations, creating a table of contents, and working with footnotes and endnotes. Therefore, it is the most likely menu where the active features for endnotes and footnotes can be accessed.

    Rate this question:

  • 4. 

    1. Kombinasi perintah keyboard untuk menambah footnote pada dokumen Microsoft Word adalah …

    • A.

      A. ALT + CTR + B

    • B.

      B ALT + CTR + C

    • C.

      C. ALT + CTR + D

    • D.

      D. ALT + CTR + E

    • E.

      E. ALT + CTR + F

    Correct Answer
    E. E. ALT + CTR + F
    Explanation
    The correct combination of keyboard commands to add a footnote in Microsoft Word is ALT + CTR + F.

    Rate this question:

  • 5. 

    Pembuatan daftar isi secara otomatis pada Microsoft Word  terdapat pada group ....

    • A.

      A. Footnotes

    • B.

      B. Table of Contents

    • C.

      C. Citations

    • D.

      D. Index .

    • E.

      C. Citations d. Index . e. Captions

    Correct Answer
    B. B. Table of Contents
    Explanation
    The correct answer is b. Table of Contents. Microsoft Word has a feature that allows users to automatically generate a table of contents for their document. This feature makes it easier for readers to navigate through the document and find specific sections or chapters. By using heading styles, users can mark the different sections of their document, and then Word can automatically create a table of contents based on those headings. This saves time and effort compared to manually creating and updating a table of contents.

    Rate this question:

  • 6. 

    Sebelum melakuan pembuatan Daftar Isi Otamatis maka setiap hurup/kaliamat yang ingin dimasukan kedalam daftar isi  perlu ditentukan.

    • A.

      A. Theme Font

    • B.

      B. Ukuran Forn

    • C.

      C. Ketebalan

    • D.

      D. Styles Heading

    • E.

      E. Paragraph

    Correct Answer
    D. D. Styles Heading
    Explanation
    The correct answer is "d. Styles Heading". In order to create an automatic table of contents, it is necessary to define the different heading styles used in the document. These heading styles can include different font types, sizes, and weights, but the most important aspect is that they are designated as headings. By using heading styles, the document can be structured and organized, allowing the automatic table of contents to accurately reflect the different sections and subsections within the document.

    Rate this question:

  • 7. 

    Page setup berfungsi untuk…

    • A.

      A.      Mengatur halaman

    • B.

      B. Mencetak kertas

    • C.

      C. Keluar dari tampilan

    • D.

      D. Membuka lembar kerja

    • E.

      E. Memprint data

    Correct Answer
    A. A.      Mengatur halaman
    Explanation
    The correct answer is "a. Mengatur halaman" which means "to set up the page" in English. This feature allows users to adjust various aspects of the page layout, such as margins, orientation, paper size, and headers/footers. It is commonly used in word processing software to ensure that the document is formatted correctly before printing or sharing.

    Rate this question:

  • 8. 

    Setelah kita melakukan perubahan terhadap isi dokumen, maka  daftar isi perlu untuk dirubah, untuk melakukan perumbah otomatis dalam daftar  isi yang sudah kita buat perlu melakukan.

    • A.

      A. References - Update Table

    • B.

      B. References - add Text

    • C.

      C. References - Insert Endnote

    • D.

      D. References - Insert Citation

    • E.

      E. Mark Entry

    Correct Answer
    A. A. References - Update Table
    Explanation
    After making changes to the document, the table of contents needs to be updated. To automatically update the table of contents that we have created, we need to use the "References - Update Table" option.

    Rate this question:

  • 9. 

    Jenis huruf  yang digunakan dalam pembuatan Surat Resmi, salah satunya adalah

    • A.

      A. Times New Roman, Arial, Century Ghotic

    • B.

      B. Arial, Cooper Black, Algerian

    • C.

      C. Adobe arabic, Times New Roman, Century Ghotic

    • D.

      D. Century Ghotic, Gigi, Darling,

    • E.

      E. Semua benar

    Correct Answer
    A. A. Times New Roman, Arial, Century Ghotic
    Explanation
    The correct answer is a. Times New Roman, Arial, Century Ghotic. These are commonly used fonts in official letter writing. Times New Roman is a classic serif font that is widely accepted for formal documents. Arial is a clean and modern sans-serif font that is easy to read. Century Ghotic is a decorative font that adds a touch of elegance to the letter. These fonts are chosen for their professionalism and readability, making them suitable for official correspondence.

    Rate this question:

  • 10. 

    Salah satu fungsi mailing adalah

    • A.

      A. Membuat presentasi

    • B.

      B. Membuat web

    • C.

      C. Mengedit photo

    • D.

      D. Membuat surat masal

    • E.

      E. Semua Benar

    Correct Answer
    D. D. Membuat surat masal
    Explanation
    The correct answer is d. Membuat surat masal. Mailing functions include creating mass emails or newsletters to send to a large number of recipients. This can be useful for businesses or organizations that need to communicate with a large audience at once. Creating mass emails allows for efficient and effective communication, saving time and effort compared to individually sending emails to each recipient.

    Rate this question:

  • 11. 

    Cara untuk membuat table secara otomatis dengan klik …

    • A.

      Insert – chart – tentukan jumlah baris dan kolom secara drag

    • B.

      Insert – blank page - tentukan jumlah baris dan kolom secara drag

    • C.

      Home – table - tentukan jumlah baris dan kolom secara drag

    • D.

      Insert – table - tentukan jumlah baris dan kolom secara drag

    • E.

      Insert – table – ketik jumlah baris dan kolom

    Correct Answer
    D. Insert – table - tentukan jumlah baris dan kolom secara drag
    Explanation
    The correct answer is "Insert - table - tentukan jumlah baris dan kolom secara drag" because it states that by inserting a table and then specifying the number of rows and columns by dragging, the table can be created automatically. This option provides a clear and direct method for creating a table with a specific number of rows and columns.

    Rate this question:

  • 12. 

    Perintah Split Cell berfungsi untuk ….

    • A.

      Menggabungkan sel

    • B.

      Menggabungkan kolom

    • C.

      Membagi tabel

    • D.

      Membagi sel

    • E.

      Menggabungkan baris

    Correct Answer
    C. Membagi tabel
    Explanation
    The correct answer is "membagi tabel". The command "Split Cell" is used to divide a table into multiple cells. This can be useful when you want to split a large table into smaller sections or when you want to separate data within a single cell into multiple cells.

    Rate this question:

  • 13. 

    Perintah Split Cell berfungsi untuk ….

    • A.

      Menggabungkan sel

    • B.

      Menggabungkan kolom

    • C.

      Membagi tabel

    • D.

      Membagi sel

    • E.

      Menggabungkan baris

    Correct Answer
    C. Membagi tabel
    Explanation
    The correct answer is "membagi tabel". The Split Cell command in a table allows users to divide a single cell into multiple cells. This is useful when there is a need to divide a large cell into smaller cells to accommodate more data or to create a more organized layout in the table. By splitting a table, users can easily manage and manipulate the data within each individual cell separately.

    Rate this question:

  • 14. 

    Pembuatan judul tabel terkadang memerlukan beberapa sel yang harus digabung menjadi satu dan merubah perataannya menjadi rata tengah. Pengaturan tersebut menggunakan fungsi ....

    • A.

      A. Wrap Text

    • B.

      B. Cell Styles

    • C.

      C. Merge & Center

    • D.

      D. Justify

    • E.

      E. Merge Across

    Correct Answer
    C. C. Merge & Center
    Explanation
    The correct answer is c. Merge & Center. When creating a table, sometimes it is necessary to combine multiple cells into one and change the alignment to center. The Merge & Center function allows for this by merging the selected cells and centering the content within the merged cell. This helps to create a visually appealing and organized table.

    Rate this question:

  • 15. 

    Custom ini merupakan tempat pengaturan fasilitas yang akan ditampilkan pada quick access toolbar yang lokasinya berada di samping office button . Untuk menambahkan dan menghapus tombol-tombol yang ditempatkan di Customize Ribbon pada MS Word  dapat dilakukan dengan menggunakan kotak dialog….

    • A.

      A. Word Option

    • B.

      B. Print

    • C.

      C. Zoom

    • D.

      D. Page Setup

    • E.

      E. Properties

    Correct Answer
    A. A. Word Option
    Explanation
    The correct answer is a. Word Option. Word Option is the location where users can customize the ribbon in MS Word by adding or removing buttons. It is accessed through a dialog box and allows users to personalize their quick access toolbar.

    Rate this question:

  • 16. 

    Fasilitas word option Bagian jendela yang digunakan untuk mempercepat akses terhadap sebuah tombol perintah adalah….

    • A.

      A. Ribbon

    • B.

      B. Quick Access Toolbar

    • C.

      C. Menu Pop-Up

    • D.

      D. Status Bar

    • E.

      E. Fast Access Toolbar

    • F.

      E. Fast Access Toolbar

    Correct Answer
    B. B. Quick Access Toolbar
    Explanation
    The Quick Access Toolbar is a feature in a software program that allows users to access commonly used commands or functions quickly and easily. It is typically located at the top of the window, above the ribbon or menu bar. By placing frequently used commands on the Quick Access Toolbar, users can save time and increase productivity by avoiding the need to navigate through multiple menus or ribbons to find the desired command.

    Rate this question:

  • 17. 

    Fungsi yang digunakan untuk mencari nilai rata-rata adalah ..................

    • A.

      COUNT

    • B.

      MAX

    • C.

      AVERAGE

    • D.

      MIN

    • E.

      SUM

    Correct Answer
    C. AVERAGE
    Explanation
    The correct answer is AVERAGE. The AVERAGE function is used to calculate the average value of a set of numbers. It adds up all the numbers in the set and then divides the sum by the count of the numbers. This function is commonly used in data analysis and statistics to find the central tendency of a dataset.

    Rate this question:

  • 18. 

    Pada menu finish & merge pada mailing terdapat sub menu apa

    • A.

      A. Blank page

    • B.

      B. Chart

    • C.

      C. Print documents

    • D.

      D. Edit Individual Dokuments

    • E.

      E. C dan D Benar

    Correct Answer
    E. E. C dan D Benar
    Explanation
    The correct answer is e. C dan D Benar. This means that both options C (Print documents) and D (Edit Individual Documents) are correct submenus in the finish & merge menu in mailing.

    Rate this question:

  • 19. 

    Manakah yang tidak termasuk dalam menu mailings

    • A.

      A. Table of contens

    • B.

      B. Labels

    • C.

      C. Envelopes

    • D.

      D. Addres block

    • E.

      E. Insert merge Field

    Correct Answer
    A. A. Table of contens
    Explanation
    The correct answer is "a. Table of contents." The other options (b. Labels, c. Envelopes, d. Address block, and e. Insert merge field) are all features commonly found in the mailings menu. However, a table of contents is not typically included in the mailings menu as it is more commonly used in documents such as reports or books to provide an organized list of sections or chapters.

    Rate this question:

  • 20. 

    Selain pada mailings sendiri, kita bisa membuat database pada program lain yaitu

    • A.

      A. Photoshop

    • B.

      B. Mozzila firefox

    • C.

      C. Microsoft excel

    • D.

      D. Microsoft powerpoint

    • E.

      E. AutoCAD

    Correct Answer
    C. C. Microsoft excel
    Explanation
    Microsoft Excel is a widely used program that allows users to create and manage databases. It provides various features and tools that make it easy to organize and analyze data. With Excel, users can create tables, sort and filter data, perform calculations, and generate reports. Therefore, it is a suitable program for creating databases, in addition to mailings.

    Rate this question:

  • 21. 

    Fungsi dari submenu Envelopes pada menu mailings adalah

    • A.

      A. Membuat tabel

    • B.

      B. Membuat slide

    • C.

      C. Membuat amplop

    • D.

      D. Membuat email

    • E.

      E. Membuat gambar

    Correct Answer
    C. C. Membuat amplop
    Explanation
    The Envelopes submenu in the Mailings menu is used to create envelopes. This feature allows users to easily generate envelopes for mailing purposes.

    Rate this question:

  • 22. 

    Ekstensi file pada Microsoft Power Point adalah……

    • A.

      A .jpg

    • B.

      B .mdb

    • C.

      C .xls

    • D.

      D .doc

    • E.

      E .ppt

    Correct Answer
    E. E .ppt
    Explanation
    The correct answer is e .ppt. The file extension for Microsoft Power Point is .ppt. This extension is used for Power Point presentation files.

    Rate this question:

  • 23. 

    Untuk menghapus efek animasi pada Menu Animation dapat mengklik tombol…..

    • A.

      A Delete

    • B.

      B Cut

    • C.

      C Copy

    • D.

      D None

    • E.

      E Remove

    Correct Answer
    A. A Delete
    Explanation
    To remove the animation effect on the Menu Animation, the user can click on the "Delete" button. This button is likely designed to delete or remove the selected animation from the menu.

    Rate this question:

  • 24. 

    Untuk mencetak halaman aktif pada Ms Word digunakan perintah Current Page pada dialog print. Sedangkan untuk mencetak halaman tertentu digunakan dialog ...

    • A.

      A. Pages -- kemudian menuliskan halaman yang dicetak

    • B.

      B. Current page -- kemudian menuliskan halaman yang dicetak

    • C.

      C. All Pages -- kemudian menuliskan halaman yang dicetak

    • D.

      D. Number of Copies -- kemudian menuliskan halaman yang dicetak

    • E.

      E. A dan B Bener

    Correct Answer
    E. E. A dan B Bener
    Explanation
    The correct answer is e. "A dan B Bener" because to print the active page in MS Word, the "Current Page" command is used in the print dialog. And to print a specific page, the "Pages" command is used, followed by writing the page number to be printed.

    Rate this question:

  • 25. 

    1. Pada Microsoft Excell, Langkah untuk mengubah ukuran kertas adalah

    • A.

      A. Page layout,Page Setup

    • B.

      B. File, Page Set up

    • C.

      C. Format, Paragraph

    • D.

      D. Insert,Paragraph

    • E.

      E. Edit, Setup

    Correct Answer
    A. A. Page layout,Page Setup
    Explanation
    The correct answer is a. Page layout, Page Setup. In Microsoft Excel, to change the paper size, you need to go to the Page Layout tab and click on the Page Setup group. From there, you can select the desired paper size from the options available.

    Rate this question:

  • 26. 

    Menu Page Number pada aplikasi program MS. Word digunakan untuk membuat …

    • A.

      A. Memasukkan halaman baru

    • B.

      B. Memasukkan angka

    • C.

      C. Penomoran halaman

    • D.

      D. Memberi gambar

    • E.

      E. Penghitungan halaman

    Correct Answer
    C. C. Penomoran halaman
    Explanation
    The Menu Page Number pada aplikasi program MS. Word is used for adding page numbers to a document. This feature allows users to easily number the pages in their document, making it easier for readers to navigate through the content. By selecting this option from the menu, users can choose where they want the page numbers to appear, whether it's at the top or bottom of the page, and customize the format and style of the page numbers. This helps in organizing the document and providing a professional look to it.

    Rate this question:

  • 27. 

    Untuk mencetak seluruh halaman pada Ms Word digunakan perintah print digunakan dialog ...

    • A.

      A. Print Selection

    • B.

      B. Print All Pages

    • C.

      C.  Print Custom Range

    • D.

      D. Print Current Page

    • E.

      E. Semua Benar

    Correct Answer
    B. B. Print All Pages
    Explanation
    The correct answer is b. Print All Pages. This option is used to print all the pages in the Microsoft Word document. It is different from the other options because it does not involve selecting specific pages or customizing the print range. Instead, it prints every page in the document.

    Rate this question:

  • 28. 

    Kombinasi perintah keyboard untuk melakukan Percetakan ( Print)  pada dokumen Microsoft Word adalah …

    • A.

      A. CTR + R

    • B.

      B. CTR + C

    • C.

      C. CTR + D

    • D.

      D. CTR + P

    • E.

      E. CTR + G

    Correct Answer
    D. D. CTR + P
    Explanation
    The correct answer is CTR + P. This keyboard combination is used to perform the Print function in Microsoft Word.

    Rate this question:

  • 29. 

    Untuk bisa melihat hasil dari membuat surat masal kita bisa menggunakan menu apa pada mailings

    • A.

      A. Labels

    • B.

      B. Envelope

    • C.

      C. Preview result

    • D.

      D. Clip art

    • E.

      E. Page setup

    Correct Answer
    C. C. Preview result
    Explanation
    To see the results of creating a mass letter, we can use the "Preview result" option in the mailings menu. This option allows us to view how the letter will appear before sending it out, ensuring that everything is formatted correctly and any errors are caught before it is sent. It is an important step in the mailing process to ensure the professionalism and accuracy of the letter.

    Rate this question:

  • 30. 

    Lembar kerja Ms-Excell dikenal dengan sebutan...

    • A.

      A Tabshee

    • B.

      B Worksheet

    • C.

      C Spreadsheet

    • D.

      D Workbook

    • E.

      E Sheet

    Correct Answer
    B. B Worksheet
    Explanation
    A worksheet in MS Excel is a single sheet within a workbook where data can be entered, calculated, and analyzed. It is the primary working area in Excel where users can input and manipulate data. The term "worksheet" is commonly used to refer to this specific feature in Excel.

    Rate this question:

  • 31. 

    Page setup berfungsi untuk…

    • A.

      A. Mengatur halaman

    • B.

      B. Mencetak kertas

    • C.

      C. Keluar dari tampilan

    • D.

      D. Membuka lembar kerja

    • E.

      E. Memprint data

    Correct Answer
    A. A. Mengatur halaman
    Explanation
    Page setup berfungsi untuk mengatur halaman dalam dokumen. Dengan menggunakan fitur ini, pengguna dapat mengatur ukuran kertas, orientasi (potret atau lanskap), margin, dan tata letak halaman lainnya. Pengaturan ini memungkinkan pengguna untuk mengatur tampilan dan format dokumen agar sesuai dengan kebutuhan mereka sebelum mencetak atau membagikan dokumen tersebut.

    Rate this question:

  • 32. 

    1. Pada menu page setup terdapat bagian Orientation, berfungsi  untuk mengatur orientasi atau layout pada pencetakan, lalu jika kita ingin mencetak dokumen dengan posisi kertas horizontal kita perlu memilih.

    • A.

      A. Potrait

    • B.

      B. Paper

    • C.

      C. Landscape

    • D.

      D. Multiple page

    • E.

      E. Preview e. Preview

    Correct Answer
    C. C. Landscape
    Explanation
    The correct answer is "c. Landscape". In the page setup menu, the orientation option allows us to set the layout or orientation for printing. If we want to print the document with a horizontal paper position, we need to select the landscape option. The landscape orientation will adjust the paper layout to be wider than it is tall, allowing for a horizontal printout.

    Rate this question:

  • 33. 

    1. Agar Dokumen Tidak Dapat Dibuka Orang Lain Untuk tujuan tertentu biasanya seseorang memproteksi agar dokumennya hanya dapat dibuka oleh orang-orang tertentu yang diperbolehkannya, untuk tujuan keamanan. Misalnya file pekerjaan, file tugas penting, maka kita perlu melakuaka.

    • A.

      A. Protect Document, pilih Encrypt with Password

    • B.

      B. Protect Document, pilih mark As Final

    • C.

      C. Protect Document, pilih restrict Editing

    • D.

      D. Protect Document, pilih restrict pemission by people

    • E.

      E. Semua Salah

    Correct Answer
    A. A. Protect Document, pilih Encrypt with Password
    Explanation
    The correct answer is a. Protect Document, pilih Encrypt with Password. This option allows the user to protect the document by encrypting it with a password. This means that only those who have the password will be able to open and access the document, providing an extra layer of security and ensuring that it cannot be opened by unauthorized individuals.

    Rate this question:

  • 34. 

    Kumpulan beberapa cell pada microsot excel disebut….  

    • A.

      Cell excel

    • B.

      Workbook

    • C.

      Worksheet

    • D.

      Cell

    • E.

      Range

    Correct Answer
    E. Range
    Explanation
    A range in Microsoft Excel refers to a collection of multiple cells that are selected together. It allows for performing operations or applying formatting changes to multiple cells simultaneously. This can be useful when working with a large amount of data or when needing to perform calculations or formatting changes across a specific group of cells.

    Rate this question:

  • 35. 

    1. Agar Dokumen Dapat Dibuka, Namun Tidak Dapat Disalin oleh Orang Lain maka kita erlu melakukan.

    • A.

      A. Protect Document, pilih mark As Final centang Allow only this type of editing in the document pilih Filling in forms

    • B.

      B. Protect Document, pilih Restrict Editing centang Allow only this type of editing in the document pilih Filling in forms

    • C.

      C. Protect Document, pilih restrict pemission by people centang Allow only this type of editing in the document pilih Filling in forms

    • D.

      D. Protect Document, pilih Print centang Allow only this type of editing in the document pilih Filling in forms

    Correct Answer
    B. B. Protect Document, pilih Restrict Editing centang Allow only this type of editing in the document pilih Filling in forms
    Explanation
    The correct answer is b. By selecting "Protect Document" and choosing "Restrict Editing," we can limit the type of editing allowed in the document. By checking "Allow only this type of editing in the document" and selecting "Filling in forms," we ensure that others can open the document but cannot copy its contents. This option provides the necessary protection to prevent others from copying the document.

    Rate this question:

  • 36. 

    Ikon “Undo” berfungsi ….

    • A.

      Mencetak dokumen

    • B.

      Menyimpan dokumen

    • C.

      Membuka file

    • D.

      Memotong bagian dari dokumen

    • E.

      Membatalkan pengerjaan

    Correct Answer
    E. Membatalkan pengerjaan
    Explanation
    The correct answer is "membatalkan pengerjaan" which means "to cancel the action". In the context of the given options, the "Undo" function is used to reverse or undo the previous action or changes made in a document or file. This feature is commonly found in software applications and allows users to revert back to the previous state before the action was performed.

    Rate this question:

  • 37. 

    Untuk menembah garis dalam Excel, perintah yang diklik pada menu Insert adalah ….

    • A.

      Insert Cells

    • B.

      Insert Sheet Rows

    • C.

      Insert Sheet Column

    • D.

      Insert Sheet

    • E.

      Insert Name

    Correct Answer
    B. Insert Sheet Rows
    Explanation
    The correct answer is "Insert Sheet Rows". This option is selected from the Insert menu in Excel to add new rows to the worksheet. By choosing this command, users can insert a new row above the selected row or rows, shifting the existing rows down. This option is useful when there is a need to add more data or information to the worksheet without overwriting or deleting any existing content.

    Rate this question:

  • 38. 

    1. Function dari Ms. Excel yang digunakan untuk menghitung jumlah karakter/text adalah

    • A.

      LENGTH

    • B.

      LEN

    • C.

      COUNT

    • D.

      SUM

    • E.

      DSUM

    Correct Answer
    B. LEN
    Explanation
    The LEN function in Ms. Excel is used to calculate the length of a text or a string of characters. It counts the number of characters in a cell, including spaces and punctuation marks. This function is useful when you need to determine the length of a text for various purposes, such as data validation or formatting.

    Rate this question:

  • 39. 

    Function dari Ms. Excel yang digunakan untuk menghitung number dari suatu interval dengan kondisi yang diinginkan adalah ....

    • A.

      A. COUNTIF

    • B.

      B. DCOUNT

    • C.

      C. SUMIF

    • D.

      D. SUM

    • E.

      E. COUNT

    Correct Answer
    A. A. COUNTIF
    Explanation
    The correct answer is A. COUNTIF. This function in Microsoft Excel is used to count the number of cells within a specified range that meet a certain condition or criteria. It allows users to count cells based on a single condition or multiple conditions using logical operators such as equal to, not equal to, greater than, less than, etc. This function is useful for analyzing data and extracting specific information from a range of cells.

    Rate this question:

  • 40. 

    Yang digunakan untuk mengurutkan data dari A-Z adalah

    • A.

      A. sort ascending

    • B.

      B. sort descending

    • C.

      C. copy

    • D.

      D. paste

    • E.

      E. paint

    Correct Answer
    A. A. sort ascending
    Explanation
    The correct answer is a. sort ascending. Sorting data in ascending order means arranging it from the lowest value to the highest value, in alphabetical or numerical order. This can be done using various algorithms or functions in programming or spreadsheet software, such as Excel.

    Rate this question:

  • 41. 

    Yang digunakan untuk mengurutkan data dari Z - A adalah

    • A.

      A. sort ascending

    • B.

      B. sort descending

    • C.

      C. copy

    • D.

      D. paste

    • E.

      E. paint

    Correct Answer
    B. B. sort descending
    Explanation
    The correct answer is "b. sort descending". This option refers to the process of arranging data in a reverse order, from highest to lowest or from Z to A in alphabetical order. In this case, it is used to sort the data in a descending order.

    Rate this question:

  • 42. 

    Ekstensi yang digunakan pada Ms.Excel adalah ....

    • A.

      *.cdr

    • B.

      *.xls

    • C.

      *.ppt

    • D.

      *.exl

    • E.

      *.pwt

    Correct Answer
    D. *.exl
    Explanation
    The correct answer is *.exl because it is the file extension used for Microsoft Excel files. Microsoft Excel is a spreadsheet program used for creating and manipulating data in the form of tables. The file extension *.exl indicates that the file is compatible with Microsoft Excel and can be opened and edited using the software.

    Rate this question:

  • 43. 

    Animasi pengaturan slide pada saat ditampikan disebut...

    • A.

      Efek transisi

    • B.

      Efek slide

    • C.

      Efek animas

    • D.

      Efek layout

    • E.

      Media clip

    Correct Answer
    A. Efek transisi
    Explanation
    The correct answer is "efek transisi" because it refers to the animation or visual effects that are applied to slides when they are being displayed in a presentation. These effects help to enhance the visual appeal and smooth transition between slides, making the presentation more engaging and professional.

    Rate this question:

  • 44. 

    Kita dapat memberikan background pada presentasi MS Powerpoint 2007 melalui fitur....

    • A.

      Home

    • B.

      Animation

    • C.

      Ribbon insert

    • D.

      Insert

    • E.

      Design

    Correct Answer
    E. Design
    Explanation
    The correct answer is "Design". In MS Powerpoint 2007, the Design feature allows us to give a background to our presentation. This feature enables us to choose from a variety of pre-designed templates and themes that can enhance the visual appeal of our slides. It helps in creating a consistent and professional look for our presentation by providing options for colors, fonts, and layouts.

    Rate this question:

  • 45. 

    File presentasi yang dicetak lebih dari satu slide dalam satu halaman disebut....

    • A.

      Handouts

    • B.

      Slide

    • C.

      Outline view

    • D.

      Note pages

    • E.

      .Printing

    Correct Answer
    A. Handouts
    Explanation
    Handouts are printed presentations that contain more than one slide per page. They are often used for distributing copies of a presentation to the audience, allowing them to follow along and take notes. Handouts are a convenient way to provide a condensed version of the slides and can be customized to include additional information or space for notes.

    Rate this question:

  • 46. 

    Tempat meletakkan file-file yang diperlukan oleh website adalah….

    • A.

      Proxy

    • B.

      Domain

    • C.

      Hosting

    • D.

      TCP/IP

    • E.

      LAN

    Correct Answer
    C. Hosting
    Explanation
    The correct answer is "Hosting". Hosting refers to the location where all the necessary files for a website are stored. It is a service provided by a hosting provider that allows individuals or organizations to make their website accessible on the internet. The hosting provider allocates space on a server to store the website's files, including HTML, CSS, images, and other media. When a user accesses the website, the files are retrieved from the hosting server and displayed on their device.

    Rate this question:

  • 47. 

    Di bawah ini yang merupakan aplikasi web browser, yaitu….

    • A.

      Google

    • B.

      Yahoo

    • C.

      Windows explorer

    • D.

      Google chrome

    • E.

      Youtube

    Correct Answer
    D. Google chrome
    Explanation
    The correct answer is Google Chrome because it is the only option listed that is a web browser. Google, Yahoo, and YouTube are search engines, while Windows Explorer is a file management tool.

    Rate this question:

  • 48. 

    Apa yang dimaksud dengan up date data...

    • A.

      Memperbaharui data

    • B.

      Menambah data

    • C.

      Menghapus data

    • D.

      Menyembunyikan data

    • E.

      Membuat data baru

    Correct Answer
    A. Memperbaharui data
    Explanation
    The correct answer is "memperbaharui data" which means "updating data" in English. This term refers to the process of making changes or modifications to existing data in order to keep it current and accurate. It involves revising or adding new information, correcting errors, and ensuring that the data reflects the most recent and relevant information available.

    Rate this question:

  • 49. 

    Untuk penulisan rumus jumlah di sel B2 dengan sel C2 yang benar di bawah ini adalah

    • A.

      +Sum(B2…C2)

    • B.

      =Sum(B2:C2)

    • C.

      =Sum(B2

    • D.

      =Sum(B2…C2)

    • E.

      =Sum(B2,C2)

    Correct Answer
    B. =Sum(B2:C2)
    Explanation
    The correct answer is =Sum(B2:C2). This formula will sum the values in cells B2 and C2. The ":" symbol is used to indicate a range of cells, so B2:C2 represents all the cells between B2 and C2, inclusive. The Sum function adds up the values in the specified range, giving the desired result.

    Rate this question:

  • 50. 

    Fungsi untuk perhitung Nilai terendah menggunakan perintah ……….

    • A.

      Sum

    • B.

      Average

    • C.

      Count

    • D.

      Max

    • E.

      Min

    Correct Answer
    E. Min
    Explanation
    The correct answer is "Min". The function "Min" is used to calculate the lowest value in a set of numbers. It is commonly used in mathematical and statistical calculations to find the minimum value in a dataset.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 17, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Aug 18, 2018
    Quiz Created by
    Bayuiman23
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.