Tes Soal-soal 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 Sabdaguna
S
Sabdaguna
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,461
| Attempts: 1,461 | Questions: 20
Please wait...
Question 1 / 20
0 %
0/100
Score 0/100
1. Program pengolah angka Microsoft Excel diproduksi oleh perusahaan softwere..

Explanation

The correct answer is Microsoft Corporation. Microsoft Excel is a software program for processing numbers and data, and it is produced by Microsoft Corporation.

Submit
Please wait...
About This Quiz
Tes Soal-soal Tik - Quiz

Explore key functionalities of Microsoft Excel in this quiz titled 'Tes Soal-soal TIK'. Assess skills like formula writing, data manipulation, and basic navigation within Excel. Perfect for learners aiming to enhance their proficiency in office productivity tools.

2. Fungsi MAX untuk mencari nilai maksimum suatu range dari L2 sampai L7 adalah….

Explanation

The correct answer is =MAX(L2:L7). This formula is used to find the maximum value in the range L2 to L7. It will compare all the values in the range and return the highest value.

Submit
3. Berikut ini yang bukan manfaat langsung Ms.Excel adalah......

Explanation

Ms. Excel is primarily used for processing numerical data, creating charts, performing mathematical calculations, and conducting statistical operations. However, it does not have direct features or capabilities to process or manipulate images. Therefore, the correct answer is "mengolah gambar" (processing images), as it is not a direct benefit of using Ms. Excel.

Submit
4. Untuk melihat tampilan sebelum diprint, kita dapat menggunakan fasilitas…..

Explanation

To view the appearance of a document before printing it, we can use the "print preview" feature. This allows us to see how the document will look when printed, including the layout, formatting, and any potential errors. It helps us make any necessary adjustments or corrections before actually printing the document.

Submit
5. Apabila kita ingin menuliskan rumus di dalam Ms.Excel, kita harus mengawlinya dengan tanada ....

Explanation

To write a formula in Microsoft Excel, we need to start it with an equal sign (=). This is because the equal sign is used to indicate that the following characters are part of a formula and not just regular text. By starting a cell entry with an equal sign, Excel knows that it needs to interpret the content as a formula and perform the necessary calculations.

Submit
6. Untuk menyatakan pangkat, kita menggunakan.....

Explanation

The given question is in Indonesian and it asks for the symbol used to indicate exponentiation. The correct answer is "^". In mathematics, the symbol "^" is commonly used to represent exponentiation, where a number is raised to a power. For example, 2^3 means 2 raised to the power of 3, which equals 8.

Submit
7. Perintah untuk memodifikasi lebar kolom adalah….

Explanation

The correct answer is "column > width" because the question asks for the command to modify the width of a column. The other options (row, cell, window, and colors) are not relevant to modifying the width of a column.

Submit
8. Perintah untuk menyisipkan sel, baris, dan kolom, adalah pada menu…..

Explanation

The correct answer is "insert" because it is the menu option that specifically deals with the action of inserting cells, rows, and columns into a document or spreadsheet. The other menu options like "file", "view", "format", and "data" do not have a direct function related to inserting.

Submit
9. Untuk mengurutkan data dari A-Z menggunakan.....

Explanation

To sort data from A-Z, the correct option is "data > sort > ascending". This option allows the user to arrange the data in ascending order based on the selected column.

Submit
10. Selain dengan mengklik tanda silang di sudut kanan atas , untuk menutup jendela yang aktif dapat digunakan tombol yang lain, yaitu

Explanation

The correct answer is Alt + F4. This keyboard shortcut is commonly used to close the active window in Windows operating systems. By pressing the Alt key and the F4 key simultaneously, users can quickly close the current window without having to use the mouse to click on the close button in the top right corner of the window. This shortcut is convenient and efficient for closing windows and can be used in various applications and programs.

Submit
11. Untuk memilih tipe grafik lingkaran, maka tipe grafik yang kita pilih adalah....

Explanation

The correct answer is "pie" because a pie chart is the most suitable type of graph for representing data in the form of a circle. Pie charts are used to display the proportion or percentage distribution of different categories within a whole. Each category is represented by a slice of the pie, with the size of each slice proportional to the data it represents. This type of graph is ideal for showing comparisons between different categories and highlighting the relative importance of each category within the whole.

Submit
12. Apabila sel A3 =2 dan B3=6 hasil rumus = (A3)^3 * B3 adalah…

Explanation

