# Latihan Soal Pengolah Angka

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.
| By Sigm
S
Sigm
Community Contributor
Quizzes Created: 2 | Total Attempts: 2,846
Questions: 20 | Attempts: 1,631

Settings

Ditujukan khusus untuk anak-anak smpn 2 padalarang

• 1.

### Di bawah ini yang termasuk program pengolah angka, kecuali …

• A.

Quatto Pro

• B.

Lotus 123

• C.

Microsoft Word

• D.

Microsoft Excel

C. Microsoft Word
Explanation
The given options are Quattro Pro, Lotus 123, Microsoft Word, and Microsoft Excel. The question asks for the program that is not a number processor. Quattro Pro and Lotus 123 are both spreadsheet programs used for number processing and data analysis. Microsoft Excel is also a spreadsheet program, specifically designed for number processing. However, Microsoft Word is a word processing program used for creating and editing documents, and it is not primarily used for number processing. Therefore, Microsoft Word is the correct answer.

Rate this question:

• 2.

### Tanda pangkat dalam operator aritmatika adalah…

• A.

+

• B.

*

• C.

â€“

• D.

^

D. ^
Explanation
The caret symbol (^) represents the exponentiation operation in arithmetic. It is used to raise a number to a certain power. For example, 2^3 means 2 raised to the power of 3, which is equal to 8. Therefore, the correct answer is ^.

Rate this question:

• 3.

### Tanda bagi dalam operator aritmatika adalah ….

• A.

/

• B.

^

• C.

%

• D.

*

A. /
Explanation
The correct answer is "/". The division operator ("/") is used in arithmetic operations to divide one number by another.

Rate this question:

• 4.

### Dalam fungsi matematika untuk menjumlahkan range dengan ….

• A.

Subtotal

• B.

Sumif

• C.

Product

• D.

Sum

D. Sum
Explanation
The correct answer is "sum." In mathematics, the term "sum" refers to the action of adding together a range of numbers or values. In this context, the function is used to calculate the total sum of the range. Therefore, "sum" is the appropriate choice for this question.

Rate this question:

• 5.

### Untuk merubah format angka sesuai dengan aslinya menggunakan …

• A.

Number

• B.

General

• C.

Accounting

• D.

Date

B. General
Explanation
The correct answer is "general". This is because the "general" format is used to display numbers in their original format, without any specific formatting rules applied. This format is commonly used when you want to display numbers as they are, without any additional styling or formatting.

Rate this question:

• 6.

### Dalam fungsi matematika menjumlahkan range dengan kriteria tertentu dengan …

• A.

Sum

• B.

Product

• C.

Sumproduct

• D.

Sumif

D. Sumif
Explanation
The correct answer is "sumif". The question is asking for the function used in mathematics to sum a range with specific criteria. The "sumif" function in mathematics allows you to specify a range and a criteria, and it will sum only the values that meet that criteria.

Rate this question:

• 7.

### Tombol (X) yang terdapat pada jendela Microsoft Excel, berfungsi untuk …

• A.

Menutup jendela dan keluar dari Ms Excel

• B.

Mengubah jendela penuh layar

• C.

• D.

Mengubah jendela ke ukuran semula

A. Menutup jendela dan keluar dari Ms Excel
Explanation
The correct answer is "menutup jendela dan keluar dari Ms Excel." This is because the "X" button in Microsoft Excel is commonly used to close the window and exit the program. By clicking on this button, the user can effectively close the Excel window and end their session in the program.

Rate this question:

• 8.

### Perintah di bawah ini yang berfungsi untuk memblok 1 cell ke bawah adalah …

• A.

Alt + â†“

• B.

Shift + â†“

• C.

Ctrl + â†“

• D.

Tab + â†“

B. Shift + â†“
Explanation
The correct answer is "shift + â†“". This keyboard shortcut is commonly used in spreadsheet programs like Microsoft Excel to select and move the cursor one cell down. By holding down the shift key and pressing the downward arrow key, the user can select a range of cells from the current cell to the cell below it. This shortcut is useful for quickly navigating and selecting data in a spreadsheet.

Rate this question:

• 9.

### Tombol Ctrl + C sama artinya dengan …

• A.

• B.

Mengklik menu edit kemudian select all

• C.

• D.

D. Mengklik menu edit kemudian copy
Explanation
Pressing the Ctrl + C shortcut key combination is equivalent to clicking on the "Edit" menu and then selecting the "Copy" option.

Rate this question:

• 10.

