Excel Adalah
Quis ini digunakan untuk perbaikan nilai ( Remedial ) bagi siswa tingkat I atau kelas X SMK DRIEWANTI BEKASI
Questions and Answers
- 1.
Program ( Sistem Operasi ) yang dibutuhkan untuk mengoperasikan program Excel adalah ....
- A.
Windows
- B.
Disk Operating System
- C.
Power Point
- D.
Access
- E.
Linux
Correct Answer
A. WindowsExplanation
The correct answer is Windows because it is the operating system that is commonly used to operate programs like Excel. Windows provides a user-friendly interface and a wide range of features and tools that make it suitable for running various applications, including Microsoft Excel.Rate this question:
-
- 2.
Perintah untuk mengakhiri pemakaian program Excel adalah ..............
- A.
Restore
- B.
Close
- C.
Exit
- D.
Minimize
- E.
Start, Shutdown, Yes
Correct Answer
C. ExitExplanation
The correct answer is "Exit". This is because "Exit" is the command used to end or terminate the usage of a program, including Excel. It is commonly used to close the program and any associated files or processes. The other options provided, such as "Restore", "Close", "Minimize", and "Start, Shutdown, Yes" are not specific commands to end the program, but rather actions related to manipulating the program window or system shutdown.Rate this question:
-
- 3.
Perkalian, pembagian, pengurangan, pemangkatan termasuk fungsi ...............
- A.
Matematika
- B.
Statistika
- C.
Finansial
- D.
String
- E.
Pembacaan tabel data
Correct Answer
A. MatematikaExplanation
The given question is asking for the category or type of functions that include multiplication, division, subtraction, and exponentiation. The correct answer is "Matematika" because these operations are fundamental mathematical functions that are commonly used in arithmetic and algebraic calculations.Rate this question:
-
- 4.
Perintah untuk menyembunyikan / menampilkan kembali garis bantu ( tanda pembatas kolom dan baris ) pada layar adalah .........
- A.
Format, Cells, Protection, Ok
- B.
Tools, Options, Gridlines, Ok
- C.
Format, Cells, Borders,Ok
- D.
Format, Cells, Font, Ok
- E.
Format, Cells, Patterns, Ok
Correct Answer
B. Tools, Options, Gridlines, OkExplanation
The correct answer is "Tools, Options, Gridlines, Ok". This option suggests that in order to hide or display gridlines (column and row boundaries) on the screen, the user needs to go to the "Tools" menu, then select "Options", and finally choose "Gridlines". By clicking "Ok", the changes will be applied.Rate this question:
-
- 5.
JIka sel A1 berisi angka 10 dan sel B1 angka 5 kemudian pada sel C1 dimasukkan formula perkalian data tersebut maka penulisan yang benar adalah ........
- A.
10 x 5
- B.
A1 * B1
- C.
= 10 x 5
- D.
= 10 * 5
- E.
= A1 * B1
Correct Answer
E. = A1 * B1Explanation
The correct answer is "= A1 * B1" because the formula for multiplying the data in cells A1 and B1 is represented by the asterisk (*) symbol in Excel. The equal sign (=) at the beginning of the formula is used to indicate that it is a formula and not a regular text. Therefore, "= A1 * B1" is the correct way to write the formula for multiplying the values in cells A1 and B1.Rate this question:
-
- 6.
Penulisan logika yang benar adalah .........
- A.
=IF(A3>,5,A1=200)
- B.
=IF(A1>5,"Sarjana","DO")
- C.
=A1>5,"Sarjana","DO")
- D.
=IF(A1>5,A1*B1,A1..B1)
- E.
IF(A1>5,A1*B1,A1..B1)
Correct Answer
B. =IF(A1>5,"Sarjana","DO")Explanation
The correct answer is =IF(A1>5,"Sarjana","DO"). This formula is written in the correct syntax for an IF statement in Excel. It checks if the value in cell A1 is greater than 5, and if it is, it returns the text "Sarjana". If the value is not greater than 5, it returns the text "DO".Rate this question:
-
- 7.
Ikon yang digunakan untuk pembuatan grafik adalah ........
- A.
Open
- B.
Toolbar Standard
- C.
Charter
- D.
Cut
- E.
Chart Wizard
Correct Answer
E. Chart WizardExplanation
The correct answer is "Chart Wizard" because the Chart Wizard is a tool used for creating graphs and charts. It provides a step-by-step guide to help users select the data they want to visualize and choose the appropriate chart type. The Chart Wizard is commonly found in spreadsheet software such as Microsoft Excel and Google Sheets, and it helps users create visually appealing and informative charts for data analysis and presentation purposes.Rate this question:
-
- 8.
Garis-garis yang terdapat didalam area grafik bernama ..........
- A.
Category ( X ) axis
- B.
Value ( Y ) axis
- C.
Gridlines
- D.
Legend
- E.
Data Label
Correct Answer
C. GridlinesExplanation
Gridlines are the lines that appear on a graph, which help in reading and interpreting the values accurately. They are used to visually represent the scale and divisions on both the X and Y axes, making it easier to understand the data plotted on the graph.Rate this question:
-
- 9.
Sewaktu akan mengurutkan data, " Header row " dipilih apabila ........
- A.
Baris paling atas dalam range merupakan judul pengurutan.
- B.
Data yang diurutkan merupakan data angka.
- C.
Range yang dipilih merupakan sebagian data yang diurutkan.
- D.
Data yang paling kiri merupakan judul kolom yang akan diurutkan.
- E.
Data yang akan dirutkan tidak perlu di range.
Correct Answer
A. Baris paling atas dalam range merupakan judul pengurutan.Explanation
The "Header row" is selected when sorting data because it represents the title of the sorting. This means that the first row in the range is considered as the header row and contains the titles or labels for the data being sorted. By selecting the header row, the sorting algorithm understands that it should not include this row in the sorting process and only sort the actual data rows.Rate this question:
-
- 10.
Untuk menampilkan seluruh data pada Autofilter digunakan pilihan .....
- A.
Show All
- B.
General
- C.
Total Show
- D.
All Filter
- E.
Automatic
Correct Answer
A. Show AllExplanation
The correct answer is "Show All". This option is used to display all the data in the Autofilter. It allows the user to view the entire dataset without any filtering applied.Rate this question:
-
- 11.
Simbol disamping merupakan simbol dari perangkat lunak lembar sebar ......
- A.
Microsoft Excel
- B.
Open Office Calc
- C.
Open Office Lembar Sebar
- D.
Microsoft Access
- E.
Microsoft Word
Correct Answer
A. Microsoft ExcelExplanation
The correct answer is Microsoft Excel. The symbol next to the question is the symbol for Microsoft Excel, which is a spreadsheet software commonly used for data analysis and calculations. It is part of the Microsoft Office suite and is widely used in various industries for tasks such as budgeting, financial analysis, and data management.Rate this question:
-
- 12.
Menjalankan perangkat lunak lembar sebar di sistem operasi windows dengan cara mengklik Start pilih program kemudian pilih .......
- A.
Microsoft Excel
- B.
Open Office Calc
- C.
Open Office Lembar Sebar
- D.
Microsoft Access
- E.
Microsoft Word
Correct Answer
A. Microsoft ExcelExplanation
To run spreadsheet software on a Windows operating system, you would typically click on the Start button, then select a program. In this case, the correct answer is Microsoft Excel.Rate this question:
-
- 13.
Menjalankan perangkat lunak lembar sebar di sistem operasi Linux dengan cara mengklik Main menu pilih Open Office. org kemudian pilih ..........
- A.
Microsoft Excel
- B.
Open Oficce Calc
- C.
Open Office Lembar sebar
- D.
Microsoft Access
- E.
Microsoft Word
Correct Answer
B. Open Oficce CalcExplanation
To run spreadsheet software on the Linux operating system, you would typically click on the Main menu and select Open Office.org. From there, you would choose Open Office Calc, which is the correct answer. Microsoft Excel, Microsoft Access, and Microsoft Word are not applicable options as they are software programs designed for the Microsoft Windows operating system.Rate this question:
-
- 14.
Cara membuat lembar kerja baru dengan cepat menggunakan..........
- A.
Ctrl + N
- B.
Ctrl + S
- C.
Ctrl + O
- D.
Ctrl + P
- E.
Ctrl + V
Correct Answer
A. Ctrl + NExplanation
To quickly create a new worksheet, you can use the shortcut Ctrl + N. This combination of keys opens a new blank document or worksheet in various software applications, including Microsoft Excel, Word, and PowerPoint. It is a commonly used shortcut that allows users to save time and start working on a new project without having to go through the menu options to create a new document.Rate this question:
-
- 15.
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 + 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 answer states that the number of columns in the workbook is 256, and the number of rows is 65536.Rate this question:
-
- 16.
Untuk menutup lembar sebar digunakan perintah ........
- A.
File - Exit
- B.
File - Close
- C.
File - Print
- D.
File - Open
- E.
File - New
Correct Answer
B. File - CloseExplanation
The correct answer is "File - Close" because to close a spreadsheet, we use the "Close" command under the "File" menu. This command allows us to close the current spreadsheet without exiting the entire application.Rate this question:
-
- 17.
Gambar diatas dalam lembar sebar disebut ........
- A.
Menu Bar
- B.
Title Bar
- C.
Toolbar
- D.
Cell Pointer
- E.
Scroll Bar
Correct Answer
A. Menu BarExplanation
The correct answer is Menu Bar. The given image is referring to the bar at the top of the screen that contains various menus, such as File, Edit, View, etc. This bar is commonly known as the Menu Bar, and it provides access to different functions and options within a software or application.Rate this question:
-
- 18.
Simbol disamping disebut dengan ............
- A.
Tombol Maximize
- B.
Tombol Minimize
- C.
Tombol Restore
- D.
Tombol Close
- E.
Tombol Close Windows
Correct Answer
B. Tombol MinimizeExplanation
The symbol mentioned next to it is called the "Tombol Minimize."Rate this question:
-
- 19.
Dengan meng-klik menu Format - Row - Height digunakan untuk ..........
- A.
Meninggikan baris
- B.
Melebarkan baris
- C.
Meninggikan kolom
- D.
Melebarkan kolom
- E.
Tidak ada pengaruh
Correct Answer
A. Meninggikan barisExplanation
By clicking on the Format - Row - Height menu, you can increase the height of the rows in a document or spreadsheet. This option allows you to adjust the vertical size of the rows, making them taller.Rate this question:
-
- 20.
Memberi simbol Rp. Pada lembar kerja yang menyatakan nilai uang dengan memilih Format - Cell - Number dari kotak dialog yang tampil memilih tab .........
- A.
Percentage
- B.
Time
- C.
Date
- D.
Number
- E.
Accounting
Correct Answer
E. AccountingExplanation
The correct answer is Accounting. When selecting the "Format - Cell - Number" option in the dialog box, choosing the Accounting tab allows you to add the symbol Rp. to the worksheet, indicating the value as currency in Indonesian Rupiah.Rate this question:
-
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Back to top