Ujian Online Microsoft Excel
"LEMBAGA PENDIDIKAN PELITA NUSANTARA EDUCATION GUIDE CENTER "PENUS EGC" Ujian Online Level pertama Komputer For General
Questions and Answers
- 1.
Berikut ini yang bukan manfaat langsung Ms.Excel adalah
- A.
Mengolah data berupa angka
- B.
Membuat grafik
- C.
Operasi perhitungan matematika
- D.
Mengolah gambar
Correct Answer
D. Mengolah gambarExplanation
Ms.Excel is primarily used for data analysis and manipulation, including numerical data. It is also capable of creating graphs and performing mathematical calculations. However, it does not have the capability to directly process or manipulate images. Therefore, the correct answer is that it cannot process images.Rate this question:
-
- 2.
Apabila kita ingin menuliskan rumus di dalam Ms.Excel, kita harus mengawalinya dengan.....
- A.
(=)
- B.
(+)
- C.
(*)
- D.
(-)
Correct Answer
A. (=)Explanation
When we want to write a formula in Ms.Excel, we must start it with an equals sign (=). This is because the equals sign is used to indicate that what follows is a formula or calculation, and not just a regular text or number entry. By starting with an equals sign, Excel knows to interpret the input as a formula and perform the necessary calculations based on the given formula.Rate this question:
-
- 3.
Di dalam Ms. Excel, penulisan data berupa angka akan secara otomatis berada di.....
- A.
Kiri
- B.
Kanan
- C.
Tengah
- D.
Kanan kiri
Correct Answer
B. KananExplanation
In Ms. Excel, when entering numerical data, it will automatically be aligned to the right side of the cell.Rate this question:
-
- 4.
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
Correct Answer
B. Blok data di sheet 2 > cut > buka sheet 3 > klik kanan > pasteExplanation
To move the data from sheet 2 to sheet 3, the correct way is to select the data in sheet 2 and cut it. Then, open sheet 3 and right-click to paste the data. This ensures that the data is properly transferred from one sheet to another.Rate this question:
-
- 5.
Apabila kita memasukkan data ke dalam Ms.Excel, kemudian secara otomatis data tersebut rata kiri, maka data yang kita masukkan termasuk data....
- A.
Angka
- B.
Teks
- C.
Tanggal
- D.
Statistik
Correct Answer
B. TeksExplanation
Jawaban yang benar adalah "teks" karena jika data yang dimasukkan secara otomatis rata kiri dalam Ms.Excel, maka data tersebut termasuk dalam kategori teks. Dalam Excel, data teks biasanya dianggap sebagai data yang berisi karakter atau kata-kata, bukan angka atau tanggal.Rate this question:
-
- 6.
Dalam Ms.Excel, untuk menuliskan koma atau desimal menggunakan....
- A.
(.)
- B.
(;)
- C.
(:)
- D.
(,)
Correct Answer
D. (,)Explanation
In Ms.Excel, to write a comma or decimal, we use a comma.Rate this question:
-
- 7.
Untuk menyatakan pangkat, kita menggunakan.....
- A.
(
- B.
(/)
- C.
(*)
- D.
(^)
Correct Answer
D. (^)Explanation
To indicate exponentiation or raising a number to a power, we use the caret symbol (^). This symbol is commonly used in mathematical notation to represent the power of a number. For example, 2^3 represents 2 raised to the power of 3, which equals 8.Rate this question:
-
- 8.
Format tanggal 30/12/2008 merupakan format.....
- A.
Japanese
- B.
English
- C.
German
- D.
Indonesian
Correct Answer
D. IndonesianExplanation
The given answer is Indonesian because the format "tanggal 30/12/2008" is written in Indonesian language. In Indonesian, "tanggal" means "date", so the format is indicating a date in the Indonesian language.Rate this question:
-
- 9.
Perintah untuk menyisipkan sel, baris, dan kolom, adalah pada menu…..
- A.
Format
- B.
Edit
- C.
Insert
- D.
Tools
Correct Answer
C. InsertExplanation
The correct answer is "Insert". This is because the question is asking for the command to insert cells, rows, and columns, and the "Insert" menu is the most logical option for this action.Rate this question:
-
- 10.
Perintah untuk memodifikasi lebar kolom adalah….
- A.
Row > width
- B.
Column > width
- C.
Cell > width
- D.
Coluom > width
Correct Answer
B. Column > widthExplanation
The correct answer is "column > width." This is because the command "column > width" is used to modify the width of a column. The other options, "row > width," "cell > width," and "coluom > width" are not valid commands for modifying column width.Rate this question:
-
- 11.
Apabila kita menekan tombol Ctrl+C, sama artinya dengan.....
- A.
Copy > paste
- B.
Copy > paste special
- C.
Edit > paste
- D.
Cut > paste
Correct Answer
A. Copy > pasteExplanation
When we press the Ctrl+C key combination, it is equivalent to the action of copying the selected text or object. This copied content can then be pasted elsewhere using the Ctrl+V key combination. Therefore, the correct answer is "copy > paste".Rate this question:
-
- 12.
Untuk melihat tampilan sebelum diprint, kita dapat menggunakan fasilitas…..
- A.
Print
- B.
View
- C.
Print preview
- D.
Close
Correct Answer
C. Print previewExplanation
The correct answer is "print preview". This feature allows users to see how a document will appear before it is printed. It allows for adjustments to be made, such as formatting or layout changes, to ensure that the final printed version looks as desired.Rate this question:
-
- 13.
Operator matematika yang berarti perkalian adalah.....
- A.
(+)
- B.
(-)
- C.
(*)
- D.
(/)
Correct Answer
C. (*)Explanation
The correct answer is (*). In mathematics, the symbol (*) represents multiplication. It is used to indicate the operation of multiplying two or more numbers together to find their product. For example, 2 * 3 = 6 means that when you multiply 2 by 3, you get the result of 6. Therefore, (*) is the correct symbol for multiplication in mathematics.Rate this question:
-
- 14.
Untuk mencari jumlah data....
- A.
=max
- B.
=min
- C.
=average
- D.
=sum
Correct Answer
D. =sumExplanation
The correct answer is =sum. This is because the question is asking for the sum or total of the data. The sum function in Excel is used to add up a range of numbers and provide the total. Therefore, using the =sum function would allow us to find the total or sum of the data.Rate this question:
-
- 15.
Untuk memilih tipe grafik lingkaran, maka tipe grafik yang kita pilih adalah....
- A.
Coluom
- B.
Line
- C.
Pie
- D.
Area
Correct Answer
C. PieExplanation
The correct answer is "pie" because a pie chart is commonly used to represent data in a circular form, where each category is represented by a slice of the pie. It is particularly useful for showing the proportion or percentage of each category in relation to the whole.Rate this question:
-
- 16.
Untuk mengurutkan data dari A-Z menggunakan.....
- A.
Data > sort > ascending
- B.
View > header and footer
- C.
Format > cell
- D.
Data > sort > desceding
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, starting from A and going up to Z.Rate this question:
-
- 17.
Program (system operasi ) yang dibutuhkan untuk mengoperasikan program Excel adalah....
- A.
Windows
- B.
Disk Operating System
- C.
Power Point
- D.
Linux
Correct Answer
A. WindowsExplanation
The correct answer is Windows because Excel is a Microsoft Office program and it is designed to run on the Windows operating system. Windows provides the necessary platform and compatibility for Excel to function properly.Rate this question:
-
- 18.
Ikon yang digunakan untuk pembuatan grafik adalah.....
- A.
Open
- B.
Toolbar Standard
- C.
Charter
- D.
Chart Wizard
Correct Answer
D. Chart WizardExplanation
The correct answer is Chart Wizard. The Chart Wizard is a tool used for creating charts and graphs in various software applications, such as Microsoft Excel. It provides a step-by-step process for selecting the data to be included in the chart, choosing the chart type, customizing the appearance and layout of the chart, and adding titles and labels. The Chart Wizard helps users easily create professional-looking charts without the need for advanced design or programming skills.Rate this question:
-
- 19.
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)
Correct Answer
B. =MAX(L2:L7)Explanation
The correct answer is =MAX(L2:L7). This formula is used to find the maximum value within the range of cells from L2 to L7. It will compare all the values in the range and return the highest value.Rate this question:
-
- 20.
Dari instruksi-instruksi berikut, yang bukan termasuk instruksi-instruksi dalam menu insert yaitu......
- A.
Rows
- B.
Header/Footer
- C.
Picture
- D.
Coluom
Correct Answer
B. Header/FooterExplanation
The question is asking for the instruction that is not included in the insert menu. The options given are Rows, Header/Footer, Picture, and Column. Among these options, Header/Footer is the correct answer because it is not a part of the insert menu.Rate this question:
-
- 21.
Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu :
- A.
Tabel
- B.
Data
- C.
Grafik
- D.
Rumus
Correct Answer
A. TabelExplanation
Vlookup dan Hlookup adalah fungsi yang digunakan untuk mencari dan membaca data dalam suatu tabel. Fungsi Vlookup digunakan untuk mencari nilai dalam kolom pertama tabel dan mengembalikan nilai yang sesuai dari kolom lainnya, sedangkan fungsi Hlookup digunakan untuk mencari nilai dalam baris pertama tabel dan mengembalikan nilai yang sesuai dari baris lainnya. Dengan menggunakan fungsi ini, pengguna dapat dengan mudah mengambil data yang dibutuhkan dari tabel dengan cepat dan akurat.Rate this question:
-
- 22.
Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
A. LeftExplanation
The correct answer is "Left." This function is used to extract a specified number of characters from the left side of a text string.Rate this question:
-
- 23.
Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
B. RightExplanation
The correct answer is "Right". The "Right" function is used to extract a specified number of characters from the right side of a text string. It is commonly used when you need to retrieve the last few characters from a string or extract a specific portion of a text from the right side.Rate this question:
-
- 24.
Fungsi yang digunakan untuk mengambil beberapa karakter di tengah-tengah data teks
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
C. MidExplanation
Mid is the correct answer because it is a function used to extract a specified number of characters from a text string, starting at a specified position. It allows us to retrieve a substring from the middle of a text string by specifying the starting position and the number of characters to extract.Rate this question:
-
- 25.
Yang disebut fungsi logika di bawah ini adalah
- A.
If
- B.
Sumif
- C.
Logif
- D.
Countif
Correct Answer
A. IfExplanation
The term "fungsi logika" refers to logical functions in Indonesian. Among the options given, "If" is the correct answer as it is a logical function used in programming and spreadsheet applications to perform conditional operations. It allows for the execution of different actions based on whether a specific condition is true or false.Rate this question:
-
- 26.
Perintah open dapat dijalankan dari menu file dan tombol open di toolbar standar.selain itu, perintah open dapat juga dijalankan dengan menekan tombol…dikeyboard.
- A.
Ctrl V
- B.
Ctrl O
- C.
Ctrl U
- D.
Ctrl B
Correct Answer
B. Ctrl OExplanation
The correct answer is ctrl O. The explanation is that the command "open" can be executed by pressing the ctrl key and the letter O on the keyboard.Rate this question:
-
- 27.
Yang bukan termasuk grafik pada Microsoft excel adalah
- A.
Sumbu
- B.
Column
- C.
Bar
- D.
Line
Correct Answer
A. SumbuExplanation
The correct answer is "sumbu." In Microsoft Excel, the graph types mentioned, such as column, bar, and line, are all types of charts that can be created using data. However, "sumbu" is not a graph type in Excel. It is the Indonesian word for "axis," which is a component of a graph rather than a type of graph itself.Rate this question:
-
- 28.
Microsoft Excel merupakan program aplikasi
- A.
Spreadsheet
- B.
Wordprosesor
- C.
Presentation
- D.
Animasi
Correct Answer
A. SpreadsheetExplanation
Microsoft Excel is a program application that is specifically designed for creating and managing spreadsheets. It allows users to input and analyze data, perform calculations, create charts and graphs, and organize information in a tabular format. Excel is widely used in various industries and professions for tasks such as budgeting, financial analysis, data tracking, and project management. It is known for its powerful features and functions that make it a versatile tool for data manipulation and analysis.Rate this question:
-
- 29.
Perintah untuk menyimpan lembar kerja excel dengan menekan tombol
- A.
Ctrl S
- B.
Ctrl N
- C.
Ctrl V
- D.
Ctrl A
Correct Answer
A. Ctrl SExplanation
The correct answer is Ctrl S. This keyboard shortcut is commonly used to save a document or file in various software applications, including Excel. By pressing Ctrl S, the user can quickly save their Excel worksheet without having to navigate through the menus or use the mouse. This shortcut is efficient and time-saving, making it a popular choice for saving work in Excel.Rate this question:
-
- 30.
Berikut ini adalah file yang dihasilkan oleh program Ms. Office. File berikut yang dihasilkan oleh Excel adalah….
- A.
LATIH.DOC
- B.
LATIH.XLS
- C.
LATIH.PPT
- D.
LATIH.MDB
Correct Answer
B. LATIH.XLSExplanation
The correct answer is "LATIH.XLS" because the question states that the file is generated by the program Ms. Office, and Excel is a program within the Ms. Office suite that is used for creating spreadsheets. Therefore, it is logical to conclude that the file generated by Excel would have the .XLS file extension.Rate this question:
-
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020
Back to top