### Fungsi di bawah ini yang berfungsi untuk mencari nilai terendah dari suatu range adalah…

• A.

Sum

• B.

Max

• C.

Min

• D.

Average

C. Min
Explanation
The correct answer is "min" because the "min" function is used to find the lowest value within a given range. It compares all the values in the range and returns the smallest value among them.

Rate this question:

• 11.

### Jika anda menuliskan rumus ini = 8 + 3*3, maka ...

• A.

20

• B.

17

• C.

9

• D.

1

B. 17
Explanation
The correct answer is 17. This can be determined by following the order of operations in mathematics, which states that multiplication should be done before addition. In the given equation, 3*3 is equal to 9. Adding 8 to 9 gives a final result of 17.

Rate this question:

• 12.

### Jika anda menuliskan rumus ini = 12-4*3 maka hasilnya adalah …

• A.

24

• B.

0

• C.

13

• D.

1

B. 0
Explanation
The given expression is 12-4*3. According to the order of operations (PEMDAS/BODMAS), multiplication should be done before subtraction. So, 4*3 equals 12. Therefore, the expression simplifies to 12-12, which equals 0.

Rate this question:

• 13.

• A.

70

• B.

100

• C.

1

• D.

140

B. 100
Explanation
If you write the formula (60+80/2), the result is 100. This is because the formula follows the order of operations, which states that you should perform the division before the addition. Therefore, 80 divided by 2 equals 40, and when you add 60 to 40, you get 100.

Rate this question:

• 14.

### Ada tiga macam kemampuan Ms. excel dalam pengolahan data, yaitu ...

• A.

Data tabel, data base penghitungan rumus, dan grafik

• B.

Data manajemen, data paragraf, dan grafik

• C.

Data program, data sel aktif, dan grafik

• D.

Data processor, data program, dan grafik

A. Data tabel, data base penghitungan rumus, dan grafik
Explanation
The correct answer is "data tabel, data base penghitungan rumus, dan grafik". This is because Excel is commonly used for organizing and analyzing data in tabular form, performing calculations using formulas and functions, and creating visual representations of data through charts and graphs.

Rate this question:

• 15.

### File/dokumen yang terdiri dari lembaran-lembaran disebut …

• A.

Sheetbook

• B.

Iconbook

• C.

Autobook

• D.

Workbook

D. Workbook
Explanation
A file or document that consists of sheets or pages is called a workbook. This term is commonly used in computer applications such as Microsoft Excel, where a workbook refers to a collection of worksheets or spreadsheets. It is used to organize and store data in a structured manner, allowing users to perform calculations, analyze data, and create reports.

Rate this question:

• 16.

### Ms. Excel merupakan perang lunak pengolah data

• A.

True

• B.

False

B. False
Explanation
Ms. Excel is not a software for data processing. It is actually a software for spreadsheet creation and analysis. It is commonly used for tasks such as creating tables, charts, and formulas for data analysis and presentation. Therefore, the correct answer is False.

Rate this question:

• 17.

### Fungsi sum adalah untuk menjumlahkan

• A.

True

• B.

False

A. True
Explanation
The given correct answer is true. The explanation for this is that the function "sum" is indeed used to add or sum up a series of numbers or elements. It is a built-in function in many programming languages that takes an iterable (such as a list or tuple) as input and returns the sum of all the elements in that iterable. Therefore, the statement "Fungsi sum adalah untuk menjumlahkan" translates to "The sum function is used for adding up."

Rate this question:

• 18.

### Fungsi max adalah untuk mencari nilai terkecil dalam suatu range

• A.

True

• B.

False

B. False
Explanation
The given statement is incorrect. The correct explanation is that the function max is used to find the largest value within a range, not the smallest value. Therefore, the answer is False.

Rate this question:

• 19.

### Worksheet pada Excel terdiri dari 65536 baris dan 256 kolom

• A.

True

• B.

False

A. True
Explanation
The statement is true because a worksheet in Excel consists of 65,536 rows and 256 columns. This means that you can input data, perform calculations, and organize information in a table-like format with this number of rows and columns.

Rate this question:

• 20.

### Range adalah kumpulan dari Kolom .

• A.

True

• B.

False

B. False
Explanation
The given statement is false. "Range" is not a collection of columns. It is a collection of values that meet certain criteria or conditions. In Excel, for example, the range refers to a group of cells, not columns. Therefore, the statement is incorrect.

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
• May 14, 2013
Quiz Created by
Sigm