Modul 5 "Mengopersikan Perangkat Lunak Pengolah Angka"

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Karnazalt
K
Karnazalt
Community Contributor
Quizzes Created: 4 | Total Attempts: 2,754
| Attempts: 748
SettingsSettings
Please wait...
  • 1/20 Pertanyaan

    Memberi simbol Rp. Pada lembar kerja yang menyatakan nilai uang dengan memilih menu format - cell - number dari kotak dialog yang tampil memilih tab....

    • Number
    • Date
    • Accounting
    • Time
    • Percentange
Please wait...
Modul 5 "Mengopersikan Perangkat Lunak Pengolah Angka" - Quiz

Quiz Preview

  • 2. 

    Cara Yang benar mengaktifkan program Ms. Excel adalah..

    • Klik Start – Program – Ms. Excel

    • Klik Start – Program – Ms. Word

    • Klik Start – Exit – Ms. Excel

    • Klik Ms. Excel

    • Klik Start – Ms. Excel

    Correct Answer
    A. Klik Start – Program – Ms. Excel
    Explanation
    To activate the program Ms. Excel, the correct way is to click on the Start menu, then go to the Program folder, and select Ms. Excel from the list of available programs.

    Rate this question:

  • 3. 
    Tools yang digunakan Untuk mengabungkan beberapa sel menjadi satu sel ditunjukkan pada ..... - ProProfs

    Tools yang digunakan Untuk mengabungkan beberapa sel menjadi satu sel ditunjukkan pada .....

    • A

    • B

    • C

    • D

    • E

    Correct Answer
    A. C
    Explanation
    The correct answer is "c" because the question is asking for the tools used to combine multiple cells into one cell. The options provided are a, b, c, d, and e. Since option c is the only one mentioned in the question, it is the correct answer.

    Rate this question:

  • 4. 

    Untuk merubah ukuran kertas menjadi A4 menggunakan perintah...

    • Page Setup

    • Print Setup

    • Print Preview

    • Print Area

    • Clear Print Area

    Correct Answer
    A. Page Setup
    Explanation
    To change the paper size to A4, the correct command to use is "Page Setup". This command allows you to adjust various settings related to the page layout, including the paper size, margins, and orientation. By selecting "Page Setup", you can specify that you want to use A4 as the paper size for your document.

    Rate this question:

  • 5. 

    Tombol yang digunakan untuk mengabsolutkan kolom yaitu

    • F1

    • F2

    • F3

    • F4

    • F5

    Correct Answer
    A. F4
    Explanation
    The correct answer is F4. F4 is the function key that is used to lock or freeze a column in a spreadsheet. This feature is commonly used in spreadsheet programs like Microsoft Excel to keep a specific column visible while scrolling through the rest of the data. By pressing F4, users can easily freeze a column and keep it in view, making it easier to compare data or reference information in the spreadsheet.

    Rate this question:

  • 6. 

    Tombol yang digunakan untuk menghapus cell adalah

    • Delete

    • Backspace

    • Insert

    • Tab

    • Space

    Correct Answer
    A. Delete
    Explanation
    The correct answer is "Delete". This button is used to remove or delete a selected cell or content in a document or spreadsheet. It is commonly found on keyboards and can be used to delete text, images, or any other element within a file.

    Rate this question:

  • 7. 

    Jika pada sel A3 nilai 8 dan sel B3 nilai 9, kemudian dikalikan, maka penulisan rumus yang benar adalah.....

    • = 8 x 9

    • 8 x 9

    • A3 * B3

    • = A3 x B3

    • = A3 * B3

    Correct Answer
    A. = A3 * B3
    Explanation
    The correct answer is "= A3 * B3" because the question states that the value in cell A3 is 8 and the value in cell B3 is 9, and the operation to be performed is multiplication. In Excel, the formula for multiplication is using the asterisk symbol (*), so the correct formula to calculate the multiplication of the values in A3 and B3 is "= A3 * B3".

    Rate this question:

  • 8. 

    Klik Format à Column à Width digunakan untuk mengubah..

    • Huruf

    • Column

    • Baris

    • Warna

    • Bilangan

    Correct Answer
    A. Column
    Explanation
    The correct answer is "Column". The Format à Column à Width option is used to change the width of columns in a document or spreadsheet. This option allows the user to adjust the size of columns to better fit the content or to create a more organized layout. By changing the width of columns, the user can ensure that the text or data is displayed in a visually appealing and easily readable manner.

    Rate this question:

  • 9. 

    Operasi Pangkat pada Ms. Excel dilambangkan dengan ...

    • ^

    • *

    • >

    • X

    • ^z

    Correct Answer
    A. ^
    Explanation
    The symbol "^" is used to represent the power or exponentiation operation in Ms. Excel. This means that if you want to raise a number to a certain power, you can use the "^" symbol. For example, if you want to calculate 2 raised to the power of 3, you would write it as "2^3" in Excel.

    Rate this question:

  • 10. 

    Untuk menentukan hasil pencetakan dengan arah kertas tidur (horisontal) memilih...

    • Portraid

    • Vertical

    • Horizontal

    • Landscape

    • Properties

    Correct Answer
    A. Landscape
    Explanation
    The correct answer is "Landscape" because when printing with the paper orientation set to horizontal, the image or document will be printed in landscape mode. This means that the width of the paper will be greater than its height, allowing for a wider view of the content.

    Rate this question:

  • 11. 

    Jumlah lembar kerja dalam buku kerja terdiri dari....

    • 256 kolom dan 65536 baris

    • 256 kolom dan 65789 baris

    • 65536 kolom dan 256 baris

    • 67890 baris dan 345 kolom

    • 345 kolom dan 65545 baris

    Correct Answer
    A. 256 kolom dan 65536 baris
    Explanation
    The correct answer is 256 kolom dan 65536 baris. This is because the question is asking for the number of columns and rows in the workbook, and this option states that there are 256 columns and 65536 rows.

    Rate this question:

  • 12. 

    Tombol yang digunakan untuk memperbaiki kesalah pada cell adalah..

    • F1

    • F2

    • F3

    • F4

    • F5

    Correct Answer
    A. F2
    Explanation
    The correct answer is F2. F2 is the function key that is used to edit the contents of a cell in Microsoft Excel. When a cell is selected, pressing F2 allows the user to enter the edit mode and make changes to the cell's content. This key is commonly used for correcting errors or updating data in a spreadsheet.

    Rate this question:

  • 13. 
    Perhatikan tabel diatas untuk mengisi kolom PERINGKAT menggunakan fungsi.... - ProProfs

    Perhatikan tabel diatas untuk mengisi kolom PERINGKAT menggunakan fungsi....

    • IF

    • OR

    • RANK

    • AVERAGE

    • HLOOKUP

    Correct Answer
    A. RANK
    Explanation
    The correct answer is RANK because it is the function that can be used to fill the "PERINGKAT" column in the table. The RANK function calculates the rank of a number in a list of numbers, based on its value. It can be used to determine the position of each value in the "PERINGKAT" column based on their values in the table.

    Rate this question:

  • 14. 

    Untuk menghitung data dalam satu Range digunakan fungsi.....

    • COUNT

    • SUM

    • MAX

    • RAN

    • MIN

    Correct Answer
    A. COUNT
    Explanation
    The correct answer is COUNT. COUNT function is used to calculate the number of cells in a range that contains numbers or dates. It does not include empty cells or cells that contain text or logical values.

    Rate this question:

  • 15. 

    Yang manakah dibawah ini yang bukan merupakan perangkat lunak pengolah angka (lembar sebar)...

    • Lotus 123

    • Microsoft Excel

    • Open Office.org Calc

    • Microsoft Outlook

    • Benar Semua

    Correct Answer
    A. Microsoft Outlook
    Explanation
    Microsoft Outlook is not a spreadsheet software, but rather an email and personal information management program. Lotus 123, Microsoft Excel, and Open Office.org Calc are all examples of spreadsheet software used for processing numbers and data. Therefore, the correct answer is Microsoft Outlook.

    Rate this question:

  • 16. 

    Perintah Format - Cell – Aligment digunakan untuk membuat......

    • Arsiran

    • Garis

    • Number

    • Huruf

    • Perataan

    Correct Answer
    A. Perataan
    Explanation
    The correct answer is "Perataan" because the command "Format - Cell - Alignment" is used to adjust the alignment of the content within a cell in a spreadsheet or document. This command allows users to align the text or numbers in a cell to the left, right, or center, as well as vertically align the content to the top, bottom, or middle of the cell. It helps in making the data more organized and visually appealing.

    Rate this question:

  • 17. 

    Jika kita ingin menampilkan atau menghilangkan kembali garis grid maka perintahnya adalah.....

    • Klik Tools - Options - Gridlines - Ok

    • Klik Options - Gridlines - Ok

    • Klik Format - Options - Gridlines - Ok

    • Klik Gridlines - Ok

    • Klik Format - Garis - Ok

    Correct Answer
    A. Klik Tools - Options - Gridlines - Ok
    Explanation
    The correct answer is "Klik Tools - Options - Gridlines - Ok". This is because the question is asking for the correct command to display or hide gridlines. The option "Tools - Options" is commonly used in software applications to access settings and preferences. By selecting "Gridlines" within the "Options" menu and clicking "Ok", the user can toggle the display of gridlines on or off.

    Rate this question:

  • 18. 

    Di bawah ini merupakan pernyataan logika kecuali..

    • >

    • =

    • >=

    • +

    Correct Answer
    A. +
    Explanation
    The given options consist of logical operators and symbols. The symbols "=", ">=", and "

    Rate this question:

  • 19. 

    Operasi hitung yang digunakan pada Ms. Excel kecuali..

    • +

    • -

    • *

    • ^

    • %

    Correct Answer
    A. %
    Explanation
    The given answer is % because it is not a mathematical operation used in Ms. Excel. The operations listed in the question, such as +, -, *, ^, and %, are all commonly used in Excel for addition, subtraction, multiplication, exponentiation, and percentage calculations. However, the % symbol is not used as an operation in Excel. Instead, it is used to represent percentages or to calculate percentages using formulas.

    Rate this question:

  • 20. 
    Rumus yang benar untuk mengisi keterangan adalah... - ProProfs

    Rumus yang benar untuk mengisi keterangan adalah...

    • =IF(B6>=60, ”LULUS”,”GAGAL”)

    • =IF(B6>60,”LULUS” “GAGAL”)

    • =IF(B6

    • =IF(B6

    • =IF(B6

    Correct Answer
    A. =IF(B6
    Explanation
    The correct answer is =IF(B6>=60, "LULUS","GAGAL"). This formula checks if the value in cell B6 is greater than or equal to 60. If it is, it returns "LULUS", indicating that the condition for passing is met. If it is not, it returns "GAGAL", indicating that the condition for failing is met.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 03, 2010
    Quiz Created by
    Karnazalt
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.