Soal Ulangan Tik Kelas 8 Semester 2

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 Anwar Mubarak
A
Anwar Mubarak
Community Contributor
Quizzes Created: 2 | Total Attempts: 45,933
| Attempts: 24,455 | Pertanyaan: 50
Please wait...

Question 1 / 50
0 %
0/100
Score 0/100
1. Fungsi yang digunakan untuk menghitung rata-rata data angka

Explanation

The correct answer is d. Average. The average function is used to calculate the average of a set of numerical data. It adds up all the values and divides the sum by the total number of values in the set. This provides a measure of the central tendency of the data set.

Submit
Please wait...
About This Quiz
Soal Ulangan Tik Kelas 8 Semester 2 - Quiz

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. Fungsi yang digunakan untuk menghitung nilai terkecil data angka

Explanation

The correct answer is c. Min. The function "Min" is used to calculate the smallest value in a set of numeric data. It is commonly used to find the minimum value in a list or array of numbers. In this context, it can be used to find the smallest value among a group of numbers. The "Min" function is a mathematical operation that helps in identifying the minimum value present in a dataset.

Submit
3. 14. Fungsi yang digunakan untuk mengubah data teks menjadi data numeric

Explanation

The function "Value" is used to convert text data into numeric data. This function takes a text input and returns its corresponding numeric value. It is commonly used when dealing with data that is stored as text but needs to be treated as numbers for mathematical calculations or comparisons.

Submit
4. Fungsi yang digunakan untuk menghitung nilai terbesar data angka

Explanation

The correct answer is b. Max. The function "Max" is used to calculate the largest value among a set of numerical data. It returns the maximum value or the highest number from the given data.

Submit
5. Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu

Explanation

The correct answer is "b. Right" because the right function is used to extract a specified number of characters from the right side of a text string. It is commonly used to extract file extensions or the last few digits of a number.

Submit
6. Fungsi yang digunakan untuk mengambil beberapa karakter di tengah-tengah data teks

Explanation

The correct answer is c. Mid. The Mid function is used to extract a specific number of characters from the middle of a text string. It requires three arguments: the text string, the starting position, and the number of characters to extract. This function is commonly used in programming to manipulate and extract substrings from text data.

Submit
7. Bagian excel yang digunakan untuk mengerakan lembaran kerja dalam arah horizontal adalah

Explanation

The correct answer is b. scroll bar horizontal. The horizontal scroll bar in Excel is used to move the worksheet left or right along the horizontal axis. It allows users to view and access cells that are not currently visible on the screen. By dragging the scroll bar to the right, the worksheet moves to the right, and by dragging it to the left, the worksheet moves to the left. This feature is helpful when working with large spreadsheets that extend beyond the visible area of the screen.

Submit
8. Fungsi yang digunakan untuk menghitung penjumlahan data angka

Explanation

The correct answer is "a. Sum" because the function "Sum" is used to calculate the total sum of a set of numerical data. It adds up all the numbers in the dataset and provides the sum as the result. This function is commonly used in mathematical calculations and data analysis to find the total value or cumulative sum of a series of numbers.

Submit
9. Perintah yang digunakan untuk membatalkan perintah yang sudah terlanjur diberikan adalah :

Explanation

The correct answer is "a. Undo". The undo command is used to reverse or cancel the previous command that has been given. It allows users to revert back to a previous state or action, effectively undoing any changes made. This can be useful in various applications, such as word processors, graphic design software, or even in operating systems, where users can undo their actions and restore the system to a previous state.

Submit
10. Menghitung rata-rata data angka menggunakan fungsi :

Explanation

The correct answer is a. Average because the question asks for the function used to calculate the average of numerical data. The average function calculates the sum of all the numbers and then divides it by the total count of numbers, giving the average value.

Submit
11. Perintah untuk menyimpan lembar kerja excel dengan menekan tombol

Explanation

The correct answer is "a. Ctrl S". This keyboard shortcut is commonly used to save Excel workbooks. By pressing Ctrl S, the user can quickly save their current work without having to navigate through the File menu or use the mouse to click on the Save button. This shortcut is a time-saving feature that allows users to easily save their progress and prevent data loss.

Submit
12. Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu

Explanation

The correct answer is "a. Left". The Left function is used to extract a specified number of characters from the beginning (left) of a text string. It is commonly used to retrieve the leftmost characters of a string, based on a specified length.

