Modul 5 "Mengopersikan Perangkat Lunak Pengolah Angka"
- 1.
Yang manakah dibawah ini yang bukan merupakan perangkat lunak pengolah angka (lembar sebar)...
- A.
Lotus 123
- B.
Microsoft Excel
- C.
Open Office.org Calc
- D.
Microsoft Outlook
- E.
Benar Semua
Correct Answer
D. Microsoft OutlookExplanation
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:
-
- 2.
Tombol yang digunakan untuk mengabsolutkan kolom yaitu
- A.
F1
- B.
F2
- C.
F3
- D.
F4
- E.
F5
Correct Answer
D. F4Explanation
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:
-
- 3.
Cara Yang benar mengaktifkan program Ms. Excel adalah..
- A.
Klik Start – Program – Ms. Excel
- B.
Klik Start – Program – Ms. Word
- C.
Klik Start – Exit – Ms. Excel
- D.
Klik Ms. Excel
- E.
Klik Start – Ms. Excel
Correct Answer
A. Klik Start – Program – Ms. ExcelExplanation
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:
-
- 4.
Tombol yang digunakan untuk memperbaiki kesalah pada cell adalah..
- A.
F1
- B.
F2
- C.
F3
- D.
F4
- E.
F5
Correct Answer
B. F2Explanation
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:
-
- 5.
Klik Format à Column à Width digunakan untuk mengubah..
- A.
Huruf
- B.
Column
- C.
Baris
- D.
Warna
- E.
Bilangan
Correct Answer
B. ColumnExplanation
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:
-
- 6.
Jika kita ingin menampilkan atau menghilangkan kembali garis grid maka perintahnya adalah.....
- A.
Klik Tools - Options - Gridlines - Ok
- B.
Klik Options - Gridlines - Ok
- C.
Klik Format - Options - Gridlines - Ok
- D.
Klik Gridlines - Ok
- E.
Klik Format - Garis - Ok
Correct Answer
A. Klik Tools - Options - Gridlines - OkExplanation
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:
-
- 7.
Operasi hitung yang digunakan pada Ms. Excel kecuali..
- A.
+
- B.
-
- C.
*
- D.
^
- E.
%
Correct Answer
E. %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:
-
- 8.
Tombol yang digunakan untuk menghapus cell adalah
- A.
Delete
- B.
Backspace
- C.
Insert
- D.
Tab
- E.
Space
Correct Answer
A. DeleteExplanation
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:
-
- 9.
Jika pada sel A3 nilai 8 dan sel B3 nilai 9, kemudian dikalikan, maka penulisan rumus yang benar adalah.....
- A.
= 8 x 9
- B.
8 x 9
- C.
A3 * B3
- D.
= A3 x B3
- E.
= A3 * B3
Correct Answer
E. = A3 * B3Explanation
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:
-
- 10.
Di bawah ini merupakan pernyataan logika kecuali..
- A.
>
- B.
- C.
=
- D.
>=
- E.
+
Correct Answer
E. +Explanation
The given options consist of logical operators and symbols. The symbols "=", ">=", and "Rate this question:
-
- 11.
Perhatikan tabel diatas untuk mengisi kolom PERINGKAT menggunakan fungsi....
- A.
IF
- B.
OR
- C.
RANK
- D.
AVERAGE
- E.
HLOOKUP
Correct Answer
C. RANKExplanation
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:
-
- 12.
Rumus yang benar untuk mengisi keterangan adalah...
- A.
=IF(B6>=60, ”LULUS”,”GAGAL”)
- B.
=IF(B6>60,”LULUS” “GAGAL”)
- C.
=IF(B6
- D.
=IF(B6
- E.
=IF(B6
Correct Answer
E. =IF(B6Explanation
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:
-
- 13.
Operasi Pangkat pada Ms. Excel dilambangkan dengan ...
- A.
^
- B.
*
- C.
>
- D.
X
- E.
^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:
-
- 14.
Jumlah lembar kerja dalam buku kerja terdiri dari....
- A.
256 kolom dan 65536 baris
- B.
256 kolom dan 65789 baris
- C.
65536 kolom dan 256 baris
- D.
67890 baris dan 345 kolom
- E.
345 kolom dan 65545 baris
Correct Answer
A. 256 kolom dan 65536 barisExplanation
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:
-
- 15.
Memberi simbol Rp. Pada lembar kerja yang menyatakan nilai uang dengan memilih menu format - cell - number dari kotak dialog yang tampil memilih tab....
- A.
Number
- B.
Date
- C.
Accounting
- D.
Time
- E.
Percentange
Correct Answer
C. AccountingExplanation
The correct answer is "Accounting" because the question asks for the tab in the format cell number dialog box that allows the user to add the symbol Rp. to indicate the currency value. The "Accounting" tab in the format cell number dialog box provides options for formatting numbers as currency, including adding currency symbols.Rate this question:
-
- 16.
Untuk menghitung data dalam satu Range digunakan fungsi.....
- A.
COUNT
- B.
SUM
- C.
MAX
- D.
RAN
- E.
MIN
Correct Answer
A. COUNTExplanation
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:
-
- 17.
Perintah Format - Cell – Aligment digunakan untuk membuat......
- A.
Arsiran
- B.
Garis
- C.
Number
- D.
Huruf
- E.
Perataan
Correct Answer
E. PerataanExplanation
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:
-
- 18.
Tools yang digunakan Untuk mengabungkan beberapa sel menjadi satu sel ditunjukkan pada .....
- A.
A
- B.
B
- C.
C
- D.
D
- E.
E
Correct Answer
C. CExplanation
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:
-
- 19.
Untuk merubah ukuran kertas menjadi A4 menggunakan perintah...
- A.
Page Setup
- B.
Print Setup
- C.
Print Preview
- D.
Print Area
- E.
Clear Print Area
Correct Answer
A. Page SetupExplanation
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:
-
- 20.
Untuk menentukan hasil pencetakan dengan arah kertas tidur (horisontal) memilih...
- A.
Portraid
- B.
Vertical
- C.
Horizontal
- D.
Landscape
- E.
Properties
Correct Answer
D. LandscapeExplanation
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:
-
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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 03, 2010Quiz Created by
Karnazalt
Back to top