Soal Perbaikan Uas Komputer Akuntansi

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 Muttaqin
M
Muttaqin
Community Contributor
Quizzes Created: 3 | Total Attempts: 11,210
Questions: 50 | Attempts: 1,135

SettingsSettingsSettings
Soal Perbaikan Uas Komputer Akuntansi - Quiz

Questions and Answers
  • 1. 

    MYOB Merupakan aplikasi akuntansi terpadu yang memadukan beberapa modul,dengan fasilitas lengkap, fleksibel dan mudah digunakan sehingga menghasilkan laporan  keuangan dengan cepat dan akurat  Apa kepanjangan dari MYOB?

    • A.

      Make Your Own Business

    • B.

      Mind Your Own Business

    • C.

      Made Your Own Business

    • D.

      My Your Own Business

    • E.

      Mine Your Own Business

    Correct Answer
    B. Mind Your Own Business
    Explanation
    The correct answer is "Mind Your Own Business." The acronym MYOB stands for Mind Your Own Business. It is an integrated accounting application that combines multiple modules and provides complete, flexible, and user-friendly facilities to generate financial reports quickly and accurately.

    Rate this question:

  • 2. 

    Pada waktu menyiapkan data awal perusahaan dengan MYOB ada kolom Last Month of Financial Year yang harus diisi dengan mengentri   

    • A.

      Bulan Akhir Tahun

    • B.

      Bulan Transaksi

    • C.

      Jumlah bulan dalam Tahun Buku Berjalan

    • D.

      Bulan awal Pembukuan

    • E.

      Tahun Pembukuan

    Correct Answer
    A. Bulan Akhir Tahun
    Explanation
    The correct answer is "Bulan Akhir Tahun" because the question is asking for the column that needs to be filled when preparing the initial data for a company using MYOB. "Bulan Akhir Tahun" translates to "Last Month of Financial Year" in English, which indicates that this column should be filled with the last month of the financial year.

    Rate this question:

  • 3. 

    Mencatat saldo awal dalam akun buku besar dalam MYOB dilakukan dengan memilih menu 

    • A.

      Setup – Balances – Job Opening Balance

    • B.

      Setup – Balances - Account Opening Balance

    • C.

      Setup – Balances - Customer

    • D.

      Setup – Balances – Supplier

    • E.

      Account Opening Balance - Setup – Balances

    Correct Answer
    B. Setup – Balances - Account Opening Balance
    Explanation
    To record the initial balance in the general ledger account in MYOB, you need to select the "Setup - Balances - Account Opening Balance" option. This option allows you to enter the starting balance for each account in the general ledger, ensuring accurate financial records from the beginning. The other options mentioned are not specifically related to recording the initial balance in the general ledger account.

    Rate this question:

  • 4. 

    Berikut ini adalah kode akun yang dapat digunakan untuk aktiva tetap yaitu ...

    • A.

      8-1200

    • B.

      4-1200

    • C.

      2-2100

    • D.

      1-2100

    • E.

      3-1200

    Correct Answer
    D. 1-2100
    Explanation
    The correct answer is "1-2100" because it is the only account code that is associated with the fixed assets category. The other account codes mentioned are either not related to fixed assets or are duplicates.

    Rate this question:

  • 5. 

    Yang bukan Kelebihan program MYOB adalah ...

    • A.

      Bisa menggunakan semua metode penilaian persediaan

    • B.

      Dicatat dengan mengisi form bukti transaksi

    • C.

      Cukup mengisi form bukti transaksi dan setting awal

    • D.

      Risiko terjadi kesalahan sedikit

    • E.

      Waktu pengerjaan yang relatif cepat

    Correct Answer
    C. Cukup mengisi form bukti transaksi dan setting awal
    Explanation
    The correct answer is "Cukup mengisi form bukti transaksi dan setting awal". The explanation for this answer is that one of the advantages of the MYOB program is that it allows for the use of all inventory valuation methods. The other options mentioned in the question, such as recording transactions by filling out transaction forms and the relatively fast completion time, can be considered as advantages of the MYOB program. However, the option "Cukup mengisi form bukti transaksi dan setting awal" does not represent an advantage of the program, as it implies that only filling out transaction forms and initial settings are sufficient, which may not be the case.

    Rate this question:

  • 6. 

    Membuat sebuah data akuntansi perusahaan yang baru dengan program Myob melalui cara mengklik ...

    • A.

      Open

    • B.

      Whats news

    • C.

      Create

    • D.

      Exit

    • E.

      Explore

    Correct Answer
    C. Create
    Explanation
    The correct answer is "create". This is because the question is asking for the action to be taken in order to make a new accounting data for a company using the Myob program. The word "create" implies the action of generating or forming something new, which aligns with the task of making a new accounting data.

    Rate this question:

  • 7. 

    Diterima dividend Kas Rp 5.000.000,- untuk mengerjakan transaksi tersebut diklik ...

    • A.

      Command Centre – Banking – Receive Money

    • B.

      Command Centre – Banking – Spend Money

    • C.

      Command Centre – Sales – Receive Payment

    • D.

      Command Centre – Sales – Enter Sales

    • E.

      Command Centre – Purchases – Pay Bill

    Correct Answer
    A. Command Centre – Banking – Receive Money
    Explanation
    The correct answer is "Command Centre – Banking – Receive Money" because the question mentions receiving a dividend payment. In the context of banking, receiving money typically refers to receiving payments or funds into an account. Therefore, the correct option would be to use the "Receive Money" function in the banking section of the command centre.

    Rate this question:

  • 8. 

    Pada waktu menyiapkan data awal perusahaan dengan MYOB ada kolom Conversion Month yang harus diisi dengan mengentri .........

    • A.

      Bulan akhir tahun

    • B.

      Bulan Transaksi

    • C.

      Jumlah bulan dalam Tahun Buku Berjalan

    • D.

      Tahun Pembukuan

    • E.

      Bulan awal Pembukuan

    Correct Answer
    B. Bulan Transaksi
    Explanation
    The correct answer is "Bulan Transaksi". In MYOB, the Conversion Month column is used to indicate the month of transaction. This means that when preparing the initial data for the company, the user needs to enter the month of the transaction in this column.

    Rate this question:

  • 9. 

    Perintah Setup – Balances - Account Opening Balance digunakan untuk

    • A.

      Mengentry Saldo Subsidiary Ledger

    • B.

      Mengentry Saldo Awal setiap akun Buku besar

    • C.

      Mengentry Saldo Piutang

    • D.

      Mengentry Saldo Utang

    • E.

      Mengentry Saldo Persediaan

    Correct Answer
    B. Mengentry Saldo Awal setiap akun Buku besar
    Explanation
    The correct answer is "Mengentry Saldo Awal setiap akun Buku besar". This means that the Setup - Balances - Account Opening Balance command is used to enter the initial balance for each account in the General Ledger. This allows for accurate record-keeping and tracking of financial transactions in the accounting system.

    Rate this question:

  • 10. 

    Untuk mengamankan data serta berjaga-jaga terhadap hal-hal yang tidak diinginkan, maka sebaiknya dilakukan ...

    • A.

      Export Data

    • B.

      Import Data

    • C.

      Verifikasi Data

    • D.

      Back Up Data

    • E.

      Restore Data

    Correct Answer
    D. Back Up Data
    Explanation
    To secure and protect data from unwanted incidents, it is advisable to perform a backup of the data. This process involves creating a copy of the data and storing it in a separate location or storage device. By doing so, in case of data loss or corruption, the backup can be used to restore the data to its previous state. This ensures data integrity and minimizes the risk of permanent data loss.

    Rate this question:

  • 11. 

    Mencatat neraca saldo awal akun Utang dalam MYOB dilakukan dengan memilih menu ……

    • A.

      Setup – Balances – Job Openeng Balances

    • B.

      Setup – Balances – Customer Balances

    • C.

      Setup – Balances – Supplier Balances

    • D.

      Setup – Balances - Account Opening Balances

    • E.

      Account Opening Balance - Setup – Balances

    Correct Answer
    D. Setup – Balances - Account Opening Balances
    Explanation
    The correct answer is "Setup - Balances - Account Opening Balances" because this option is the most relevant and specific to the task of recording the initial balance of the Utang (Debt) account in MYOB. The other options do not mention anything about opening balances or specifically relate to the task at hand.

    Rate this question:

  • 12. 

    Program MYOB termasuk kelompok ...

    • A.

      Input dan Output

    • B.

      Brainwares

    • C.

      Hardwares

    • D.

      Process

    • E.

      Softwares

    Correct Answer
    E. Softwares
    Explanation
    The correct answer is "Softwares" because the question is asking about the group that the program MYOB belongs to. MYOB is a software program, so it falls under the category of "Softwares".

    Rate this question:

  • 13. 

    Format tanggal program MYOB Sejak awal adalah ....

    • A.

      YYYY/MM/DD

    • B.

      DD/MM/YYYY

    • C.

      MM/DD/YYYY

    • D.

      YYYY/DD/MM

    • E.

      MM/YYYY/DD

    Correct Answer
    C. MM/DD/YYYY
    Explanation
    The correct answer is MM/DD/YYYY. This is because the format for the date in the MYOB program is Month/Day/Year.

    Rate this question:

  • 14. 

    Yang dimaksudkan dengan Current Financial Year ...

    • A.

      Periode akuntansi yang sedang berjalan

    • B.

      Periode akuntansi yang akan datang

    • C.

      Periode akuntansi yang lalu

    • D.

      Periode akuntansi selama perusahaan beraktivitas

    • E.

      Periode akuntansi tertentu

    Correct Answer
    A. Periode akuntansi yang sedang berjalan
    Explanation
    The correct answer is "Periode akuntansi yang sedang berjalan" which means the current accounting period. This refers to the period of time in which the financial transactions and activities of a company are being recorded and reported. It is the ongoing period in which the company is currently operating and conducting its business.

    Rate this question:

  • 15. 

    Yang dimaksud dengan Last Month of Financial Year yaitu ...

    • A.

      Bulan awal dan akhir dari periode akuntansi

    • B.

      Bulan akhir dari periode akuntansi

    • C.

      Akhir bulan (Desember) dari periode akuntansi

    • D.

      Akhir bulan (Januari) dari periode akuntansi

    • E.

      Bulan awal dari periode akuntansi

    Correct Answer
    C. Akhir bulan (Desember) dari periode akuntansi
    Explanation
    The Last Month of Financial Year refers to the end of the accounting period, which is typically in December. This is when companies finalize their financial statements and prepare for the start of a new fiscal year. It is important for businesses to accurately record and report their financial activities during this time in order to assess their performance and make informed decisions for the upcoming year.

    Rate this question:

  • 16. 

     Yang dimaksud dengan Conversion Month yaitu ...

    • A.

      Bulan saat terjadinya transaksi keuangan

    • B.

      Bulan pertama digunakan komputer akuntansi

    • C.

      Bulan awal periode akuntansi yang berjalan

    • D.

      Bulan akhir periode akuntansi yang berjalan

    • E.

      Bulan pergantian periode akuntansi

    Correct Answer
    A. Bulan saat terjadinya transaksi keuangan
    Explanation
    Conversion Month refers to the month in which financial transactions occur. This term is commonly used in accounting to determine the time period during which financial data is recorded. It is important to identify the specific month when transactions take place in order to accurately record and analyze financial information.

    Rate this question:

  • 17. 

    Jika perusahaan menggunakan jumlah periode 13 bulan, maka bulan ke-13 khusus untuk: 

    • A.

      Mencatat transaksi bulan Desember

    • B.

      Mencatat transaksi kesalahan

    • C.

      Mencatat transaksi awal periode

    • D.

      Mencatat rekonsiliasi akun-akun tertentu

    • E.

      Mencatat transaksi penyesuaian (adjustment)

    Correct Answer
    E. Mencatat transaksi penyesuaian (adjustment)
    Explanation
    Bulan ke-13 dalam jumlah periode 13 bulan digunakan khusus untuk mencatat transaksi penyesuaian (adjustment). Transaksi penyesuaian adalah transaksi yang dilakukan untuk menyesuaikan saldo akun-akun tertentu pada akhir periode dengan kondisi yang sebenarnya. Dalam hal ini, bulan ke-13 digunakan untuk mencatat semua penyesuaian yang perlu dilakukan setelah mencatat transaksi bulan Desember dan melakukan rekonsiliasi akun-akun tertentu.

    Rate this question:

  • 18. 

     Nama file data bisnis harus unik, artinya:

    • A.

      Nama file harus mudah diingat

    • B.

      Nama file harus mudah ditemukan atau dicari

    • C.

      Nama file harus spesifik tidak ada yang menyamai

    • D.

      Nama file disimpan di folder khusus

    • E.

      Nama file harus sama digunakan berkali-kali

    Correct Answer
    A. Nama file harus mudah diingat
    Explanation
    The correct answer is "Nama file harus mudah diingat" because having a unique business data file name means that the file name should be easy to remember. This is important to ensure that users can easily recall the file name when they need to access or refer to it later. Having a memorable file name also helps in efficient file management and prevents confusion or mistakes when searching for or retrieving specific files.

    Rate this question:

  • 19. 

    Program aplikasi yang dapat kita gunakan untuk melakukan system Otomatisasi pembukuan secara lengkap, cepat dan akurat adalah…

    • A.

      MYOB Accounting.

    • B.

      Microsoft Excel

    • C.

      PowerPoint

    • D.

      Microsoft Word

    • E.

      Microsoft Access

    Correct Answer
    A. MYOB Accounting.
    Explanation
    MYOB Accounting is a program that is specifically designed for automating bookkeeping processes. It offers comprehensive features to efficiently manage financial transactions, track expenses and income, generate reports, and ensure accuracy in accounting tasks. This software is widely used by businesses to streamline their bookkeeping processes and improve efficiency in financial management.

    Rate this question:

  • 20. 

    Menu Shortcut atau Keyboard yang berfungsi untuk membuka file baru adalah …

    • A.

      Ctr + P

    • B.

      Ctr + G

    • C.

      Ctr + N

    • D.

      Ctr + T

    • E.

      Ctr + O

    Correct Answer
    E. Ctr + O
    Explanation
    The correct answer is Ctrl + O. This keyboard shortcut is commonly used in various software applications to open a new file. By pressing Ctrl + O, users can quickly access the file browser or open dialog box, allowing them to select and open a file of their choice. This shortcut is a convenient way to initiate the process of creating or working with a new file without having to navigate through multiple menus or options.

    Rate this question:

  • 21. 

    Digunakan  untuk  memulai  program  MYOB  Accounting,  yang  dapat  anda  lakukan  adalah memilih menu …

    • A.

      Option

    • B.

      Option

    • C.

      Option

    • D.

      Option

    • E.

      Option

    Correct Answer
    B. Option
    Explanation
    The given correct answer is "option". This is because the question states that to start the MYOB Accounting program, you need to select a menu. The answer "option" implies that there are multiple menu options available, and you need to choose one of them to start the program.

    Rate this question:

  • 22. 

    Digunakan  untuk  membuka program MYOB  Accounting yang sudah pernah anda buat sebelumnya, maka yang  dapat  anda  lakukan  adalah memilih menu …

    • A.

      Option

    • B.

      Option

    • C.

      Option

    • D.

      Option

    • E.

      Option

    Correct Answer
    A. Option
  • 23. 

    Digunakan  untuk  mengeksplorasi yang ada pada MYOB  Accounting, maka yang  dapat  anda  lakukan  adalah memilih menu …

    • A.

      Option

    • B.

      Option

    • C.

      Option

    • D.

      Option

    • E.

      Option

    Correct Answer
    C. Option
    Explanation
    The given correct answer is "option". The explanation for this answer is not available as the question is incomplete and does not provide any context or options to choose from.

    Rate this question:

  • 24. 

    Digunakan  untuk  keluar dari program MYOB  Accounting, maka yang  dapat  anda  lakukan adalah memilih menu …

    • A.

      Option

    • B.

      Option

    • C.

      Option

    • D.

      Option

    • E.

      Option

    Correct Answer
    E. Option
    Explanation
    The given question is incomplete and not readable, so it is not possible to generate an explanation for the correct answer.

    Rate this question:

  • 25. 

    Jika kita ingin membuat laporan keuangan dengan data baru maka kita memilih option .....

    • A.

      Option

    • B.

      Option

    • C.

      Option

    • D.

      Option

    • E.

      Option

    Correct Answer
    B. Option
    Explanation
    The explanation for the given correct answer is not available.

    Rate this question:

  • 26. 

    Untuk menginput data  awal bulan dimulainya keuangan adalah …

    • A.

      Current Financial year

    • B.

      Last month of Financial year

    • C.

      Number of accounting period

    • D.

      Conversion month

    • E.

      Tax code

    Correct Answer
    B. Last month of Financial year
    Explanation
    The correct answer is "Last month of Financial year." This means that the input of data for the starting month of the financial year should be the last month of the financial year. This is important as it helps ensure that all the financial data for the previous year is accurately recorded before starting the new financial year.

    Rate this question:

  • 27. 

     Untuk memasukkan bulan berakhirnya tahun fiskal perusahaan terdapat pada kolom …

    • A.

      Current Financial year

    • B.

      Last month of Financial year

    • C.

      Number of accounting period

    • D.

      Tax code

    • E.

      Conversion month

    Correct Answer
    B. Last month of Financial year
    Explanation
    The correct answer is "Last month of Financial year". This is because the question is asking for the column where the end month of the fiscal year for a company is entered. The last month of the financial year is the period when the financial statements are prepared and finalized, and it is important to record this information accurately for financial reporting and tax purposes.

    Rate this question:

  • 28. 

    Untuk memasukan jumlah periode akuntansi dalam satu tahun keuangan perusahaan terdapat pada …

    • A.

      Current Financial year

    • B.

      Last month of Financial year

    • C.

      Number of accounting periode

    • D.

      Tax code

    • E.

      Conversion month

    Correct Answer
    C. Number of accounting periode
    Explanation
    The correct answer is "Number of accounting periode." This option refers to the concept of dividing the financial year into different accounting periods. The number of accounting periods can vary depending on the company's reporting requirements and preferences. By dividing the financial year into multiple periods, it becomes easier to track and analyze financial performance over time. This allows for better monitoring of revenue, expenses, and other financial metrics.

    Rate this question:

  • 29. 

    Memasukkan data atau mengedit data account Aktiva dapat mengaktifkan menu …

    • A.

      Asset

    • B.

      Income

    • C.

      Liability

    • D.

      Expense

    • E.

      Equity

    Correct Answer
    A. Asset
    Explanation
    By entering or editing data for an asset account, it activates the menu for managing assets. This implies that the correct answer is "Asset".

    Rate this question:

  • 30. 

    Memasukkan data atau mengedit data account Hutang dapat mengaktifkan menu …

    • A.

      Asset

    • B.

      Income

    • C.

      Liability

    • D.

      Expense

    • E.

      Equity

    Correct Answer
    C. Liability
    Explanation
    Memasukkan data atau mengedit data account Hutang mengaktifkan menu Liability karena hutang adalah kewajiban finansial yang harus dibayar oleh perusahaan kepada pihak lain. Dengan memasukkan atau mengedit data hutang, perusahaan dapat melacak dan mengelola kewajiban keuangan mereka.

    Rate this question:

  • 31. 

    Memasukkan data atau mengedit data account Pendapatan dapat mengaktifkan menu …

    • A.

      Asset

    • B.

      Income

    • C.

      Liability

    • D.

      Expense

    • E.

      Equity

    Correct Answer
    B. Income
    Explanation
    By entering or editing data in the Income account, it can activate the menu related to income. This suggests that the system or software being used has specific features or options that are only accessible when working with income-related data. This could include functions such as generating income statements, calculating profit or loss, tracking revenue streams, or analyzing income trends.

    Rate this question:

  • 32. 

    Siklus akuntansi perusahaan dagang dimulai dengan adanya ……

    • A.

      Transaksi

    • B.

      Buku Besar

    • C.

      Bukti Transaksi

    • D.

      Neraca Saldo

    • E.

      Jurnal

    Correct Answer
    A. Transaksi
    Explanation
    The correct answer is "Transaksi". The accounting cycle for a trading company begins with the occurrence of transactions. Transactions are the economic events that result in a change in the financial position of the company. These transactions are recorded in the accounting system through various documents such as invoices, receipts, and vouchers. The recording of transactions is the first step in the accounting cycle, which is essential for preparing financial statements and making informed business decisions.

    Rate this question:

  • 33. 

     Istilah untuk daftar akun dalam MYOB Acc. V 19 adalah …

    • A.

      General Ledger

    • B.

      Profit of loss

    • C.

      General Journal

    • D.

      Balance Sheet

    • E.

      Account List

    Correct Answer
    E. Account List
    Explanation
    The correct answer is "Account List". In MYOB Acc. V 19, the term used for the list of accounts is "Account List". This refers to the comprehensive list of all the accounts that are set up in the software, including their names, numbers, and types. The Account List is an essential feature in MYOB Acc. V 19 as it allows users to easily manage and track their financial transactions and generate accurate financial reports.

    Rate this question:

  • 34. 

    Tahapan awal untuk mencatat transaksi pembelian tunai adalah ……

    • A.

      Banking >> Spend Money

    • B.

      Banking >> Receive Money

    • C.

      Banking >> Prepare Bank Deposit

    • D.

      Banking >> Recondite Account

    • E.

      Banking >> Bank Register

    Correct Answer
    A. Banking >> Spend Money
    Explanation
    The correct answer is "Banking >> Spend Money" because when recording a cash purchase transaction, the money is being spent from the bank account. This option accurately reflects the initial step in recording a cash purchase transaction.

    Rate this question:

  • 35. 

    Receive Payments dalam MYOB V19 digunakan untuk mencatat transaksi …

    • A.

      Pelunasan Utang Dagang

    • B.

      Pelunasan Piutang Dagang

    • C.

      Retur Pembelian

    • D.

      Pembayaran Gaji

    • E.

      Retur Penjualan

    Correct Answer
    B. Pelunasan Piutang Dagang
    Explanation
    Receive Payments dalam MYOB V19 digunakan untuk mencatat pelunasan piutang dagang. Ini berarti bahwa fitur ini memungkinkan pengguna untuk mencatat pembayaran yang diterima dari pelanggan yang memiliki utang dagang kepada perusahaan. Dengan menggunakan fitur ini, pengguna dapat mencatat setiap pembayaran yang diterima dan mengurangi jumlah piutang yang harus dibayar oleh pelanggan.

    Rate this question:

  • 36. 

    Pay Bill dalam MYOB V18 digunakan untuk mencatat transaksi …

    • A.

      Pembayaran Utang Dagang

    • B.

      Penerimaan Piutang Dagang

    • C.

      Retur Pembelian

    • D.

      Pembayaran Gaji

    • E.

      Retur Penjualan

    Correct Answer
    D. Pembayaran Gaji
    Explanation
    The correct answer is "Pembayaran Gaji." In MYOB V18, the Pay Bill function is used to record salary payments made to employees. This feature allows businesses to accurately track and manage their payroll expenses. By using the Pay Bill function, companies can ensure that their employees are paid on time and that all salary transactions are properly recorded in their accounting system.

    Rate this question:

  • 37. 

    Untuk menghitung rata-rata dalam suatu range kita menggunakan formula…

    • A.

      =sum()

    • B.

      =max()

    • C.

      =count()

    • D.

      =round()

    • E.

      =average()

    Correct Answer
    E. =average()
    Explanation
    The correct answer is =average(). This is because the question asks for the formula to calculate the average within a range. The =average() function in Excel is specifically designed to calculate the average of a range of numbers.

    Rate this question:

  • 38. 

    Microsoft Excel merupakan progran aplikasi...

    • A.

      Wordprosesor

    • B.

      Presentasi

    • C.

      Animasi

    • D.

      Sistem Operasi

    • E.

      Spreadsheet

    Correct Answer
    E. Spreadsheet
    Explanation
    Microsoft Excel is a program application that is primarily used for creating and managing spreadsheets. It allows users to input and organize data in a tabular format, perform calculations, create charts and graphs, and analyze data using various functions and formulas. Therefore, the correct answer for this question is "Spreadsheet".

    Rate this question:

  • 39. 

     Extensi yang di hasilkan oleh file spreadsheet adalah… 

    • A.

      Doc

    • B.

      Exe

    • C.

      Ppt

    • D.

      Xls

    • E.

      Mdb

    Correct Answer
    D. Xls
    Explanation
    The correct answer is Xls. The file extension "Xls" is associated with spreadsheet files created using Microsoft Excel. Excel is a popular software used for creating, organizing, and analyzing data in tabular form. The Xls extension indicates that the file is in the binary file format used by Excel for storing spreadsheet data.

    Rate this question:

  • 40. 

    Cara yang tepat unutk mengaktifkan ms- excel adalah…

    • A.

      Start – program – ms office – ms word

    • B.

      Ms excel – start – program – ms office

    • C.

      Program – ms excel – start – ms office

    • D.

      Start – program – ms office – ms excel

    • E.

      Semua benar

    Correct Answer
    D. Start – program – ms office – ms excel
    Explanation
    The correct answer is "Start - program - ms office - ms excel". This is the correct sequence of steps to activate or open Microsoft Excel. Starting from the "Start" menu, the user should navigate to the "Programs" folder, then locate and open the "Microsoft Office" folder, and finally select and open the "Microsoft Excel" application. This will launch Microsoft Excel and allow the user to start using the program.

    Rate this question:

  • 41. 

    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". The word "Undo" in the question suggests that it is a command or function that allows the user to reverse or undo the previous action or changes made. Therefore, the correct answer implies that the function of the "Undo" button is to cancel or revert the ongoing work or action.

    Rate this question:

  • 42. 

    Worksheet adalah …

    • A.

      Kumpulan dari worksheet

    • B.

      Kumpulan beberapa sel

    • C.

      Pertemuan antara baris dengan kolom

    • D.

      Pertemuan antara sel dengan range

    • E.

      Lembar kerja dalam excel

    Correct Answer
    E. Lembar kerja dalam excel
    Explanation
    The correct answer is "Lembar kerja dalam excel". This is because "Lembar kerja dalam excel" translates to "Worksheet in Excel" in English. A worksheet is a single sheet within a workbook where data is entered and manipulated. It is a grid of cells organized in rows and columns, allowing users to perform calculations, create charts, and analyze data. Therefore, the correct answer accurately describes what a worksheet is in the context of Excel.

    Rate this question:

  • 43. 

    Apa yang dimaksud dengan sel (Cell) dalam excel ?

    • A.

      Kumpulan dari worksheet

    • B.

      Kumpulan beberapa sel

    • C.

      Pertemuan antara baris dengan kolom

    • D.

      Pertemuan antara sel dengan range

    • E.

      Lembar kerja dalam excel

    Correct Answer
    C. Pertemuan antara baris dengan kolom
    Explanation
    A cell in Excel refers to the intersection point between a row and a column. It is where data can be entered and stored. Each cell in Excel has a unique address, which is determined by its column letter and row number. Therefore, the correct answer is "Pertemuan antara baris dengan kolom" which means the intersection between rows and columns.

    Rate this question:

  • 44. 

    Fungsi utama program Microsoft Excel adalah …

    • A.

      Pengolah kata

    • B.

      Pengolah data angka

    • C.

      Mengelola dokumen

    • D.

      Berkomunikasi

    • E.

      Mencari informasi

    Correct Answer
    B. Pengolah data angka
    Explanation
    The main function of Microsoft Excel is to process and manipulate numerical data. It allows users to perform various calculations, create formulas, analyze data, and generate charts and graphs. Excel provides a range of tools and functions specifically designed for working with numbers, making it an essential program for tasks such as budgeting, financial analysis, and data organization.

    Rate this question:

  • 45. 

    Berikut merupakan tombol yang digunakan dalam memformat teks agar menjadi miring, yaitu ….

    • A.

      Ctrl+B

    • B.

      Ctrl+I

    • C.

      Ctrl+U

    • D.

      Ctrl+S

    • E.

      Ctrl+M

    Correct Answer
    B. Ctrl+I
    Explanation
    The correct answer is Ctrl+I. This keyboard shortcut is commonly used to format text in many applications, including word processors and text editors, to make it italicized. By selecting the text and pressing Ctrl+I, the text will be formatted in a slanted style, giving it emphasis or a different visual appearance.

    Rate this question:

  • 46. 

    Untuk menambah 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 allows the user to add additional rows to the Excel spreadsheet. By clicking on this command in the Insert menu, the user can easily insert new rows above the selected row or rows, providing more space for data entry or organization.

    Rate this question:

  • 47. 

    Salah satu cara menyimpan wordbook pada excel adalah dengan menggunakan ….

    • A.

      Ctrl+B

    • B.

      Ctrl+P

    • C.

      Ctrl+C

    • D.

      Ctrl+V

    • E.

      Ctrl+S

    Correct Answer
    E. Ctrl+S
    Explanation
    To save a wordbook in Excel, you can use the shortcut Ctrl+S. This shortcut is commonly used in many applications to save the current file or document. By pressing Ctrl+S, you can quickly save any changes made to the wordbook, ensuring that your work is saved and can be accessed later.

    Rate this question:

  • 48. 

    Berikut ini yang merupakan alamat sel dalam ms. excel, yaitu .…

    • A.

      84

    • B.

      3F

    • C.

      B5

    • D.

      BB

    • E.

      F0

    Correct Answer
    C. B5
    Explanation
    The given answer, B5, is a cell address in MS Excel. In Excel, cells are identified by a combination of a letter representing the column and a number representing the row. In this case, "B" represents the second column and "5" represents the fifth row. So, B5 refers to the cell located in the second column and fifth row in the Excel spreadsheet.

    Rate this question:

  • 49. 

    Menu yang digunakan untuk melihat tampilan sebelum di print adalah ...

    • A.

      Print preview

    • B.

      Printer

    • C.

      Print

    • D.

      Copy

    • E.

      Paste

    Correct Answer
    A. Print preview
    Explanation
    The correct answer is "print preview" because it is the menu option that allows users to see how a document will appear when printed. This feature is useful for checking the layout, formatting, and content of a document before actually printing it.

    Rate this question:

  • 50. 

    Yang digunakan untuk mengurutkan data dari Z-A adalah ...

    • A.

      Sort ascending

    • B.

      Sort descending

    • C.

      Copy

    • D.

      Paste

    • E.

      Paint

    Correct Answer
    B. Sort descending
    Explanation
    The correct answer is "sort descending". This option is used to arrange data in a reverse alphabetical or numerical order, from Z to A. It is the opposite of "sort ascending", which arranges data in an ascending order from A to Z or from the lowest to the highest value. The other options, such as "copy", "paste", and "paint", are unrelated to sorting data in a specific order.

    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 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 29, 2018
    Quiz Created by
    Muttaqin
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.