Submit
13. Berikut ini yang bukan termasuk kelompok program Microsoft office adalah

Explanation

Microsoft Windows is not a program in the Microsoft Office suite. It is an operating system developed by Microsoft. The other options, Microsoft Excel, Microsoft Word, and Microsoft PowerPoint, are all programs included in the Microsoft Office suite.

Submit
14. Microsoft Excel merupakan program aplikasi

Explanation

Microsoft Excel is a program application that is specifically designed for creating and managing spreadsheets. It allows users to input and manipulate data, perform calculations, and create charts and graphs. Spreadsheets are used to organize and analyze data in a tabular format, making it easier to track and interpret information. Microsoft Excel is widely used in various industries and professions, such as finance, accounting, and data analysis.

Submit
15. Perintah open dapat dijalankan dari menu file dan tombol open di toolbar standar.selain itu, perintah open dapat juga dijalankan dengan menekan tombol…dikeyboard.

Explanation

The correct answer is "b. ctrl O". The explanation is that the question is asking for the keyboard shortcut to execute the "open" command. The other options (ctrl V, ctrl U, ctrl B) are not commonly associated with the "open" command.

Submit
16. Perintah yang digunakan untuk menggandakan data adalah

Explanation

The correct answer is b. copy dan paste. Copy and paste is the command used to duplicate data. This command allows the user to select a portion of text or an object and create a duplicate of it in another location or document. The copied data is temporarily stored in the computer's clipboard, and then it can be pasted in the desired location. This command is commonly used in various applications and operating systems to quickly duplicate information without having to retype or recreate it.

Submit
17. Fungsi yang digunakan untuk menghitung banyak data dalam range tertentu

Explanation

The correct answer is "a. Count". The count function is used to calculate the number of data points within a specific range. It is commonly used in data analysis to determine the frequency or occurrence of certain values.

Submit
18. Yang bukan termasuk fungsi statistik di bawah ini adalah

Explanation

The correct answer is "a. If". This is because "If" is not a statistical function but rather a conditional statement used in programming or logical operations. The other options, "Large", "Small", and "Rank", are all statistical terms or functions that are used to analyze and interpret data.

Submit
19. Perbesaran lembaran kerja diatur dengan menggunakan perintah

Explanation

The correct answer is c. zoom. Zoom is a command that allows for the enlargement or reduction of the worksheet view. It is used to adjust the size of the worksheet to fit the user's preference or to focus on specific details. The other options, customs view, full screen, and view sheets, do not directly relate to adjusting the size of the worksheet.

Submit
20. Jika kita mempunyai table yang melebar ke samping,maka sebaiknya kita memilih orientasi kertas

Explanation

The correct answer is a. landscape. When we have a table that extends horizontally, it is more suitable to choose the landscape orientation for the paper. This allows the table to fit better on the page and makes it easier to read and analyze the data. Portrait orientation, on the other hand, is more suitable for vertical content or documents that have more text than tables. Tegak and terserah apa saja are not relevant options for choosing the orientation of the paper.

Submit
21. Berikut ini yang tidak dapat digunakan untuk menjalankan excel adalah

Explanation

A Word document cannot be used to run Excel. Word and Excel are two different Microsoft Office applications with different functionalities. Word is primarily used for creating and editing documents, while Excel is used for creating and managing spreadsheets. Therefore, a Word document cannot be used to open or run Excel.

Submit
22. Print preview digunakan untuk

Explanation

Print preview digunakan untuk melihat tampilan halaman sebelum dicetak. Dengan menggunakan fitur ini, pengguna dapat melihat bagaimana halaman akan terlihat ketika dicetak, termasuk tata letak, teks, gambar, dan elemen-elemen lainnya. Hal ini memungkinkan pengguna untuk memeriksa apakah halaman telah diformat dengan benar sebelum mencetaknya, sehingga mengurangi kemungkinan kesalahan dan memastikan hasil cetakan yang diinginkan.

Submit
23. Mengatur tanda decimal dan ribuan yang digunakan di lakukan di kotak dialog

Explanation

The correct answer is "b. format cells" because the question is asking about how to adjust decimal and thousand separators, which is a formatting feature. In Excel, the "Format Cells" option allows users to customize the appearance of cells, including the decimal and thousand separators. This option can be accessed through the "Format" tab in the Excel ribbon or by right-clicking on a cell and selecting "Format Cells" from the context menu.

Submit
24. Mengatur tanda rupiah untuk data yang berupa uang dilakukan di kotak dialog

