Ulangan Harian-1 Tik Kls 8 Semester 2 Quiz
Soal Online Ulangan Harian-1 Mata Pelajaran : Teknologi Informasi dan Komunikasi Kelas : VIII (Delapan) Semester : 2 (Dua) Oleh : Rudy DM SMP Negeri 1 Batang www.smp1batang.co.cc
Questions and Answers
- 1.
Selain Microsoft Excel, masih ada beberapa aplikasi pengolah angka yang lain, contohnya adalah ....
- A.
Microsoft Access
- B.
OpenOffice.org Calc
- C.
Word Perfect
- D.
Adobe Reader
Correct Answer
B. OpenOffice.org CalcExplanation
OpenOffice.org Calc is mentioned as an example of another spreadsheet application, along with Microsoft Excel. This suggests that there are multiple options available for processing numbers and data, and OpenOffice.org Calc is one of them.Rate this question:
-
- 2.
Dalam keadaan default (belum diubah) jumlah lembar kerja dalam sebuah workbook Microsoft Excel 2007 adalah ....
- A.
Tidak terbatas
- B.
Dua Sheet
- C.
Tiga Sheet
- D.
Empat Sheet
Correct Answer
C. Tiga SheetExplanation
In the default state, a workbook in Microsoft Excel 2007 contains three sheets. This means that when a new workbook is created, it will have three blank sheets where users can enter and organize their data. These sheets can be used for different purposes or categories within the workbook, allowing users to keep their data organized and easily accessible.Rate this question:
-
- 3.
Workseet Microsoft Excel 2007 terdiri atas kolom dan baris. Jumlah kolom seluruhnya pada sebuah worksheet adalah ... kolom.
- A.
16.384
- B.
254
- C.
65.536
- D.
1.048.576
Correct Answer
A. 16.384Explanation
The correct answer is 16.384. A Microsoft Excel 2007 worksheet consists of columns and rows. The total number of columns in a worksheet is 16.384.Rate this question:
-
- 4.
Sebuah ruangan dalam worksheet Excel yang merupakan perpotongan antara kolom dan baris disebut ....
- A.
Range
- B.
Sheet
- C.
Cell pointer
- D.
Sel
Correct Answer
D. SelExplanation
The correct answer is "sel." In Excel, a "sel" refers to a cell, which is the intersection point of a column and a row in a worksheet. It is the basic unit where data can be entered, edited, and manipulated. A range refers to a group of cells, a sheet refers to a single worksheet within a workbook, and a cell pointer is a cursor that indicates the current active cell.Rate this question:
-
- 5.
Bagian yang dilingkari pada gambar di atas, merupakan suatu tempat untuk menampilkan rumus-rumus dari sebuah sel yang dinamakan ....
- A.
Name Box
- B.
Formula Bar
- C.
Tab Ribbon
- D.
Row Heading
Correct Answer
B. Formula BarExplanation
The circled section in the image is called the Formula Bar. It is where you can view and edit the formulas of a selected cell.Rate this question:
-
- 6.
Nama dan kegunaan ikon di atas adalah untuk ....
- A.
Paste, untuk menempatkan data yang akan disalin/dipindah ke suatu sel/range
- B.
Copy, untuk menyalin data ke sel/range lain
- C.
Format Painter, untuk menyalin format suatu data pada suatu sel/range
- D.
Cut, untuk memindah data ke sel/range lain
Correct Answer
A. Paste, untuk menempatkan data yang akan disalin/dipindah ke suatu sel/rangeExplanation
The correct answer is Paste, untuk menempatkan data yang akan disalin/dipindah ke suatu sel/range. This is because the Paste icon is used to place data that has been copied or moved into a specific cell or range.Rate this question:
-
- 7.
Gambar di atas adalah salah satu komponen pada interface Microsoft Excel yang dinamakan ....
- A.
Title bar
- B.
Office Button
- C.
Quick Access Toolbar
- D.
Tab Menu
Correct Answer
C. Quick Access ToolbarExplanation
The correct answer is Quick Access Toolbar. The given image shows a component in Microsoft Excel that is commonly known as the Quick Access Toolbar. This toolbar provides quick and easy access to commonly used commands and functions in Excel, allowing users to customize it according to their preferences. It is located above the ribbon and can be customized to include frequently used commands for efficient workflow.Rate this question:
-
- 8.
Untuk memindahkan cell pointer langsung menuju ke awal lembar kerja (Sel A1) adalah dengan menekan tombol keyboard ....
- A.
Shit A1
- B.
Ctrl Home
- C.
Shift Home
- D.
Ctl A1
Correct Answer
B. Ctrl HomeExplanation
To move the cell pointer directly to the beginning of the worksheet (cell A1), you can press the keyboard shortcut Ctrl Home. This shortcut helps in quickly navigating to the top-left corner of the worksheet, allowing users to easily access the first cell.Rate this question:
-
- 9.
Jika pada Name Box tertulis H27, artinya adalah bahwa cell pointer terletak pada ....
- A.
Kolom H, baris 27
- B.
Baris H, kolom 27
- C.
Kolom H, baris 2 dan 7
- D.
Baris H, kolom 2 dan 7
Correct Answer
A. Kolom H, baris 27Explanation
The Name Box in Excel displays the reference of the currently selected cell. In this case, the Name Box shows "H27", indicating that the cell pointer is located in column H and row 27.Rate this question:
-
- 10.
Di bawah ini, yang tidak termasuk dalam menu perintah pada Office Button adalah ....
- A.
Save
- B.
Print
- C.
Prepare
- D.
View
Correct Answer
D. ViewExplanation
The correct answer is "View" because the other options (Save, Print, and Prepare) are all commonly found in the menu commands of the Office Button. "View" is not typically included in the Office Button menu commands, as it is usually found in a separate tab or toolbar for adjusting the display settings of the document.Rate this question:
-
- 11.
Untuk mengubah jenis huruf pada Microsoft Excel dijalankan lewat tab menu ....
- A.
Insert
- B.
Home
- C.
Data
- D.
Page Layout
Correct Answer
B. HomeExplanation
The correct answer is "Home" because the Home tab in Microsoft Excel contains various formatting options, including changing the font style. By selecting the text and navigating to the Home tab, users can easily modify the font type, size, and other formatting attributes to suit their preferences.Rate this question:
-
- 12.
Untuk menutup lembar kerja tanpa keluar dari Microsoft Excel 2007 perintahnya adalah klik Office Button, kemudian klik ....
- A.
Close
- B.
Exit
- C.
Quit
- D.
New
Correct Answer
A. CloseExplanation
To close a worksheet without exiting Microsoft Excel 2007, the command is to click on the Office Button and then click on "Close". This option allows the user to close the current worksheet while keeping Excel open, allowing them to continue working on other tasks or open a new worksheet if needed.Rate this question:
-
- 13.
Apabila kita bermaksud akan memformat angka dengan tanda pemisah ribuan, maka bisa dijalankan dengan meng-klik ikon ....
- A.
Currency
- B.
Comma Style
- C.
Percent Style
- D.
Increase Decimal
Correct Answer
B. Comma StyleExplanation
The correct answer is "Comma Style". When we want to format numbers with a thousand separator, we can use the "Comma Style" option. This option adds a comma as a separator for every three digits in the number, making it easier to read and understand large numbers. By selecting this option, we can quickly format the numbers with a thousand separator without having to manually add commas.Rate this question:
-
- 14.
Pada Microsoft Excel, untuk menempatkan judul di tengah diantara beberapa sel dalam satu baris caranya adalah dengan memilih ikon ....
- A.
Merge & Center
- B.
Center
- C.
Align Text Right
- D.
Align Text Left
Correct Answer
A. Merge & CenterExplanation
To place a title in the center between multiple cells in one row in Microsoft Excel, the appropriate icon to use is Merge & Center. This feature combines the selected cells into one cell and centers the text within it.Rate this question:
-
- 15.
Apabila di lembar kerja Excel kita ketikkan data sebagai berikut : 572R Maka data tersebut termasuk data ....
- A.
Numeric
- B.
Date
- C.
Text
- D.
Formula
Correct Answer
C. TextExplanation
The given data "572R" is a combination of numbers and letters, which makes it a text data. In Excel, text data is any combination of letters, numbers, and special characters that are not used in calculations. Therefore, the correct answer is "Text".Rate this question:
-
- 16.
Untuk mengedit isi suatu sel dapat dijalankan dengan menekan tombol fungsi pada keyboard, yaitu ....
- A.
F1
- B.
F2
- C.
F3
- D.
F4
Correct Answer
B. F2Explanation
To edit the content of a cell in a spreadsheet, the F2 function key on the keyboard can be pressed. This key activates the editing mode for the selected cell, allowing the user to modify its contents. The F1 key is typically used for accessing help, while F3 and F4 have different functions in various software applications. Therefore, the correct answer for this question is F2.Rate this question:
-
- 17.
Pada Microsoft Excel, tanda operator untuk perhitungan perkalian adalah ....
- A.
X
- B.
>
- C.
*
- D.
^
Correct Answer
C. *Explanation
The correct answer is "*". In Microsoft Excel, the asterisk symbol (*) is used as the operator for multiplication. This means that when you want to perform a multiplication calculation in Excel, you would use the asterisk symbol between the numbers or cell references that you want to multiply together.Rate this question:
-
- 18.
Jika pada sel D3, D4, D5 masing-masing tertera angka 7000, 2000, dan 3000, serta di sel D6 terdapat rumus: =D3+D4+D5/3 Maka hasil dari perhitungan rumus tersebut adalah ....
- A.
10.000
- B.
12.000
- C.
4.000
- D.
6.000
Correct Answer
A. 10.000Explanation
The formula in cell D6 calculates the average of the numbers in cells D3, D4, and D5. It adds the values in D3, D4, and D5 and then divides the sum by 3. So, the calculation would be (7000 + 2000 + 3000) / 3 = 12000 / 3 = 4000. Therefore, the correct answer is 4000.Rate this question:
-
- 19.
Untuk menjumlahkan angka-angka yang berada pada deretan sel yang panjang, bisa dilakukan dengan penjumlahan otomatis, yaitu dengan memilih perintah ....
- A.
Format
- B.
AutoSum
- C.
Sort & Filter
- D.
Find & Select
Correct Answer
B. AutoSumExplanation
The correct answer is AutoSum because it is a command that allows users to automatically calculate the sum of a range of cells in Microsoft Excel. By selecting the AutoSum command, users can quickly add up a series of numbers without having to manually input the formula. This feature is especially useful when working with large sets of data and helps to save time and reduce the chances of errors in calculations.Rate this question:
-
- 20.
Di bawah ini adalah contoh penulisan rumus yang benar, kecuali ....
- A.
=R46+S58
- B.
=(R46+S58)*P26
- C.
=R46+S58\P26
- D.
=5%*R46+S58-P26
Correct Answer
C. =R46+S58\P26 -
.jpg "Nama dan kegunaan ikon di atas adalah untuk ....")
Back to top