# Tes Soal-soal Tik

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
Learn about Our Editorial Process
| Written by Sabdaguna
S
Sabdaguna
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,258
Questions: 20 | Attempts: 1,259

Settings

Selamat mengerjakan

• 1.

### Program pengolah angka Microsoft Excel diproduksi oleh perusahaan softwere..

• A.

Microsoft Corporation

• B.

• C.

Corel

• D.

Appel

• E.

Delpi

A. Microsoft Corporation
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.

Rate this question:

• 2.

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

• A.

Alt + F1

• B.

Alt + F2

• C.

Alt + F3

• D.

Alt + F4

• E.

Alt + F5

D. 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:

• 3.

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

• A.

Mengolah data berupa angka

• B.

Membuat grafik

• C.

Operasi perhitungan matematika

• D.

Operasi statistik

• E.

Mengolah gambar

E. 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.

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

• A.

)

• B.

=

• C.

*

• D.

/

• E.

^

B. =
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:

• 5.

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

• A.

Kiri

• B.

Kanan

• C.

Tengah

• D.

Bawah

• E.

Atas

B. 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:

• 6.

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

• A.

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

• B.

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

• C.

Blok data di sheet 2 > delete

• D.

Blok data di sheet 2 > cut > paste

• E.

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

B. 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:

• 7.

### Untuk menyatakan pangkat, kita menggunakan.....

• A.

*

• B.

/

• C.

• D.

>

• E.

^

E. ^
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:

• 8.

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

• A.

File

• B.

View

• C.

Insert

• D.

Format

• E.

Data

C. 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.

### Perintah untuk memodifikasi lebar kolom adalah….

• A.

Row > width

• B.

Column > width

• C.

Cell > width

• D.

Window > width

• E.

Colors > width

B. 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:

• 10.

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

• A.

Copy paste

• B.

Copy paste special

• C.

Edit > paste

• D.

edit > copy

• E.

Cut > paste

D. 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:

• 11.

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

• A.

Print

• B.

view

• C.

Print preview

• D.

Look

• E.

Minimize

C. 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:

• 12.

### Untuk mencari banyaknya data dari suatu tabel....

• A.

=max

• B.

=min

• C.

=average

• D.

=count

• E.

=sum

D. =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:

• 13.

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

• A.

Column

• B.

Line

• C.

Pie

• D.

Area

• E.

Xy(scatter)

C. 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:

• 14.

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

• A.

data > sort > ascending

• B.

View > header and footer

• C.

Format > cell

• D.

Data > sort > desceding

• E.

Insert > rows

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:

• 15.

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

• A.

Drawin

• B.

Toolbar Standard

• C.

Charter

• D.

Cut

• E.

Chart Wizard

E. 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.

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

• A.

=MAX(L2:LVII)

• B.

=MAX(L2:L7)

• C.

MAX=(L7:12)

• D.

MAX=(L6:L7)

• E.

MAX=(L7:L20)

B. =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:

• 17.

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

• A.

Rows

• B.

• C.

Picture

• D.

Column

• E.

Object

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.

### 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

• A.

=AVERAGE(A3:1)

• B.

=RIGTH9(A3:3)

• C.

=LEFT(A3:4)

• D.

=LEN(A3:2)

• E.

=SUM(A2:C3)

C. =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:

• 19.

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

• A.

12

• B.

36

• C.

38

• D.

48

• E.

62

D. 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:

• 20.

• A.

SUM

• B.

AVERAGE

• C.

LEN

• D.

LENGTH

• E.

COUNT