Explanation

The correct answer is b. format cells. In the format cells dialog box, you can customize the appearance of the data, including applying currency formatting to display the data as currency with the appropriate currency symbol, such as the rupiah symbol in this case.

Submit
25. Untuk mengedit sel, kita dapat menggunakan tombol :

Explanation

The answer is b. F2 because F2 is the function key that is commonly used for editing cells in various software applications, including Microsoft Excel. Pressing F2 allows the user to enter into the edit mode for the selected cell, where they can make changes to the cell's contents.

Submit
26. Untuk mengakhiri Excel dapat menekan tombol :

Explanation

To close Excel, you can press the combination of keys "Alt + F4". This key combination is a commonly used shortcut to close a program or window in many applications, including Excel. By pressing "Alt + F4", you are instructing the program to close and exit, allowing you to end your Excel session.

Submit
27. Untuk mengatur lebar kolom table secara otomatis menggunakan perintah

Explanation

The correct answer is c. format, column, autofit column width. This is because the question is asking for the command to automatically adjust the width of the columns in a table. The command "autofit column width" is used in the "format" menu to achieve this. The other options mentioned in the question (a. format, wide, height, b. format, row, height, d. format, row, autoselection) do not accurately describe the command for automatically adjusting column width.

Submit
28. Toolbar yang ditampilkan secara default dijendela excel adalah toolbar

Explanation

The correct answer is a. formatting dan standard. The default toolbar displayed in the Excel window includes both the formatting toolbar and the standard toolbar. The formatting toolbar allows users to quickly apply formatting options such as font style, size, and color, while the standard toolbar provides access to common commands like save, copy, paste, and undo.

Submit
29. Baris yang digunakan untuk menampilkan informasi mengenai isi sel yang sedang aktif (disorot) di lembar kerja :

Explanation

The formula bar is used to display information about the contents of the active cell in a worksheet. It is located above the worksheet grid and shows the formula or value of the selected cell. This allows users to easily view and edit the data in the active cell without directly modifying the cell itself. The toolbar, scroll bar, and menu bar are not specifically designed for displaying information about the active cell.

Submit
30. Perintah print dapat juga dijalankan dari tombol keyboard dengan cara menekan tombol

Explanation

The correct answer is d. ctrl P. This is because the question is asking about the keyboard shortcut to execute the print command, and pressing ctrl P is the correct shortcut to do so. The other options (ctrl V, ctrl C, ctrl Shift P) are not related to the print command.

Submit
31. Untuk mengatur tinggi baris table menggunakan perintah

Explanation

The correct answer is b. format, row, height. This is because when formatting a table, one can adjust the height of the rows using the "format" command and specifying the "row" option. This allows for customization and control over the appearance of the table. The "height" parameter determines the desired height of the rows in the table.

Submit
32. Salah satu cara untuk memilih seluruh data di lemburan kerja adalah dengan menekan tombol…di keyboard.

Explanation

To select all data in a document or spreadsheet, you can use the keyboard shortcut "ctrl A". This combination of keys will highlight or select all the text, tables, or cells in the current document or spreadsheet. This is a commonly used shortcut in various applications and can save time when you need to select and manipulate a large amount of data.

Submit
33. Yang bukan termasuk fungsi string di bawah ini adalah :

Explanation

The correct answer is d. If. This is because "if" is not a string function. It is a conditional statement used for decision-making in programming. String functions are used to manipulate and perform operations on strings, such as finding the length, converting case, or extracting substrings. The other options, a. Text, b. Lower, and c. Upper, are all examples of string functions.

Submit
34. Tombol yang digunakan untuk menjalankan sebuah perintah disebut

Explanation

The correct answer is b. toolbar. A toolbar is a set of icons or buttons that provide quick access to commonly used commands or functions in a software application. It is usually located at the top or bottom of the screen and allows users to perform tasks or execute commands with just a single click.

Submit
35. menambahkan tanda pemisah ribuan ke data yang di lembaran kerja dilakukan di kotak dialog

Explanation

The correct answer is b. format cells. In Microsoft Excel, the "Format Cells" option allows users to customize the appearance of cells, including adding a thousand separator to data in a worksheet. This can be done by selecting the desired cells, opening the "Format Cells" dialog box, navigating to the "Number" tab, selecting the "Number" category, and choosing the desired format with a thousand separator.

