Soal Tik Kelas Xi
- 1.
Di bawah ini yang termasuk program pengolah angka, kecuali ... .
- A.
Quatto
- B.
Lotus
- C.
Microsoft Word
- D.
Microsoft Excel
Correct Answer
D. Microsoft ExcelExplanation
The given options Quatto, Lotus, Microsoft Word, and Microsoft Excel are all software programs. However, Microsoft Excel is specifically known as a spreadsheet program used for numerical data processing and analysis, making it the odd one out in this list.Rate this question:
-
- 2.
Tanda pangkat dalam operator aritmatika adalah… .
- A.
+
- B.
*
- C.
-
- D.
^
Correct Answer
D. ^Explanation
The tanda pangkat dalam operator aritmatika refers to the exponentiation operator, which is represented by the caret symbol (^). This operator is used to raise a number to a power or to perform exponentiation calculations. It indicates that the number preceding it should be raised to the power of the number following it.Rate this question:
-
- 3.
Tanda bagi dalam operator aritmatika adalah ….
- A.
^
- B.
*
- C.
/
- D.
+
Correct Answer
C. /Explanation
The division symbol (/) is used in arithmetic operations to represent the mathematical operation of division. It is used to divide one number by another and find the quotient or the result of the division.Rate this question:
-
- 4.
Dalam fungsi matematika untuk menjumlahkan range dengan ….
- A.
Subtotal
- B.
Sumif
- C.
Product
- D.
Sum
Correct Answer
D. SumExplanation
The correct answer is "sum." In mathematics, the term "sum" refers to the total obtained by adding numbers together. In this context, the function is used to calculate the sum of a range of numbers. Therefore, "sum" is the appropriate choice for this question.Rate this question:
-
- 5.
Untuk merubah format angka sesuai dengan aslinya menggunakan … .
- A.
Number
- B.
Accounting
- C.
General
- D.
Date
Correct Answer
A. NumberExplanation
To change the format of a number to its original form, the appropriate option to use would be "number". This option would ensure that the number is displayed without any specific formatting or adjustments, allowing it to be presented in its original form.Rate this question:
-
- 6.
Dalam fungsi matematika menjumlahkan range dengan kriteria tertentu dengan … .
- A.
Sum
- B.
Sumproduct
- C.
Product
- D.
Sumif
Correct Answer
D. SumifExplanation
The correct answer is "sumif." In mathematics, the "sumif" function is used to add up a range of numbers based on specific criteria. It allows you to specify a condition or criteria that determines which values should be included in the sum. The function calculates the sum of only those numbers that meet the specified criteria, ignoring the rest.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.
Menutup jendela untuk sementara
- D.
Mengubah jendela ke ukuran semula
Correct Answer
A. Menutup jendela dan keluar dari Ms ExcelExplanation
The correct answer is "menutup jendela dan keluar dari Ms Excel." The "X" button in the Microsoft Excel window is used to close the window and exit the program.Rate this question:
-
- 8.
Perintah di bawah ini yang berfungsi untuk memblok 1 cell ke bawah adalah … .
- A.
Alt + ↓
- B.
Ctrl + ↓
- C.
Shift + ↓
- D.
Tab + ↓
Correct Answer
C. Shift + ↓Explanation
The correct answer is shift + ↓. This keyboard shortcut is commonly used in spreadsheet programs like Microsoft Excel to select the cell below the current active cell. By holding down the shift key and pressing the down arrow key, the user can quickly move the selection down one cell at a time. This is useful for navigating through large sets of data or for selecting multiple cells in a column.Rate this question:
-
- 9.
Tombol Ctrl + C sama artinya dengan …
- A.
Mengklik menu edit kemudian cut
- B.
Mengklik menu edit kemudian select all
- C.
Mengklik menu edit kemudian paste
- D.
Mengklik menu edit kemudian copy
Correct Answer
D. Mengklik menu edit kemudian copyExplanation
The correct answer is "mengklik menu edit kemudian copy". This is because the question is asking for the equivalent action to pressing the Ctrl + C keyboard shortcut. The Ctrl + C shortcut is commonly used to copy selected text or items, and the action of clicking on the "edit" menu and then selecting "copy" performs the same function.Rate this question:
-
- 10.
Fungsi di bawah ini yang berfungsi untuk mencari nilai terendah dari suatu range adalah…
- A.
Sum
- B.
Min
- C.
Max
- D.
Average
Correct Answer
B. MinExplanation
The function "min" is used to find the lowest value within a given range. It compares all the values in the range and returns the smallest one.Rate this question:
-
- 11.
Jika anda menuliskan rumus ini = 8 +3 *3, maka hasilnya adalah ….
- A.
20
- B.
17
- C.
9
- D.
1
Correct Answer
B. 17Explanation
The given expression "8 + 3 * 3" follows the order of operations in mathematics, which states that multiplication should be performed before addition. Therefore, we first multiply 3 by 3, resulting in 9. Then, we add 8 to 9, which gives us the final answer 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
Correct Answer
B. 0Explanation
The given expression is 12-4*3. According to the order of operations in mathematics, multiplication should be performed before subtraction. So, first, we multiply 4 and 3 which gives us 12. Then, we subtract 12 from 12, which results in 0. Therefore, the correct answer is 0.Rate this question:
-
- 13.
Jika anda menuliskan rumus (60+80/2), maka hasilnya adalah …
- A.
70
- B.
100
- C.
1
- D.
140
Correct Answer
B. 100Explanation
The given question asks for the result of the formula (60+80/2). To solve this, we need to follow the order of operations, which states that we should perform the division before the addition. Therefore, we divide 80 by 2, which gives us 40. Then we add 60 to 40, resulting in 100. Hence, the correct answer is 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
Correct Answer
A. Data tabel, data base penghitungan rumus, dan grafikExplanation
The correct answer is "data tabel, data base penghitungan rumus, dan grafik". This answer correctly identifies the three main abilities of Ms. Excel in data processing: data tables, formula calculation databases, and charts/graphs.Rate this question:
-
- 15.
File/dokumen yang terdiri dari lembaran-lembaran disebut ... .
- A.
Sheetbook
- B.
Autobook
- C.
Iconbook
- D.
Workbook
Correct Answer
D. WorkbookExplanation
A file or document that consists of sheets or pages is called a workbook.Rate this question:
-
- 16.
Berisi berbagai menu untuk keperluan pengoperasian Ms. Excel adalah ... .
- A.
Title bar
- B.
Toolbar
- C.
Box bar
- D.
Menu bar
Correct Answer
D. Menu barExplanation
The menu bar is a section in Ms. Excel that contains various menus for performing different operations and tasks. It provides a list of options such as File, Edit, View, Insert, Format, Tools, Data, Window, and Help. Each menu further expands into submenus, allowing users to access specific functions and features of the software. The menu bar is essential for navigating and utilizing the different tools and functionalities available in Ms. Excel.Rate this question:
-
- 17.
Rumus untuk mencari rata-rata dengan menggunakan ... .
- A.
=sum(A1..A5)
- B.
=average(A1:A5)
- C.
=sum(A1-A5)
- D.
=average(A1-A5)
Correct Answer
D. =average(A1-A5)Explanation
The correct answer is "=average(A1-A5)" because the formula "average" is used to find the average of a range of cells, in this case, cells A1 to A5. The "-" symbol is used to represent a range of cells in Excel. Therefore, the formula "=average(A1-A5)" calculates the average of the values in cells A1 to A5.Rate this question:
-
- 18.
Tombol untuk mengembalikan besar layar full adalah ... .
- A.
Minimaze buttons
- B.
Out buttons
- C.
Maximize buttons
- D.
Buttons
Correct Answer
C. Maximize buttonsExplanation
The correct answer is "maximize buttons." This refers to the buttons on a screen that allow the user to expand the window to full size. These buttons typically include an icon of a square or two arrows pointing away from each other. By clicking on the maximize button, the user can enlarge the window to fill the entire screen, providing a better view of the content.Rate this question:
-
- 19.
Kotak yang berisi referensi sel yang sedang aktif adalah ... .
- A.
Box
- B.
Standar box
- C.
Name box
- D.
Bar box
Correct Answer
C. Name boxExplanation
The correct answer is "name box" because it is the box that contains references to active cells. The term "name box" refers to the box located on the left side of the formula bar in Microsoft Excel, where users can enter or select the name of a specific cell or range of cells. This box is used to quickly navigate to a specific cell or range and can also be used to define and manage named ranges in Excel.Rate this question:
-
- 20.
Memberi garis di sekeliling sel dengan style yang dipilih menggunakan ... .
- A.
Colour
- B.
Borders
- C.
Font
- D.
Bold erule
Correct Answer
B. BordersExplanation
The correct answer is "borders". This is because to give a border around a cell with a selected style, we need to use the "borders" option. This allows us to apply a border of a specific color, thickness, and style to the cell, creating a visual boundary around it.Rate this question:
-
- 21.
Worksheet pada Excel terdiri dari ... baris dan ... kolom. Isi dari titik-titik kalimat di atas adalah … .
- A.
256 dan 65536
- B.
1 dan 255
- C.
65536 dan 256
- D.
65536 dan 123
Correct Answer
C. 65536 dan 256Explanation
Worksheet pada Excel terdiri dari 65536 baris dan 256 kolom.Rate this question:
-
- 22.
Range adalah kumpulan dari ... .
- A.
Baris
- B.
Cell
- C.
Colom
- D.
Range
Correct Answer
B. CellExplanation
The correct answer is "cell" because a range is a collection or group of cells in a spreadsheet. It refers to a group of adjacent cells that can be selected, manipulated, and used together in various spreadsheet operations such as calculations, formatting, and data analysis. A range can be a single cell or a group of multiple cells, depending on the specific needs and requirements of the user.Rate this question:
-
- 23.
Mengatur tanda rupiah untuk data yang berupa uang dilakukan di kotak dialog....
- A.
Options
- B.
Print
- C.
Format cells
- D.
Page setup
Correct Answer
C. Format cellsExplanation
To set the currency format for data that represents money, you need to use the "format cells" option. This option allows you to customize the appearance of the data, including applying the currency symbol (in this case, the rupiah sign) to the values. The "print" option is used for printing documents, "page setup" is used to adjust the layout and settings for printing, and neither of these options specifically deal with formatting cells for currency.Rate this question:
-
- 24.
Sel yang ditunjuk oleh pointer disebut ... .
- A.
Sel relatif
- B.
Sel semi absolut
- C.
Sel absolute
- D.
Sel aktif
Correct Answer
D. Sel aktifExplanation
The correct answer is "sel aktif". This is because the term "sel aktif" refers to the cell that is pointed to by a pointer. In programming, a pointer is a variable that stores the memory address of another variable. By using a pointer, we can access and manipulate the value of the cell that it points to. Therefore, the cell that is being referred to by the pointer is called "sel aktif".Rate this question:
-
- 25.
Sel A1:B1 disebut ... .
- A.
Sel relatif
- B.
Sel semi absolut
- C.
Sel absolute
- D.
Sel aktif
Correct Answer
A. Sel relatifExplanation
The correct answer is "sel relatif" because Sel A1:B1 refers to a range of cells that are relative to the starting cell. This means that if the starting cell is moved or copied to a different location, the range will adjust accordingly.Rate this question:
-
- 26.
Contoh sel semi absolut adalah ... .
- A.
$A1
- B.
B5
- C.
$A$1
- D.
B5:D1
Correct Answer
A. $A1Explanation
The correct answer is $A1 because it represents a specific cell in the spreadsheet. The dollar sign ($) before the column letter and row number indicates that the reference is absolute, meaning it will not change when copied or filled to other cells. This is useful when you want to refer to a specific cell in formulas or calculations.Rate this question:
-
- 27.
$A$1 disebut sel ... .
- A.
Sel bebas
- B.
Sel semi absolut
- C.
Sel absolute
- D.
Sel aktif
Correct Answer
C. Sel absoluteExplanation
The correct answer is "sel absolute". This is because sel absolute refers to a cell that is completely fixed and does not change its position when copying or dragging the formula to other cells. It is denoted by using the dollar sign ($) before the column letter and row number of the cell reference. This allows the cell reference to remain constant and not adjust relative to the new location.Rate this question:
-
- 28.
Baris yang memuat rumus yang sedang aktif adalah ... .
- A.
Formula box
- B.
Formula bar
- C.
Formula cell
- D.
Formula chart
Correct Answer
B. Formula barExplanation
The correct answer is "formula bar." The formula bar is a section in a spreadsheet program where users can input and edit formulas. It is usually located at the top of the program window, just below the toolbar. The formula bar displays the contents of the currently selected cell, including any formulas that have been entered. Users can also directly enter or edit formulas in the formula bar, making it the most likely option for the bar that contains the active formula.Rate this question:
-
- 29.
Bagian yang berisi nama file dan nama program disebut ... .
- A.
Menu bar
- B.
Toolbars
- C.
Title bar
- D.
Sizing button
Correct Answer
C. Title barExplanation
The correct answer is "title bar". The title bar is the part of a window that displays the name of the file or program that is currently open. It is typically located at the top of the window and also includes the minimize, maximize, and close buttons. The title bar provides important information about the current file or program and allows users to easily identify and manage multiple open windows.Rate this question:
-
- 30.
Untuk menggeser layar ke atas/ke bawah menggunakan ... .
- A.
Formula bar
- B.
Horisontal scroll bar
- C.
Menu bar
- D.
Vertical scroll bar
Correct Answer
D. Vertical scroll barExplanation
The correct answer is the vertical scroll bar. This is because the vertical scroll bar is specifically designed to allow users to scroll up or down on a page or document. The other options mentioned, such as the formula bar, horizontal scroll bar, and menu bar, do not have the same functionality as the vertical scroll bar when it comes to moving the screen up or down.Rate this question:
-
- 31.
Tombol Esc digunakan untuk ... .
- A.
Menghapus karakter
- B.
Membatalkan perintah
- C.
Mengakhiri pemasukan
- D.
Memperbaiki data yang salah
Correct Answer
B. Membatalkan perintahExplanation
The correct answer is "membatalkan perintah". The Esc key on a keyboard is commonly used to cancel or abort a command or operation. It is often used in various software applications to interrupt or stop a process that is currently running. Pressing the Esc key can help in avoiding unintended actions or undoing a command that was initiated mistakenly.Rate this question:
-
- 32.
Orientatiton pada pengaturan kertas terdapat pada ... .
- A.
Page
- B.
Sheet
- C.
Margin
- D.
Header and Footer
Correct Answer
A. PageExplanation
The correct answer is "Page" because orientation refers to the way in which a document is displayed or printed, either in portrait (vertical) or landscape (horizontal) mode. The orientation setting can be found in the "Page" section of the document settings, where you can select the desired orientation for your paper.Rate this question:
-
- 33.
Fungsi yang digunakan untuk menghitung banyak data dalam range tertentu adalah:
- A.
Large
- B.
Count
- C.
Small
- D.
Rank
Correct Answer
B. CountExplanation
The correct answer is "Count." The Count function is used to calculate the number of data points within a specific range. It counts the number of cells that contain numbers and ignores empty cells, text, and logical values. This function is useful when you want to determine the total count of data within a given range.Rate this question:
-
- 34.
Jenis format angka untuk memasukkan lambang Rp. adalah ... .
- A.
General
- B.
Number
- C.
Accounting
- D.
Percentage
Correct Answer
C. AccountingExplanation
The correct answer is "Accounting" because when entering the symbol for the Indonesian currency, which is Rp., it is commonly done using the accounting format. This format is used to represent monetary values and includes the symbol for the currency before the number.Rate this question:
-
- 35.
Perintah untuk mengurangi jumlah digit desimal adalah ... .
- A.
Increase decimal
- B.
Increase indent
- C.
Decrease decimal
- D.
Decrease indent
Correct Answer
C. Decrease decimalExplanation
The correct answer is "Decrease decimal". This means reducing the number of decimal places in a number. It involves rounding or truncating the number to a smaller number of decimal places. For example, if a number has 3 decimal places and we decrease the decimal, it will have only 2 decimal places.Rate this question:
-
- 36.
Menu yang digunakan untuk mengatur halaman adalah ... .
- A.
File
- B.
Data
- C.
Edit
- D.
Insert
Correct Answer
A. FileExplanation
The correct answer is "File" because the menu option "File" is commonly used to access functions related to managing and organizing files, including opening, saving, and printing documents. It is a standard feature in most software applications and is often located at the top left corner of the program window.Rate this question:
-
- 37.
Sub menu yang digunakan untuk mengatur halaman adalah ... .
- A.
Page up
- B.
Page setup
- C.
Page down
- D.
Save
Correct Answer
B. Page setupExplanation
The correct answer is "Page setup" because it is the sub-menu that is commonly used to adjust and configure various settings related to the layout and formatting of a page. This sub-menu typically includes options such as adjusting margins, paper size, orientation, headers and footers, and other page-related settings.Rate this question:
-
- 38.
Untuk mengoreksi tulisan yang sudah diketik dan akan diperbaiki menggunakan tombol ... .
- A.
Esc (Escape)
- B.
Page up
- C.
Page down
- D.
F2
Correct Answer
D. F2Explanation
The correct answer is F2. F2 is commonly used as a shortcut key to edit the selected text or cell in many applications, including word processors and spreadsheet programs. Pressing F2 allows the user to enter into an editing mode, where they can make changes to the text or data. This key is often used to quickly correct typos or make adjustments to the content without having to use the mouse or navigate through menus.Rate this question:
-
- 39.
Left,Right,Bottom, dan Top terdapat pada ... .
- A.
Page
- B.
Sheet
- C.
Margin
- D.
Header and Footer
Correct Answer
C. MarginExplanation
The terms "Left, Right, Bottom, and Top" are commonly associated with the margins of a document or page layout. Margins refer to the blank spaces around the edges of a page where no text or images are placed. These margins help to create a visually balanced and organized layout, and they also provide space for binding or hole punching. Therefore, the correct answer is "Margin."Rate this question:
-
- 40.
Digunakan bersama tombol lain untuk perinah cepat adalah tombol ... .
- A.
Space bar
- B.
Ctrl
- C.
Alt
- D.
Enter
Correct Answer
B. CtrlExplanation
The space bar is not used in conjunction with other keys for quick commands. The Alt key is typically used to access menu options and shortcuts within a program. The Enter key is used to confirm a command or input. However, the Ctrl key is commonly used in combination with other keys to perform quick actions such as copying, pasting, and undoing. Therefore, the correct answer is Ctrl.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 -
May 24, 2011Quiz Created by
Zainullah