If sel A3 is equal to 2 and sel B3 is equal to 6, the formula (A3)^3 * B3 will give a result of 48.

Submit
13. Apabila kita ingin memindah data yang ada di sheet 2 ke sheet 3, maka caranya....

Explanation

To move data from sheet 2 to sheet 3, the correct steps are to select and cut the data in sheet 2, then open sheet 3, right-click in the desired location, and paste the data.

Submit
14. Di dalam Ms. Excel, penulisan data berupa angka akan secara otomatis berada di.....

Explanation

In Microsoft Excel, numerical data is aligned to the right by default. This means that when you enter numbers in a cell, they will automatically be aligned to the right side of the cell. This alignment is useful for maintaining consistency and readability in a spreadsheet, especially when dealing with large amounts of numerical data.

Submit
15. Nama ikon yang digunakan untuk pembuatan grafik adalah.....

Explanation

The correct answer is "Chart Wizard" because the question is asking about the icon used for creating graphics. The Chart Wizard is a tool or feature in many software programs that allows users to easily create and customize charts and graphs. This icon would typically be found in a toolbar or menu specifically dedicated to creating and editing charts.

Submit
16. Untuk mencari banyaknya data dari suatu tabel....

Explanation

The correct answer is "=count". This function is used to count the number of data entries in a table. It is commonly used in data analysis to determine the size or quantity of a dataset.

Submit
17. Dari instruksi-instruksi berikut, yang bukan termasuk instruksi-instruksi dalam menu insert yaitu......

Explanation

The correct answer is "Header/Footer" because it is not included in the menu options for inserting items into a document. The other options, such as Rows, Picture, Column, and Object, are all valid instructions for inserting different elements into a document. However, Header/Footer is not listed as an option, indicating that it is not included in the insert menu.

Submit
18. Apabila kita menekan tombol Ctrl+C, sama artinya dengan.....

Explanation

When we press Ctrl+C, it is equivalent to selecting the "edit > copy" option. This action allows us to copy the selected text or object and store it in the clipboard. We can then paste it elsewhere using the "edit > paste" option.

Submit
19. Perhatikan gambar berikut ini
Pada sel C3, apabila pada selC3, berdasarkan pada sel A3,maka rumus yang dapat dituliskan untuk agar sesuai dengan isi padasel C3 adalah

Explanation

The correct answer is =LEFT(A3:4). This formula will extract the leftmost characters from the value in cell A3, up to the fourth character.

Submit
20. Function dari ms.exel yang di gunakan untuk menghitung jumblah karakter/teks adalah……
  1. LENGTH
  2. LEN
  3. COUNT
  4. SUM
  5. DSUM

Explanation

The correct answer is COUNT. The COUNT function in Excel is used to count the number of cells in a range that contains numbers, dates, or text. It does not count empty cells or cells that contain non-numeric values. In this case, the question is asking for the function in Excel that is used to count the number of characters/text, and the COUNT function fits this description.

Submit
View My Results

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

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

  • Current Version
  • Mar 19, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 03, 2010
    Quiz Created by
    Sabdaguna
Cancel
  • All
    All (20)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Program pengolah angka Microsoft Excel diproduksi oleh perusahaan...
Fungsi MAX untuk mencari nilai maksimum suatu ...
Berikut ini yang bukan manfaat langsung Ms.Excel adalah......
Untuk melihat tampilan sebelum diprint, kita ...
Apabila kita ingin menuliskan rumus di dalam ...
Untuk menyatakan pangkat, kita menggunakan.....
Perintah untuk memodifikasi lebar kolom adalah….
Perintah untuk menyisipkan sel, baris, dan ...
Untuk mengurutkan data dari A-Z menggunakan.....
Selain dengan mengklik tanda silang di sudut kanan atas , untuk...
Untuk memilih tipe grafik lingkaran, maka ...
Apabila sel A3 =2 dan B3=6 hasil rumus = (A3)^3 * B3 adalah…
Apabila kita ingin memindah data yang ada di ...
Di dalam Ms. Excel, penulisan data berupa angka ...
Nama ikon yang digunakan untuk pembuatan grafik adalah.....
Untuk mencari banyaknya data dari suatu tabel....
Dari instruksi-instruksi berikut, yang bukan termasuk ...
Apabila kita menekan tombol Ctrl+C, sama artinya dengan.....
Perhatikan gambar ...
Function dari ...
Alert!

Advertisement