Submit
36. Berikut ini tombol yang dapat digunakan untuk menggeser sel yang aktif adalah

Explanation

The correct answer is d. semua benar (all of the above). This means that all of the options mentioned (tombol enter, tombol tab, tombol arah) can be used to shift the active cell.

Submit
37. Selain dengan cara drag and drop.memindahkan data dapat juga dilakukan dengan cara menjalankan perintah

Explanation

The correct answer is a. cut dan paste. This is because the sentence states that data can be moved by running a command, and the command mentioned here is "cut dan paste" which translates to "cut and paste" in English. This command involves cutting the data from its original location and pasting it to a new location.

Submit
38. Perintah yang digunakan untuk menampilkan angka dengan format tampilan menggunakan lambang uang adalah :

Explanation

The correct answer is a. Currency. The currency format is used to display numbers with a currency symbol. This format is commonly used when working with financial data or when displaying monetary values. It adds a currency symbol (such as $ or €) to the number and formats it according to the currency conventions of the locale.

Submit
39. Yang disebut fungsi logika di bawah ini adalah

Explanation

The correct answer is "a. If". The term "If" refers to a logical function in programming or spreadsheet software that allows for conditional statements. It is used to perform different actions based on whether a certain condition is true or false. This function is commonly used in programming languages and spreadsheet formulas to control the flow of the program or to perform calculations based on specific conditions.

Submit
40. Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu :

Explanation

The correct answer is a. Tabel. The Vlookup and Hlookup functions are used to read data from a table. These functions allow you to search for a specific value in a table and retrieve corresponding data from the same row or column. They are commonly used in Excel to perform lookups and retrieve information from large datasets organized in a tabular format.

Submit
41. Untuk menampilkan toolbar dilakukan di menu

Explanation

The correct answer is b. View. The toolbar can be displayed by selecting the "View" menu.

Submit
42. Bagian jendela excel yang harus diklik untuk menampilkan lembaran kerja yang tidak aktif adalah

Explanation

The correct answer is b. tab lembaran kerja. In Excel, each worksheet is displayed as a tab at the bottom of the window. By clicking on the tab of the inactive worksheet, you can switch to that worksheet and display it in the window. The tab lembaran kerja refers to the worksheet tab, so by clicking on it, you can display the inactive worksheet.

Submit
43. Berikut ini adalah tombol yang terdapat pada jendela excel pada kondisi tampilan print preview, kecuali

Explanation

The correct answer is b. back. In the print preview mode, the back button is not available because it is used to navigate back to the previous screen or window. The other options, print, zoom, and close, are commonly found in the print preview mode and are used for their respective functions.

Submit
44. Bagian jendela excel yang berfungsi untuk menampilkan alamat sel yang sedang aktif adalah

Explanation

The correct answer is b. bar nama. The "bar nama" in Excel is the name box, which displays the address of the currently active cell. This allows users to easily identify the location of the cell they are working on. The formula bar (a) displays the contents of the active cell, the status bar (c) shows information about the current status of Excel, and the title bar (d) displays the name of the Excel workbook.

Submit
45. Mengatur lebar kolom dimulai dengan mengklik menu

Explanation

To adjust the width of a column, you need to click on the "format" menu. This menu usually contains various formatting options, including the option to modify the width of columns. By selecting the "format" menu, you can access the necessary tools to adjust the column width according to your requirements.

Submit
46. Untuk mencetak rumus yang terdapat di lembaran kerja,kita perlu megatur agar lembaran kerja berada pada kondisi formula auditing mode.formula auditing mode dijalankan dari menu

Explanation

To print the formulas on a worksheet, we need to set the worksheet to formula auditing mode. Formula auditing mode is accessed from the "tools" menu.

Submit
47. Perintah page setup dijalankan dari menu

Explanation

The correct answer is a. file. The page setup command is typically found in the file menu of various software applications. This command allows users to adjust the settings and layout of a document or page before printing or exporting it. By selecting the file menu and choosing the page setup option, users can access a range of settings such as paper size, orientation, margins, and headers/footers.

Submit
48. Formula bar dapat diatur agar ditampilkan atau tidak ditampilkan dengan menggunakan kotak dialog options atau menuview.perintah untuk menampilkan kotak dialog options terdapat dimenu

Explanation

The correct answer is d. tools. The formula bar can be configured to be displayed or not displayed using the options dialog box or the view menu. The tools menu contains the command to display the options dialog box.

