Ulangan Harian-1 Tik Kls 8 Semester 2 Quiz

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 Roedy
R
Roedy
Community Contributor
Quizzes Created: 3 | Total Attempts: 46,237
| Attempts: 2,715 | Soalan: 20
Please wait...

Question 1 / 20
0 %
0/100
Score 0/100
1. Pada Microsoft Excel, tanda operator untuk perhitungan perkalian adalah ....

Explanation

The correct answer is "*". In Microsoft Excel, the asterisk symbol (*) is used as the operator for multiplication. This means that when you want to perform a multiplication calculation in Excel, you would use the asterisk symbol between the numbers or cell references that you want to multiply together.

Submit
Please wait...
About This Quiz
Ulangan Harian-1 Tik Kls 8 Semester 2 Quiz - Quiz

2. Nama dan kegunaan ikon di atas adalah untuk ....

Explanation

The correct answer is Paste, untuk menempatkan data yang akan disalin/dipindah ke suatu sel/range. This is because the Paste icon is used to place data that has been copied or moved into a specific cell or range.

Submit
3. Bagian yang dilingkari pada gambar di atas, merupakan suatu tempat untuk menampilkan rumus-rumus dari sebuah sel yang dinamakan ....

Explanation

The circled section in the image is called the Formula Bar. It is where you can view and edit the formulas of a selected cell.

Submit
4. Untuk menutup lembar kerja tanpa keluar dari Microsoft Excel 2007 perintahnya adalah klik Office Button, kemudian klik ....

Explanation

To close a worksheet without exiting Microsoft Excel 2007, the command is to click on the Office Button and then click on "Close". This option allows the user to close the current worksheet while keeping Excel open, allowing them to continue working on other tasks or open a new worksheet if needed.

Submit
5. Untuk mengedit isi suatu sel dapat dijalankan dengan menekan tombol fungsi pada keyboard, yaitu ....

Explanation

To edit the content of a cell in a spreadsheet, the F2 function key on the keyboard can be pressed. This key activates the editing mode for the selected cell, allowing the user to modify its contents. The F1 key is typically used for accessing help, while F3 and F4 have different functions in various software applications. Therefore, the correct answer for this question is F2.

Submit
6. Untuk mengubah jenis huruf pada Microsoft Excel dijalankan lewat tab menu ....

Explanation

The correct answer is "Home" because the Home tab in Microsoft Excel contains various formatting options, including changing the font style. By selecting the text and navigating to the Home tab, users can easily modify the font type, size, and other formatting attributes to suit their preferences.

Submit
7. Untuk menjumlahkan angka-angka yang berada pada deretan sel yang panjang, bisa dilakukan dengan penjumlahan otomatis, yaitu dengan memilih perintah ....

Explanation

The correct answer is AutoSum because it is a command that allows users to automatically calculate the sum of a range of cells in Microsoft Excel. By selecting the AutoSum command, users can quickly add up a series of numbers without having to manually input the formula. This feature is especially useful when working with large sets of data and helps to save time and reduce the chances of errors in calculations.

Submit
8. Selain Microsoft Excel, masih ada beberapa aplikasi pengolah angka yang lain, contohnya adalah ....

Explanation

OpenOffice.org Calc is mentioned as an example of another spreadsheet application, along with Microsoft Excel. This suggests that there are multiple options available for processing numbers and data, and OpenOffice.org Calc is one of them.

Submit
9. Sebuah ruangan dalam worksheet Excel yang merupakan perpotongan antara kolom dan baris disebut ....

Explanation

The correct answer is "sel." In Excel, a "sel" refers to a cell, which is the intersection point of a column and a row in a worksheet. It is the basic unit where data can be entered, edited, and manipulated. A range refers to a group of cells, a sheet refers to a single worksheet within a workbook, and a cell pointer is a cursor that indicates the current active cell.

Submit
10. Pada Microsoft Excel, untuk menempatkan judul di tengah diantara beberapa sel dalam satu baris caranya adalah dengan memilih ikon ....

Explanation

To place a title in the center between multiple cells in one row in Microsoft Excel, the appropriate icon to use is Merge & Center. This feature combines the selected cells into one cell and centers the text within it.

Submit
11. Dalam keadaan default (belum diubah) jumlah lembar kerja dalam sebuah workbook Microsoft Excel 2007 adalah ....

Explanation

In the default state, a workbook in Microsoft Excel 2007 contains three sheets. This means that when a new workbook is created, it will have three blank sheets where users can enter and organize their data. These sheets can be used for different purposes or categories within the workbook, allowing users to keep their data organized and easily accessible.

Submit
12. Jika pada Name Box tertulis H27, artinya adalah bahwa cell pointer terletak pada ....

Explanation

The Name Box in Excel displays the reference of the currently selected cell. In this case, the Name Box shows "H27", indicating that the cell pointer is located in column H and row 27.

