Kelas Xi Semester 2: MS. Excel
- 1.
Dalam kehidupan sehari hari kita sering menggunakan beberapa program aplikasi salah satunya adalah Microsoft Excel yang merupakan program aplikasi....
- A.
Wordprosesor
- B.
Presentation
- C.
Spreedsheet
- D.
Animasi
- E.
Database
Correct Answer
C. SpreedsheetExplanation
Microsoft Excel is a program application that is commonly used in daily life for various purposes. One of its main functions is to create and manage spreadsheets, which allows users to organize and analyze data in a tabular format. Spreadsheets are commonly used for tasks such as budgeting, financial analysis, data tracking, and creating charts and graphs. Therefore, the correct answer is "Spreedsheet."Rate this question:
-
- 2.
Range adalah …
- A.
Pertemuan antara baris dan kolom
- B.
Pertemuan beberapa sel yang berbentuk persegi panjang
- C.
Pertemuan antara kolom
- D.
Pertemuan antara worksheet
- E.
Pertemuan beberapa sel dalam satu worksheet
Correct Answer
B. Pertemuan beberapa sel yang berbentuk persegi panjangExplanation
The correct answer is "Pertemuan beberapa sel yang berbentuk persegi panjang." This answer suggests that a range refers to the intersection of multiple rectangular-shaped cells in a worksheet. A range can be a group of cells selected together to perform a specific operation or to apply formatting changes.Rate this question:
-
- 3.
Yang merupakan fungsi dari submenu print preview adalah .…
- A.
Untuk mengatur setting halaman
- B.
Untuk mengatur header dan footer
- C.
Untuk menentukan orientasi halaman
- D.
Untuk mencetak halaman
- E.
Untuk melihat tampilan sebelum dicetak
Correct Answer
E. Untuk melihat tampilan sebelum dicetakExplanation
The correct answer is "Untuk melihat tampilan sebelum dicetak" which translates to "To preview the printout before printing". This means that the submenu "print preview" allows the user to see how the document will look like when it is printed, enabling them to make any necessary adjustments or corrections before actually printing it.Rate this question:
-
- 4.
Jika dokumen sudah tampil secara restore, untuk menampilkan ke bentuk normal maka perintahnya ....
- A.
Maximum
- B.
Minimum
- C.
Close
- D.
Restore
- E.
Exit
Correct Answer
B. MinimumExplanation
To display the document in its normal form after it has been restored, the command to use is "Minimum".Rate this question:
-
- 5.
Untuk mengatur tinggi baris table menggunakan perintah....
- A.
Format, wide, height
- B.
Format, coloum, autoselection
- C.
Format, row, autoselection
- D.
Format , coloum, top
- E.
Format, row, height
Correct Answer
E. Format, row, heightExplanation
The correct answer is "format, row, height". This is because to adjust the row height in a table, we use the "format" command, followed by specifying "row" as the element we want to format, and then setting the desired "height" for the row.Rate this question:
-
- 6.
Untuk mengubah nama sheet 2 menjadi ulangan, perintahnya adalah …
- A.
Klik menu file, kemudian pilih dan klik properties, kemudian ketik ulangan, OK
- B.
Klik kanan pada tab sheet 2, pilih dan klik rename, kemudian ketik ulangan, OK
- C.
Klik menu edit, kemudian pilih dan klik properties, kemudian ketik ulangan, OK
- D.
Klik kanan pada tab sheet 2, pilih dan klik insert, kemudian ketik ulangan, OK.
- E.
Klik kiri pada tab sheet 2, pilih dan klik rename, kemudian ketik ulangan, OK
Correct Answer
B. Klik kanan pada tab sheet 2, pilih dan klik rename, kemudian ketik ulangan, OKExplanation
To change the name of sheet 2 to "ulangan", the correct command is to right-click on the tab for sheet 2, select and click on "rename", then type "ulangan" and click "OK".Rate this question:
-
- 7.
Bagaimana cara menghilangkan gridlines atau garis bantu pada MS. Excel …
- A.
Klik menu tools | option | klik tab general | centrang gridlines
- B.
Klik menu table | option | klik tab view | centrang gridlines
- C.
Klik menu tools | option | klik tab view | centrang gridlines
- D.
Klik menu table | option | klik tab view | centrang gridlines
- E.
Klik menu tools | properties | klik tab view | centrang gridlines
Correct Answer
C. Klik menu tools | option | klik tab view | centrang gridlinesExplanation
To remove gridlines in MS Excel, you need to click on the "Tools" menu, then select "Options". In the "Options" window, go to the "View" tab and uncheck the "Gridlines" option. This will remove the gridlines from the Excel sheet.Rate this question:
-
- 8.
Untuk mengatur ukuran margins, jenis kertas, perintah ada pada menu ...
- A.
File
- B.
Edit
- C.
Format
- D.
Insert
- E.
Help
Correct Answer
A. FileExplanation
The correct answer is "File" because the menu options listed are commonly found in software applications, and "File" is typically the menu where options related to document settings, such as page margins and paper size, are located.Rate this question:
-
- 9.
Bagaimana cara untuk menampilkan halaman worksheet excel didalam web browser …
- A.
Edit | web page preview
- B.
Edit | save as web page
- C.
File | web page preview
- D.
File | save as web page
- E.
File | save as
Correct Answer
D. File | save as web pageExplanation
The correct answer is "File | save as web page". This option allows you to save an Excel worksheet as a web page, which can then be displayed in a web browser. By selecting this option, you can convert the Excel file into a format that is compatible with web browsers, making it easier to share and view the worksheet online.Rate this question:
-
- 10.
Untuk menampilkan batas halaman sehingga dilayar tampil PAGE 1, PAGE 2 dan seterusnya. Perintah yang digunakan adalah…
- A.
Page break preview
- B.
Page break
- C.
Page show
- D.
Page edit
- E.
Page setup
Correct Answer
B. Page breakExplanation
The correct answer is "Page break". This command is used to display page boundaries on the screen, allowing the user to see where each page begins and ends. It is commonly used when formatting a document or preparing it for printing, as it helps ensure that content is properly distributed across pages. By inserting page breaks, the user can control how the document is divided into separate pages and can easily navigate through them.Rate this question:
-
- 11.
Tampilan gambar dibawah ini merupakan…
- A.
Menu pokok
- B.
Menu toolbar
- C.
Pull down menu
- D.
Menu cascading
- E.
Submenu
Correct Answer
B. Menu toolbarExplanation
The correct answer is "Menu toolbar." The given image represents a toolbar, which is a graphical control element on a computer screen that contains buttons or icons that allow users to perform specific actions or access certain functions. It is usually located at the top of a window or application and provides quick access to commonly used features or commands.Rate this question:
-
- 12.
Tampilan gambar dibawah ini merupakan…
- A.
Menu pokok
- B.
Menu pull down insert
- C.
Menu pull down format
- D.
Menu cascading insert
- E.
Menu pop up format
Correct Answer
B. Menu pull down insertExplanation
The given image represents a pull-down menu for inserting options. This type of menu is typically found in software applications and allows users to access various options for inserting different elements or objects into a document or interface. The pull-down feature allows for a compact and organized display of options, making it easier for users to navigate and select the desired option.Rate this question:
-
- 13.
Untuk menampilkan tanda mata uang yang seperti pada gambar, digunakan format …
- A.
Number
- B.
Currency
- C.
Date
- D.
Accounting
- E.
General
Correct Answer
D. AccountingExplanation
The correct answer is "Accounting" because this format is specifically used to display currency symbols. The Accounting format is designed to align currency symbols and decimal points in a column, making it easier to read and compare monetary values. This format is commonly used in financial statements and reports where accuracy and consistency in displaying currency symbols are crucial.Rate this question:
-
- 14.
Perhatikan gambar berikut, apa yang terjadi dengan cel B4 dan C4 …
- A.
Salah dalam memformat
- B.
Kolom kurang lebar
- C.
Baris kurang tinggi
- D.
Salah dalam memasukkan data
- E.
Jenis datanya salah
Correct Answer
C. Baris kurang tinggiExplanation
The explanation for the correct answer "Baris kurang tinggi" is that the row height of B4 and C4 is not sufficient to display the content properly. This means that the text in those cells may be cut off or not fully visible. To fix this issue, the row height needs to be increased to accommodate the content in those cells.Rate this question:
-
- 15.
Bagaimana cara memformat isi cell agar miring seperti pada baris 3 dan 4…
- A.
Dengan menggunakan format text
- B.
Dengan menggunakan format number
- C.
Dengan menggunakan format alignment pada bagian text alignment
- D.
Dengan menggunakan format alignment pada bagian text control
- E.
Dengan menggunakan format alignment pada bagian orientasi
Correct Answer
E. Dengan menggunakan format alignment pada bagian orientasiExplanation
The correct answer suggests that to format the content of a cell to be italicized like in rows 3 and 4, one should use the alignment format in the orientation section. This means that by adjusting the orientation of the text in the cell, it can be formatted to appear slanted or italicized.Rate this question:
-
- 16.
Dibawah ini merupakan ...
- A.
Drawing
- B.
Border
- C.
Formatting
- D.
Outlining
- E.
Standar
Correct Answer
B. BorderExplanation
The given correct answer is "Border". This suggests that the question is asking for a term that is related to drawing a border. Out of the options provided, "Border" is the most appropriate term as it directly relates to creating a border around an object or element in a design or document.Rate this question:
-
- 17.
Apa yang terjadi pada sel yang terlihat tanda #?
- A.
Salah dalam memformat
- B.
Baris kurang tinggi
- C.
Kolom kurang lebar
- D.
Salah dalam memasukkan data
- E.
Salah dalam memasukkan rumus
Correct Answer
C. Kolom kurang lebarExplanation
The correct answer is "Kolom kurang lebar" which means "Column is too narrow" in English. This suggests that the issue with the cell marked with "#" is that the column width is not wide enough to display the entire content of the cell.Rate this question:
-
- 18.
Lembar kerja yang sedang aktif adalah ....
- A.
Beli
- B.
Stock
- C.
Jual
- D.
Daftar Harga
- E.
C5
Correct Answer
B. StockExplanation
The correct answer is "Stock" because the question is asking for the active worksheet, and "Stock" is the only option that can be an active worksheet. The other options are unrelated to worksheets or could potentially be worksheets, but without further context, it is not possible to determine if they are active or not.Rate this question:
-
- 19.
Sel yang sedang aktif berisi data ....
- A.
########
- B.
340000
- C.
1250000
- D.
Angka lebih dari 6 digit
- E.
Tidak ada data
Correct Answer
C. 1250000Explanation
The answer 1250000 is the correct choice because it is the only option that matches the given description "Angka lebih dari 6 digit" (Number more than 6 digits). The other options, 340000 and Tidak ada data, do not meet this criteria.Rate this question:
-
- 20.
Alamat sel yang sedang aktif adalah....
- A.
C4
- B.
C5
- C.
C21
- D.
C39
- E.
C2
Correct Answer
C. C21Explanation
The correct answer is C21. This indicates that cell C21 is the active cell.Rate this question:
-
- 21.
Suatu formula tertulis $A1, artinya ....
- A.
Data tersebut absolut terhadap baris
- B.
Data tersebut absolut terhadap kolom
- C.
Data tersebut absolut terhadap baris dan kolom
- D.
Data tersebut tidak absolut
- E.
Data tersebut bebas dicopy
Correct Answer
B. Data tersebut absolut terhadap kolomExplanation
The correct answer is "Data tersebut absolut terhadap kolom." This means that the formula in cell A1 is fixed or absolute with respect to the column. This means that if the formula is copied or dragged to other cells horizontally, the column reference in the formula will not change. Only the row reference will change if the formula is copied or dragged vertically.Rate this question:
-
- 22.
Formula untuk mencari nilai 58 pada data diatas adalah ….
- A.
=LEFT(B11;2)
- B.
=MID(B11;2;4)
- C.
=LEFT(B11;4)
- D.
=MID(B11;3;2)
- E.
=MID(B11;4;2)
Correct Answer
E. =MID(B11;4;2)Explanation
The correct answer is =MID(B11;4;2). This formula uses the MID function to extract a portion of the text in cell B11. It starts at the 4th character and includes the next 2 characters, resulting in the value "58".Rate this question:
-
- 23.
Jika pada sel C12 dituliskan =RIGHT(B12;4) maka akan menghasilkan ....
- A.
GA/9
- B.
GA98
- C.
8D10
- D.
/D10
- E.
98D1
Correct Answer
D. /D10Explanation
The function =RIGHT(B12;4) extracts the rightmost 4 characters from the text in cell B12. In this case, the text in cell B12 is "/D10". Therefore, the correct answer is "/D10".Rate this question:
-
- 24.
Untuk membuat grafik batang, type yang dipilih adalah….
- A.
Stick
- B.
Line
- C.
Column
- D.
Area
- E.
XY
Correct Answer
C. ColumnExplanation
The correct answer is "Column". Column charts are used to compare quantities or show changes over time. They are vertical bars that represent different categories or groups. Each bar's height represents the value or quantity being measured. In this case, to create a bar chart, the column type is selected.Rate this question:
-
- 25.
Pada grafik Pie, data yang dibutuhkan adalah ….
- A.
Kolom atau baris
- B.
Dua kolom dan satu baris
- C.
Dua baris dan satu kolom
- D.
Dua kolom atau baris
- E.
Bebas
Correct Answer
D. Dua kolom atau barisExplanation
The correct answer is "Dua kolom atau baris" which means "Two columns or rows" in English. In a pie chart, the data required can be represented using either two columns or two rows. This means that the data can be organized and presented in either a vertical or horizontal manner. Both options are valid for displaying the necessary information in a pie chart.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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Mar 09, 2009Quiz Created by
Ddsisme
Back to top