Ulangan Harian 1 Semester 2 Tik

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 Slamail.now
S
Slamail.now
Community Contributor
Quizzes Created: 1 | Total Attempts: 660
| Attempts: 660 | Pertanyaan: 25
Please wait...

Question 1 / 25
0 %
0/100
Score 0/100
1. Untuk mengolah data-data/angka, pembuatan tabel atau diagram akan lebih mudah jika menggunakan program ...

Explanation

Microsoft Excel is the correct answer because it is a program specifically designed for data processing and analysis. It provides tools and functions for creating tables, performing calculations, and generating charts and graphs. Microsoft Word is a word processing program, Microsoft Power Point is a presentation program, and Microsoft Access is a database management program, which are not as suitable for processing numerical data as Microsoft Excel.

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

Tell us your name to personalize your report, certificate & get on the leaderboard!
2. Pada microsoft Excel 2007 ketika Office button diklik muncul menu pilihan berikut, kecuali...

Explanation

When the Office button is clicked in Microsoft Excel 2007, a menu with the options "New," "Open," "Save," and "Cut" appears. The word "except" in the question suggests that one of these options does not appear in the menu. Therefore, the correct answer is "Cut" because it is the only option listed that does not appear in the menu when the Office button is clicked.

Submit
3. Sel-sel yang termasuk data Rumus adalah... 

Explanation

The cells F3, F4, F5, F6, and F7 are included in the data range "Rumus".

Submit
4. Apa bedanya Save dengan Save As? 

Explanation

The correct answer explains that "Save" is used to save updates without changing the file name, while "Save As" is used to save the workbook with a new file name. This means that "Save" is used when you want to save changes to an existing file, while "Save As" is used when you want to create a new file or save changes to a different file.

Submit
5. Gabungan dari beberapa sel atau sekelompok sel disebut ... 

Explanation

Gabungan dari beberapa sel atau sekelompok sel disebut range. Range merupakan istilah yang digunakan untuk merujuk pada kumpulan sel yang terletak dalam area tertentu di dalam spreadsheet. Dalam range, kita dapat melakukan operasi atau manipulasi data secara bersamaan pada sel-sel yang termasuk dalam range tersebut.

Submit
6. Langkah yang benar untuk menjalankan program Microsoft Excel 2007 yaitu... 

Explanation

The correct answer is "Start>All Program>Microsoft Office >Microsoft Office Excel 2007". This is the correct sequence of steps to follow in order to run Microsoft Excel 2007. Starting from the Start menu, the user needs to navigate to the "All Programs" section and then find the Microsoft Office folder. Within this folder, they can locate and select Microsoft Office Excel 2007 to launch the program.

Submit
7. Gambar icon perintah tersebut terletak di Tab Home, Grup ...

Explanation

The correct answer is Clipboard because the question states that the command icon is located in the "Tab Home, Grup..." and the only option that fits this description is Clipboard.

Submit
8. Bagian dari lembar kerja Ms Excel yang horisontal/mendatar dan disimbolkan dengan angka disebut ...

Explanation

The horizontal part of an Excel worksheet that is symbolized by numbers is called "Baris" or rows. In Excel, data is organized in a grid format with columns represented by letters and rows represented by numbers. Each row contains a set of cells that can store data or formulas. Therefore, the correct answer for this question is "Baris".

Submit
9. Gambar Ikon perintah di atas terletak di Tab Home, Grup ....

Explanation

The given correct answer is "Font". The question states that the command icon image is located in the Home tab, and it is asking which group it belongs to. Based on common knowledge of software interfaces, the Font group is commonly found in the Home tab of various applications, including word processors and graphic design software. Therefore, it can be inferred that the correct answer is "Font".

Submit
10. Sel aktif berada di B10. B10 artinya ...

Explanation

The correct answer is "Kolom B, Baris 10." This is because the question is asking for the meaning of "B10" and in the given options, "Kolom B, Baris 10" is the only one that corresponds to the given notation. "B10" refers to column B and row 10.

Submit
11. Sel-sel yang termasuk data angka adalah ...

Explanation

The given answer includes the cells B3, B4, B5, B6, and B7. These cells are considered to be "data angka" or numerical data cells.

Submit
12. Langkah untuk membuat lembar kerja baru di MS Excel 2007 yaitu dengan cara klik Office Button>New> Blank Workbook>Create atau klik ikon ..... di Quick Access Toolbar.

Explanation

The correct answer is "File". This is because in MS Excel 2007, to create a new worksheet, you need to click on the Office Button, then select "New", and then choose "Blank Workbook" from the options. Alternatively, you can also click on the "File" icon in the Quick Access Toolbar to create a new worksheet.

Submit
13. Baris pada lembar kerja Ms Excel ditunjukkan dengan ... 

Explanation

The correct answer is 1,2,3, dan seterusnya. In Microsoft Excel, rows are labeled with numbers starting from 1 and continuing in sequential order. Therefore, the baris (rows) on the worksheet are represented by numbers 1, 2, 3, and so on.

Submit
14. Rumus untuk mencari nilai TOTAL HARGA pada sel F4 adalah ...

Explanation

The correct answer is =D4*E4. This formula is used to calculate the total price by multiplying the value in cell D4 with the value in cell E4. This formula assumes that the total price is determined by multiplying the quantity (D4) with the price per unit (E4).

Submit
15. Bagian dari lembar kerja MS Excel yang vertikal/tegak dan disimbolkan dengan huruf disebut ...

Explanation

Kolom adalah bagian dari lembar kerja MS Excel yang terdiri dari sel-sel yang berjajar secara vertikal. Setiap kolom diberi simbol dengan menggunakan huruf, seperti kolom A, kolom B, dan seterusnya. Dalam kolom, kita dapat memasukkan data atau formula ke dalam sel-sel yang ada.

