Tes Soal-soal Tik
Selamat mengerjakan
Questions and Answers
- 1.
Program pengolah angka Microsoft Excel diproduksi oleh perusahaan softwere..
- A.
Microsoft Corporation
- B.
PT Adi Sejahtera
- C.
Corel
- D.
Appel
- E.
Delpi
Correct Answer
A. Microsoft CorporationExplanation
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
Correct Answer
D. Alt + F4Explanation
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
Correct Answer
E. Mengolah gambarExplanation
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.
^
Correct Answer
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
Correct Answer
B. KananExplanation
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
Correct Answer
B. Blok data di sheet 2 > cut > buka sheet 3 > klik kanan > pasteExplanation
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.
^
Correct Answer
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
Correct Answer
C. InsertExplanation
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
Correct Answer
B. Column > widthExplanation
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
Correct Answer
D. edit > copyExplanation
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
Correct Answer
C. Print previewExplanation
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
Correct Answer
D. =countExplanation
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)
Correct Answer
C. PieExplanation
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
Correct Answer
A. data > sort > ascendingExplanation
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
Correct Answer
E. Chart WizardExplanation
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)
Correct Answer
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.
Header/Footer
- C.
Picture
- D.
Column
- E.
Object
Correct Answer
B. Header/FooterExplanation
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)
Correct Answer
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
Correct Answer
D. 48Explanation
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.
Function dari ms.exel yang di gunakan untuk menghitung jumblah karakter/teks adalah……
- LENGTH
- LEN
- COUNT
- SUM
- DSUM
- A.
SUM
- B.
AVERAGE
- C.
LEN
- D.
LENGTH
- E.
COUNT
Correct Answer
E. COUNTExplanation
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 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 19, 2023Quiz Edited by
ProProfs Editorial Team -
May 03, 2010Quiz Created by
Sabdaguna
Back to top