Submit
49. Menambahkan fungsi di lembaran kerja dapat dilakukan dengan menjalankan perintah function. Perintah function terdapat di menu

Explanation

To add a function in a worksheet, you can use the "insert" command. The "insert" command allows you to add various elements, such as functions, charts, tables, etc., to your worksheet. Therefore, option a. "insert" is the correct answer as it specifically mentions the command that is used to add functions in a worksheet.

Submit
50. Perintah untuk menambahkan header and footer dijalankan dari menu

Explanation

The correct answer is c. view. This is because the command to add a header and footer is typically found in the "view" menu of most software programs. The "view" menu usually contains options for customizing the display of the document, such as showing or hiding certain elements like headers and footers. Therefore, it is logical to assume that the command to add a header and footer would be located in the "view" menu.

Submit
View My Results

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

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 21, 2011
    Quiz Created by
    Anwar Mubarak
Cancel
  • All
    All (50)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Fungsi yang digunakan untuk menghitung rata-rata data angka
Fungsi yang digunakan untuk menghitung nilai terkecil data angka
14. Fungsi yang digunakan untuk mengubah data teks menjadi data ...
Fungsi yang digunakan untuk menghitung nilai terbesar data angka
Fungsi yang digunakan untuk mengambil bagian kanan dari data teks ...
Fungsi yang digunakan untuk mengambil beberapa karakter di ...
Bagian excel yang digunakan untuk mengerakan lembaran kerja dalam ...
Fungsi yang digunakan untuk menghitung penjumlahan data angka
Perintah yang digunakan untuk membatalkan perintah yang sudah ...
Menghitung rata-rata data angka menggunakan fungsi :
Perintah untuk menyimpan lembar kerja excel dengan menekan tombol
Fungsi yang digunakan untuk mengambil bagian kiri dari data teks ...
Berikut ini yang bukan termasuk kelompok program Microsoft office ...
Microsoft Excel merupakan program aplikasi
Perintah open dapat dijalankan dari menu file dan tombol open di ...
Perintah yang digunakan untuk menggandakan data adalah
Fungsi yang digunakan untuk menghitung banyak data dalam range...
Yang bukan termasuk fungsi statistik di bawah ini adalah
Perbesaran lembaran kerja diatur dengan menggunakan perintah
Jika kita mempunyai table yang melebar ke samping,maka sebaiknya ...
Berikut ini yang tidak dapat digunakan untuk menjalankan excel ...
Print preview digunakan untuk
Mengatur tanda decimal dan ribuan yang digunakan di lakukan di ...
Mengatur tanda rupiah untuk data yang berupa uang dilakukan di ...
Untuk mengedit sel, kita dapat menggunakan tombol :
Untuk mengakhiri Excel dapat menekan tombol :
Untuk mengatur lebar kolom table secara otomatis menggunakan perintah
Toolbar yang ditampilkan secara default dijendela excel adalah ...
Baris yang digunakan untuk menampilkan informasi mengenai isi sel yang...
Perintah print dapat juga dijalankan dari tombol keyboard dengan ...
Untuk mengatur tinggi baris table menggunakan perintah
Salah satu cara untuk memilih seluruh data di lemburan kerja ...
Yang bukan termasuk fungsi string di bawah ini adalah :
Tombol yang digunakan untuk menjalankan sebuah perintah disebut
Menambahkan tanda pemisah ribuan ke data yang di lembaran kerja ...
Berikut ini tombol yang dapat digunakan untuk menggeser sel yang ...
Selain dengan cara drag and drop.memindahkan data dapat juga ...
Perintah yang digunakan untuk menampilkan angka dengan format ...
Yang disebut fungsi logika di bawah ini adalah
Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu :
Untuk menampilkan toolbar dilakukan di menu
Bagian jendela excel yang harus diklik untuk menampilkan lembaran...
Berikut ini adalah tombol yang terdapat pada jendela excel pada ...
Bagian jendela excel yang berfungsi untuk menampilkan alamat sel ...
Mengatur lebar kolom dimulai dengan mengklik menu
Untuk mencetak rumus yang terdapat di lembaran kerja,kita perlu ...
Perintah page setup dijalankan dari menu
Formula bar dapat diatur agar ditampilkan atau tidak ditampilkan ...
Menambahkan fungsi di lembaran kerja dapat dilakukan dengan ...
Perintah untuk menambahkan header and footer dijalankan dari menu
Alert!

Advertisement