Submit
16. Buku Kerja (Workbook) terdiri dari banyak lembar kerja (worksheets/sheets). Secara default atau standart MS Excel menampilkan beberapa sheet pada buku kerja anda, yaitu...

Explanation

The correct answer is Sheet1, Sheet2, dan Sheet3. MS Excel by default displays three sheets in a workbook.

Submit
17. Untuk memberi garis pada tabel yang baru dibuat, kita blok terlebih dahulu tabelnya, lalu klik ikon ...

Explanation

To give a border to a newly created table, we need to first select the table by blocking it. Then, we can click on the "Border" option and choose "All Border" from the available border styles. This will apply a border to all sides of the table, giving it a complete border.

Submit
18. Gambar tersebut berada di  tab home dan kelompok/grup ...

Explanation

The correct answer is "Number" because the question states that the image is located in the home tab and the group or category is related to numbering. This suggests that the image is likely showing options or tools for formatting or manipulating numbered lists.

Submit
19. Berkas lembar kerja dalam MS Excel disebut sebagai buku kerja (Workbook). Biasanya lembar kerja yang baru dibuat diberi nama ...

Explanation

The correct answer is "Book1" because in MS Excel, a workbook refers to a file that contains multiple worksheets. When creating a new workbook, it is usually given a default name such as "Book1" until the user decides to rename it. Therefore, "Book1" is the most appropriate choice among the given options.

Submit
20. Bagian dari Ms Excel yang terletak di atas dan berfungsi untuk menampilkan nama buku kerja dan informasi lainya disebut ...

Explanation

The title bar in Ms Excel is located at the top of the application window and displays the name of the workbook and other information. It provides a quick reference for users to identify the current workbook they are working on. The title bar also includes buttons for minimizing, maximizing, and closing the application window.

Submit
21. Kolom pada lembar kerja Ms Excel ditunjukkan dengan ... 

Explanation

Kolom pada lembar kerja Ms Excel ditunjukkan dengan huruf-huruf A, B, C, dan seterusnya.

Submit
22. Salah satu program pengolah angka selain Microsoft Excel yang sudah mulai banyak digunakan yang bersifat bebas lisensi (freeware) adalah...

Explanation

Open Office Calc is a free and open-source spreadsheet program that is commonly used as an alternative to Microsoft Excel. It offers similar features and functionality, allowing users to create and manipulate spreadsheets, perform calculations, and analyze data. As it is freeware, it can be downloaded and used without any licensing fees, making it a popular choice for individuals and organizations looking for a cost-effective solution for their spreadsheet needs.

Submit
23. Pada lembar kerja MS Excel terdapat baris dan kolom. Pertemuan antara baris dan kolom disebut juga dengan ...

Explanation

The correct answer is "Sel". In MS Excel, a cell is the intersection point between a row and a column. It is the basic unit of data storage in a worksheet. Therefore, the meeting point between a row and a column is referred to as a "Sel" or a cell.

Submit
24. Pada Ribbon Ms Excel terdapat 7 tab utama yaitu...

Explanation

The correct answer is Home, Insert, Page Layout, Formula, Data, Review, and View.

Submit
25. Sel-sel yang termasuk data label adalah ...

Explanation

The correct answer is B2, C2, D2, E2, F2. These cells are included in the data label because they are located in the second row of the table. The data label typically refers to the row or column headers that provide a description or label for the data in the table. In this case, the cells B2, C2, D2, E2, and F2 contain the labels for the data in the table.

Submit
View My Results

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

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

  • Current Version
  • Mar 14, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 05, 2017
    Quiz Created by
    Slamail.now
Cancel
  • All
    All (25)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Untuk mengolah data-data/angka, pembuatan tabel atau diagram akan...
Pada microsoft Excel 2007 ketika Office button diklik muncul menu...
Sel-sel yang termasuk data Rumus adalah... 
Apa bedanya Save dengan Save As? 
Gabungan dari beberapa sel atau sekelompok sel disebut ... 
Langkah yang benar untuk menjalankan program Microsoft Excel 2007...
Gambar icon perintah tersebut terletak di Tab Home, Grup ...
Bagian dari lembar kerja Ms Excel yang horisontal/mendatar dan...
Gambar Ikon perintah di atas terletak di Tab Home, Grup ....
Sel aktif berada di B10. B10 artinya ...
Sel-sel yang termasuk data angka adalah ...
Langkah untuk membuat lembar kerja baru di MS Excel 2007 yaitu dengan...
Baris pada lembar kerja Ms Excel ditunjukkan dengan ... 
Rumus untuk mencari nilai TOTAL HARGA pada sel F4 adalah ...
Bagian dari lembar kerja MS Excel yang vertikal/tegak dan disimbolkan...
Buku Kerja (Workbook) terdiri dari banyak lembar kerja...
Untuk memberi garis pada tabel yang baru dibuat, kita blok terlebih...
Gambar tersebut berada di  tab home dan kelompok/grup ...
Berkas lembar kerja dalam MS Excel disebut sebagai buku kerja...
Bagian dari Ms Excel yang terletak di atas dan berfungsi untuk...
Kolom pada lembar kerja Ms Excel ditunjukkan dengan ... 
Salah satu program pengolah angka selain Microsoft Excel yang sudah...
Pada lembar kerja MS Excel terdapat baris dan kolom. Pertemuan antara...
Pada Ribbon Ms Excel terdapat 7 tab utama yaitu...
Sel-sel yang termasuk data label adalah ...
Alert!

Advertisement