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,458
| Attempts: 1,459
SettingsSettings
Please wait...
  • 1/20 Questions

    Program pengolah angka Microsoft Excel diproduksi oleh perusahaan softwere..

    • Microsoft Corporation
    • PT Adi Sejahtera
    • Corel
    • Appel
    • Delpi
Please wait...
Tes Soal-soal Tik - Quiz
About This 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.

Quiz Preview

  • 2. 

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

    • =MAX(L2:LVII)

    • =MAX(L2:L7)

    • MAX=(L7:12)

    • MAX=(L6:L7)

    • MAX=(L7:L20)

    Correct Answer
    A. =MAX(L2:L7)
    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.

    Rate this question:

  • 3. 

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

    • Mengolah data berupa angka

    • Membuat grafik

    • Operasi perhitungan matematika

    • Operasi statistik

    • Mengolah gambar

    Correct Answer
    A. Mengolah gambar
    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.

    Rate this question:

  • 4. 

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

    • Print

    • view

    • Print preview

    • Look

    • Minimize

    Correct Answer
    A. Print preview
    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.

    Rate this question:

  • 5. 

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

    • )

    • =

    • *

    • /

    • ^

    Correct Answer
    A. =
    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.

    Rate this question:

  • 6. 

    Untuk menyatakan pangkat, kita menggunakan.....

    • *

    • /

    • >

    • ^

    Correct Answer
    A. ^
    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.

    Rate this question:

  • 7. 

    Perintah untuk memodifikasi lebar kolom adalah….

    • Row > width

    • Column > width

    • Cell > width

    • Window > width

    • Colors > width

    Correct Answer
    A. Column > width
    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.

    Rate this question:

  • 8. 

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

    • File

    • View

    • Insert

    • Format

    • Data

    Correct Answer
    A. Insert
    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.

    Rate this question:

  • 9. 

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

    • data > sort > ascending

    • View > header and footer

    • Format > cell

    • Data > sort > desceding

    • Insert > rows

    Correct Answer
    A. data > sort > ascending
    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.

    Rate this question:

  • 10. 

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

    • Alt + F1

    • Alt + F2

    • Alt + F3

    • Alt + F4

    • Alt + F5

    Correct Answer
    A. Alt + F4
    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.

    Rate this question:

  • 11. 

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

    • Column

    • Line

    • Pie

    • Area

    • Xy(scatter)

    Correct Answer
    A. Pie
    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.

    Rate this question:

  • 12. 

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

    • 12

    • 36

    • 38

    • 48

    • 62

    Correct Answer
    A. 48
    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.

    Rate this question:

  • 13. 

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

    • Kiri

    • Kanan

    • Tengah

    • Bawah

    • Atas

    Correct Answer
    A. Kanan
    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.

    Rate this question:

  • 14. 

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

    • Blok data di sheet 2 > cut > copy > blok sheet 3 > klik kanan > paste

    • Blok data di sheet 2 > cut > buka sheet 3 > klik kanan > paste

    • Blok data di sheet 2 > delete

    • Blok data di sheet 2 > cut > paste

    • Blok data di sheet 2 > copy > blok sheet 3 > paste

    Correct Answer
    A. Blok data di sheet 2 > cut > buka sheet 3 > klik kanan > paste
    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.

    Rate this question:

  • 15. 

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

    • Drawin

    • Toolbar Standard

    • Charter

    • Cut

    • Chart Wizard

    Correct Answer
    A. Chart Wizard
    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.

    Rate this question:

  • 16. 

    Untuk mencari banyaknya data dari suatu tabel....

    • =max

    • =min

    • =average

    • =count

    • =sum

    Correct Answer
    A. =count
    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.

    Rate this question:

  • 17. 

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

    • Rows

    • Header/Footer

    • Picture

    • Column

    • Object

    Correct Answer
    A. Header/Footer
    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.

    Rate this question:

  • 18. 

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

    • Copy paste

    • Copy paste special

    • Edit > paste

    • edit > copy

    • Cut > paste

    Correct Answer
    A. edit > copy
    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.

    Rate this question:

  • 19. 
    Perhatikan gambar berikut iniPada sel C3, apabila pada selC3, berdasarkan pada sel A3,maka rumus yang dapat dituliskan untuk agar sesuai dengan isi padasel C3 adalah - ProProfs

    Perhatikan gambar berikut iniPada sel C3, apabila pada selC3, berdasarkan pada sel A3,maka rumus yang dapat dituliskan untuk agar sesuai dengan isi padasel C3 adalah

    • =AVERAGE(A3:1)

    • =RIGTH9(A3:3)

    • =LEFT(A3:4)

    • =LEN(A3:2)

    • =SUM(A2:C3)

    Correct Answer
    A. =LEFT(A3:4)
    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.

    Rate this question:

  • 20. 

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

    • SUM

    • AVERAGE

    • LEN

    • LENGTH

    • COUNT

    Correct Answer
    A. COUNT
    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.

    Rate this question:

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.