Submit
13. Gambar di atas adalah salah satu komponen pada interface Microsoft Excel yang dinamakan ....

Explanation

The correct answer is Quick Access Toolbar. The given image shows a component in Microsoft Excel that is commonly known as the Quick Access Toolbar. This toolbar provides quick and easy access to commonly used commands and functions in Excel, allowing users to customize it according to their preferences. It is located above the ribbon and can be customized to include frequently used commands for efficient workflow.

Submit
14. Workseet Microsoft Excel 2007 terdiri atas kolom dan baris. Jumlah kolom seluruhnya pada sebuah worksheet adalah ... kolom.

Explanation

The correct answer is 16.384. A Microsoft Excel 2007 worksheet consists of columns and rows. The total number of columns in a worksheet is 16.384.

Submit
15. Untuk memindahkan cell pointer langsung menuju ke awal lembar kerja (Sel A1) adalah dengan menekan tombol keyboard ....

Explanation

To move the cell pointer directly to the beginning of the worksheet (cell A1), you can press the keyboard shortcut Ctrl Home. This shortcut helps in quickly navigating to the top-left corner of the worksheet, allowing users to easily access the first cell.

Submit
16. Di bawah ini, yang tidak termasuk dalam menu perintah pada Office Button adalah ....

Explanation

The correct answer is "View" because the other options (Save, Print, and Prepare) are all commonly found in the menu commands of the Office Button. "View" is not typically included in the Office Button menu commands, as it is usually found in a separate tab or toolbar for adjusting the display settings of the document.

Submit
17. Apabila kita bermaksud akan memformat angka dengan tanda pemisah ribuan, maka bisa dijalankan dengan meng-klik ikon ....

Explanation

The correct answer is "Comma Style". When we want to format numbers with a thousand separator, we can use the "Comma Style" option. This option adds a comma as a separator for every three digits in the number, making it easier to read and understand large numbers. By selecting this option, we can quickly format the numbers with a thousand separator without having to manually add commas.

Submit
18. Jika pada sel D3, D4, D5 masing-masing tertera angka 7000, 2000, dan 3000, serta di sel D6 terdapat rumus:  =D3+D4+D5/3 Maka hasil dari perhitungan rumus tersebut adalah ....

Explanation

The formula in cell D6 calculates the average of the numbers in cells D3, D4, and D5. It adds the values in D3, D4, and D5 and then divides the sum by 3. So, the calculation would be (7000 + 2000 + 3000) / 3 = 12000 / 3 = 4000. Therefore, the correct answer is 4000.

Submit
19. Apabila di lembar kerja Excel kita ketikkan data sebagai berikut :   572R Maka data tersebut termasuk data ....

Explanation

The given data "572R" is a combination of numbers and letters, which makes it a text data. In Excel, text data is any combination of letters, numbers, and special characters that are not used in calculations. Therefore, the correct answer is "Text".

Submit
20. Di bawah ini adalah contoh penulisan rumus yang benar, kecuali ....

Explanation

not-available-via-ai

Submit
View My Results

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

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
  • Feb 07, 2012
    Quiz Created by
    Roedy
Cancel
  • All
    All (20)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Pada Microsoft Excel, tanda operator untuk perhitungan perkalian...
Nama dan kegunaan ikon di atas adalah untuk ....
Bagian yang dilingkari pada gambar di atas, merupakan suatu tempat...
Untuk menutup lembar kerja tanpa keluar dari Microsoft Excel 2007...
Untuk mengedit isi suatu sel dapat dijalankan dengan menekan tombol...
Untuk mengubah jenis huruf pada Microsoft Excel dijalankan lewat tab...
Untuk menjumlahkan angka-angka yang berada pada deretan sel yang...
Selain Microsoft Excel, masih ada beberapa aplikasi pengolah angka...
Sebuah ruangan dalam worksheet Excel yang merupakan perpotongan antara...
Pada Microsoft Excel, untuk menempatkan judul di tengah diantara...
Dalam keadaan default (belum diubah) jumlah lembar kerja dalam sebuah...
Jika pada Name Box tertulis H27, artinya adalah bahwa cell pointer...
Gambar di atas adalah salah satu komponen pada interface Microsoft...
Workseet Microsoft Excel 2007 terdiri atas kolom dan baris. Jumlah...
Untuk memindahkan cell pointer langsung menuju ke awal lembar kerja...
Di bawah ini, yang tidak termasuk dalam menu perintah pada Office...
Apabila kita bermaksud akan memformat angka dengan tanda pemisah...
Jika pada sel D3, D4, D5 masing-masing tertera angka 7000, 2000, dan...
Apabila di lembar kerja Excel kita ketikkan data sebagai berikut...
Di bawah ini adalah contoh penulisan rumus yang benar, kecuali ....
Alert!

Advertisement