Ulangan Harian 1 Semester 2 Tik
- 1.
Untuk mengolah data-data/angka, pembuatan tabel atau diagram akan lebih mudah jika menggunakan program ...
- A.
Microsoft Word
- B.
Microsoft Excel
- C.
Microsoft Power Point
- D.
Microsoft Access
Correct Answer
B. Microsoft ExcelExplanation
Microsoft Excel is the correct answer because it is a program specifically designed for data processing and analysis. It provides tools and functions for creating tables, performing calculations, and generating charts and graphs. Microsoft Word is a word processing program, Microsoft Power Point is a presentation program, and Microsoft Access is a database management program, which are not as suitable for processing numerical data as Microsoft Excel.Rate this question:
-
- 2.
Salah satu program pengolah angka selain Microsoft Excel yang sudah mulai banyak digunakan yang bersifat bebas lisensi (freeware) adalah...
- A.
Mozilla Firefox
- B.
Google Chrome
- C.
Open Office Calc
- D.
Microsoft Access
Correct Answer
C. Open Office CalcExplanation
Open Office Calc is a free and open-source spreadsheet program that is commonly used as an alternative to Microsoft Excel. It offers similar features and functionality, allowing users to create and manipulate spreadsheets, perform calculations, and analyze data. As it is freeware, it can be downloaded and used without any licensing fees, making it a popular choice for individuals and organizations looking for a cost-effective solution for their spreadsheet needs.Rate this question:
-
- 3.
Berkas lembar kerja dalam MS Excel disebut sebagai buku kerja (Workbook). Biasanya lembar kerja yang baru dibuat diberi nama ...
- A.
Document1
- B.
Book1
- C.
Database1
- D.
Presentation1
Correct Answer
B. Book1Explanation
The correct answer is "Book1" because in MS Excel, a workbook refers to a file that contains multiple worksheets. When creating a new workbook, it is usually given a default name such as "Book1" until the user decides to rename it. Therefore, "Book1" is the most appropriate choice among the given options.Rate this question:
-
- 4.
Buku Kerja (Workbook) terdiri dari banyak lembar kerja (worksheets/sheets). Secara default atau standart MS Excel menampilkan beberapa sheet pada buku kerja anda, yaitu...
- A.
Sheet1 dan Sheet2
- B.
Sheet1, Sheet2, dan Sheet3
- C.
Sheet1, Sheet2, Sheet3, dan Sheet4
- D.
Sheet1, Sheet2, Sheet3, Sheet4, dan Sheet5
Correct Answer
B. Sheet1, Sheet2, dan Sheet3Explanation
The correct answer is Sheet1, Sheet2, dan Sheet3. MS Excel by default displays three sheets in a workbook.Rate this question:
-
- 5.
Pada lembar kerja MS Excel terdapat baris dan kolom. Pertemuan antara baris dan kolom disebut juga dengan ...
- A.
Sel
- B.
Range
- C.
Row
- D.
Column
Correct Answer
A. SelExplanation
The correct answer is "Sel". In MS Excel, a cell is the intersection point between a row and a column. It is the basic unit of data storage in a worksheet. Therefore, the meeting point between a row and a column is referred to as a "Sel" or a cell.Rate this question:
-
- 6.
Gabungan dari beberapa sel atau sekelompok sel disebut ...
- A.
Sheet
- B.
Sel
- C.
Row
- D.
Range
Correct Answer
D. RangeExplanation
Gabungan dari beberapa sel atau sekelompok sel disebut range. Range merupakan istilah yang digunakan untuk merujuk pada kumpulan sel yang terletak dalam area tertentu di dalam spreadsheet. Dalam range, kita dapat melakukan operasi atau manipulasi data secara bersamaan pada sel-sel yang termasuk dalam range tersebut.Rate this question:
-
- 7.
Kolom pada lembar kerja Ms Excel ditunjukkan dengan ...
- A.
A, B,C, dan seterusnya
- B.
1,2,3, dan seterusnya
- C.
I,II,III, dan seterusnya
- D.
A1, A2,A3, dan seterusnya
Correct Answer
A. A, B,C, dan seterusnyaExplanation
Kolom pada lembar kerja Ms Excel ditunjukkan dengan huruf-huruf A, B, C, dan seterusnya.Rate this question:
-
- 8.
Baris pada lembar kerja Ms Excel ditunjukkan dengan ...
- A.
A, B,C, dan seterusnya
- B.
1,2,3, dan seterusnya
- C.
I,II,III, dan seterusnya
- D.
A1, A2,A3, dan seterusnya
Correct Answer
B. 1,2,3, dan seterusnyaExplanation
The correct answer is 1,2,3, dan seterusnya. In Microsoft Excel, rows are labeled with numbers starting from 1 and continuing in sequential order. Therefore, the baris (rows) on the worksheet are represented by numbers 1, 2, 3, and so on.Rate this question:
-
- 9.
Sel aktif berada di B10. B10 artinya ...
- A.
Sel B, Baris 10
- B.
Baris B, Kolom 10
- C.
Kolom B, Baris 10
- D.
Kolom B, Sel 10
Correct Answer
C. Kolom B, Baris 10Explanation
The correct answer is "Kolom B, Baris 10." This is because the question is asking for the meaning of "B10" and in the given options, "Kolom B, Baris 10" is the only one that corresponds to the given notation. "B10" refers to column B and row 10.Rate this question:
-
- 10.
Langkah yang benar untuk menjalankan program Microsoft Excel 2007 yaitu...
- A.
Start>Control Panel>Microsoft Office >Microsoft Office Excel 2007
- B.
Start>All Document>Microsoft Office >Microsoft Office Excel 2007
- C.
Start>All Program>Microsoft Office >Microsoft Office Excel 2007
- D.
Start>Office Button>Microsoft Office >Microsoft Office Excel 2007
Correct Answer
C. Start>All Program>Microsoft Office >Microsoft Office Excel 2007Explanation
The correct answer is "Start>All Program>Microsoft Office >Microsoft Office Excel 2007". This is the correct sequence of steps to follow in order to run Microsoft Excel 2007. Starting from the Start menu, the user needs to navigate to the "All Programs" section and then find the Microsoft Office folder. Within this folder, they can locate and select Microsoft Office Excel 2007 to launch the program.Rate this question:
-
- 11.
Pada microsoft Excel 2007 ketika Office button diklik muncul menu pilihan berikut, kecuali...
- A.
New
- B.
Open
- C.
Cut
- D.
Save
Correct Answer
C. CutExplanation
When the Office button is clicked in Microsoft Excel 2007, a menu with the options "New," "Open," "Save," and "Cut" appears. The word "except" in the question suggests that one of these options does not appear in the menu. Therefore, the correct answer is "Cut" because it is the only option listed that does not appear in the menu when the Office button is clicked.Rate this question:
-
- 12.
Bagian dari Ms Excel yang terletak di atas dan berfungsi untuk menampilkan nama buku kerja dan informasi lainya disebut ...
- A.
Office Button
- B.
Quick Acces Toolbar
- C.
Title Bar
- D.
Ribbon
Correct Answer
C. Title BarExplanation
The title bar in Ms Excel is located at the top of the application window and displays the name of the workbook and other information. It provides a quick reference for users to identify the current workbook they are working on. The title bar also includes buttons for minimizing, maximizing, and closing the application window.Rate this question:
-
- 13.
Bagian dari lembar kerja MS Excel yang vertikal/tegak dan disimbolkan dengan huruf disebut ...
- A.
Kolom
- B.
Baris
- C.
Sel
- D.
Range
Correct Answer
A. KolomExplanation
Kolom adalah bagian dari lembar kerja MS Excel yang terdiri dari sel-sel yang berjajar secara vertikal. Setiap kolom diberi simbol dengan menggunakan huruf, seperti kolom A, kolom B, dan seterusnya. Dalam kolom, kita dapat memasukkan data atau formula ke dalam sel-sel yang ada.Rate this question:
-
- 14.
Bagian dari lembar kerja Ms Excel yang horisontal/mendatar dan disimbolkan dengan angka disebut ...
- A.
Kolom
- B.
Baris
- C.
Sel
- D.
Range
Correct Answer
B. BarisExplanation
The horizontal part of an Excel worksheet that is symbolized by numbers is called "Baris" or rows. In Excel, data is organized in a grid format with columns represented by letters and rows represented by numbers. Each row contains a set of cells that can store data or formulas. Therefore, the correct answer for this question is "Baris".Rate this question:
-
- 15.
Pada Ribbon Ms Excel terdapat 7 tab utama yaitu...
- A.
Home, Insert, Page Layout, Reference, mailing, Review, dan View
- B.
Home, Insert, Page Layout, Formula, Data, Review, dan View
- C.
Home, Insert, Page Layout, Formula, Data, Clipboard, dan Font
- D.
Home, Insert, Page Layout, Formula, Data, Clip Art, dan Shape
Correct Answer
B. Home, Insert, Page Layout, Formula, Data, Review, dan ViewExplanation
The correct answer is Home, Insert, Page Layout, Formula, Data, Review, and View.Rate this question:
-
- 16.
Gambar icon perintah tersebut terletak di Tab Home, Grup ...
- A.
Font
- B.
Clipboard
- C.
Paragraph
- D.
Style
Correct Answer
B. ClipboardExplanation
The correct answer is Clipboard because the question states that the command icon is located in the "Tab Home, Grup..." and the only option that fits this description is Clipboard.Rate this question:
-
- 17.
Gambar Ikon perintah di atas terletak di Tab Home, Grup ....
- A.
Clipboard
- B.
Font
- C.
Alignment
- D.
Number
Correct Answer
B. FontExplanation
The given correct answer is "Font". The question states that the command icon image is located in the Home tab, and it is asking which group it belongs to. Based on common knowledge of software interfaces, the Font group is commonly found in the Home tab of various applications, including word processors and graphic design software. Therefore, it can be inferred that the correct answer is "Font".Rate this question:
-
- 18.
Gambar tersebut berada di tab home dan kelompok/grup ...
- A.
Clipboard
- B.
Font
- C.
Alignment
- D.
Number
Correct Answer
D. NumberExplanation
The correct answer is "Number" because the question states that the image is located in the home tab and the group or category is related to numbering. This suggests that the image is likely showing options or tools for formatting or manipulating numbered lists.Rate this question:
-
- 19.
Langkah untuk membuat lembar kerja baru di MS Excel 2007 yaitu dengan cara klik Office Button>New> Blank Workbook>Create atau klik ikon ..... di Quick Access Toolbar.
- A.
![Ulangan Harian 1 Semester 2 Tik - Quiz]()
- B.
![Ulangan Harian 1 Semester 2 Tik - Quiz]()
- C.
![Ulangan Harian 1 Semester 2 Tik - Quiz]()
- D.
![Ulangan Harian 1 Semester 2 Tik - Quiz]()
Correct Answer
A.Explanation
The correct answer is "File". This is because in MS Excel 2007, to create a new worksheet, you need to click on the Office Button, then select "New", and then choose "Blank Workbook" from the options. Alternatively, you can also click on the "File" icon in the Quick Access Toolbar to create a new worksheet.Rate this question:
-
- 20.
Sel-sel yang termasuk data label adalah ...
- A.
B3, B4, B5, B6, B7
- B.
C3, C4, C5, C6, C7
- C.
B2, C2, D2, E2, F2
- D.
F3, F4, F5, F6, F7
Correct Answer
C. B2, C2, D2, E2, F2Explanation
The correct answer is B2, C2, D2, E2, F2. These cells are included in the data label because they are located in the second row of the table. The data label typically refers to the row or column headers that provide a description or label for the data in the table. In this case, the cells B2, C2, D2, E2, and F2 contain the labels for the data in the table.Rate this question:
-
- 21.
Sel-sel yang termasuk data angka adalah ...
- A.
B3, B4, B5, B6, B7
- B.
C3, C4, C5, C6, C7
- C.
B2, C2, D2, E2, F2
- D.
F3, F4, F5, F6, F7
Correct Answer
A. B3, B4, B5, B6, B7Explanation
The given answer includes the cells B3, B4, B5, B6, and B7. These cells are considered to be "data angka" or numerical data cells.Rate this question:
-
- 22.
Sel-sel yang termasuk data Rumus adalah...
- A.
B3, B4, B5, B6, B7
- B.
C3, C4, C5, C6, C7
- C.
B2, C2, D2, E2, F2
- D.
F3, F4, F5, F6, F7
Correct Answer
D. F3, F4, F5, F6, F7Explanation
The cells F3, F4, F5, F6, and F7 are included in the data range "Rumus".Rate this question:
-
- 23.
Rumus untuk mencari nilai TOTAL HARGA pada sel F4 adalah ...
- A.
=F3*E3
- B.
=D3*E3
- C.
=D4*E4
- D.
=B4*E4
Correct Answer
C. =D4*E4Explanation
The correct answer is =D4*E4. This formula is used to calculate the total price by multiplying the value in cell D4 with the value in cell E4. This formula assumes that the total price is determined by multiplying the quantity (D4) with the price per unit (E4).Rate this question:
-
- 24.
Untuk memberi garis pada tabel yang baru dibuat, kita blok terlebih dahulu tabelnya, lalu klik ikon ...
- A.
Bold
- B.
Border>All Border
- C.
Merge And Center
- D.
Align Text Left
Correct Answer
B. Border>All BorderExplanation
To give a border to a newly created table, we need to first select the table by blocking it. Then, we can click on the "Border" option and choose "All Border" from the available border styles. This will apply a border to all sides of the table, giving it a complete border.Rate this question:
-
- 25.
Apa bedanya Save dengan Save As?
- A.
Save untuk menyimpan pembaharuan tanpa mengganti nama file dan Save As untuk menyimpan buku kerja dengan nama file baru.
- B.
Save untuk menyimpan buku kerja dengan nama file baru dan Save as untuk menyimpan pembaharuan tanpa mengganti nama file.
- C.
Save untuk menyimpan buku kerja baru dan Save as untuk menyimpan buku kerja lama.
- D.
Save untuk menyimpan dokumen Ms Word dan Save As untuk menyimpan dokumen Ms Excel
Correct Answer
A. Save untuk menyimpan pembaharuan tanpa mengganti nama file dan Save As untuk menyimpan buku kerja dengan nama file baru.Explanation
The correct answer explains that "Save" is used to save updates without changing the file name, while "Save As" is used to save the workbook with a new file name. This means that "Save" is used when you want to save changes to an existing file, while "Save As" is used when you want to create a new file or save changes to a different file.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 14, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 05, 2017Quiz Created by
Slamail.now
Back to top