# Ulangan Harian Tik Kelas 9 Mts Negeri 7 Kuningan

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
Learn about Our Editorial Process
| Written by Abiyan
A
Abiyan
Community Contributor
Quizzes Created: 1 | Total Attempts: 343
Questions: 21 | Attempts: 343

Settings

Silahkan kerjakan soal berikut ini dengan memilih salah satu jawaban yang benar yang telah disediakan

• 1.

### Suatu daerah pada worksheet yang berbentuk segi empat dan merupakan tempat kumpulan beberapa sel disebut ….

• A.

Sheet

• B.

Range

• C.

Pointer

• D.

Column

B. Range
Explanation
A range is a rectangular area on a worksheet that contains a collection of cells. It can be used to perform various operations on the group of cells, such as formatting, calculations, and data manipulation. In this context, a range is being referred to as a "daerah pada worksheet yang berbentuk segi empat dan merupakan tempat kumpulan beberapa sel" which translates to "a rectangular area on a worksheet that is a collection of several cells".

Rate this question:

• 2.

### Tombol manajemen berkas dokumen pada Microsof Office Excel berbentuk bulat dengan logo Office di tengahnya disebut .…

• A.

Excel Options

• B.

Ribbon

• C.

Tilte Bar

• D.

Office Button

D. Office Button
Explanation
The correct answer is "Office Button". The Office Button in Microsoft Office Excel is a round button with the Office logo in the center. It is located in the top left corner of the Excel window and provides access to various file management options such as opening, saving, and printing files. It also allows users to access the Excel Options menu where they can customize the program's settings.

Rate this question:

• 3.

### Berikut ini yang merupakan alamat sel, yaitu .…

• A.

84

• B.

B5

• C.

3F

• D.

F0

B. B5
Explanation
The given answer "B5" is a hexadecimal value that represents an address in a computer's memory. In computer systems, memory is divided into cells, and each cell has a unique address. The hexadecimal system is commonly used to represent memory addresses because it allows for a more compact representation compared to decimal or binary. Therefore, "B5" is a valid memory address.

Rate this question:

• 4.

### Salah satu cara menyimpan wordbook pada excel adalah dengan menggunakan ….

• A.

Ctrl + B

• B.

Ctrl + A

• C.

Ctrl + C

• D.

Ctrl + S

D. Ctrl + S
Explanation
The correct answer is "ctrl + S". This keyboard shortcut is commonly used to save a document or file in various applications, including Excel. By pressing "ctrl + S", the user can quickly save their wordbook in Excel, ensuring that any changes or updates made to the document are preserved.

Rate this question:

• 5.

### Ikon “save”, “redo”, dan “undo” merupakan bagian menu dari ….

• A.

Ribbon

• B.

• C.

Status Bar

• D.

Office Button

Explanation
The correct answer is Quick Access Toolbar. The Quick Access Toolbar is a customizable toolbar in Microsoft Office applications that provides easy access to frequently used commands such as save, redo, and undo. It allows users to quickly perform common actions without navigating through multiple menus or ribbons.

Rate this question:

• 6.

### Fungsi dalam Excel yang digunakan menghitung rata-rata dari sekelompok nilai ….

• A.

SUM

• B.

MAX

• C.

MIN

• D.

AVERAGE

D. AVERAGE
Explanation
The correct answer is AVERAGE. The AVERAGE function in Excel is used to calculate the average of a range of values. It adds up all the values in the range and then divides the sum by the number of values in the range. This function is commonly used to find the average score, average sales, or average grade in a set of data.

Rate this question:

• 7.

### Berikut merupakan tombol yang digunakan dalam memformat teks agar menjadi miring, yaitu ….

• A.

Ctrl + B

• B.

Ctrl + U

• C.

Ctrl + I

• D.

Ctrl + S

C. Ctrl + I
Explanation
Tombol yang digunakan untuk memformat teks agar menjadi miring adalah Ctrl + I.

Rate this question:

• 8.

### Pengertian dari range adalah ….

• A.

Pertemuan antara worksheet

• B.

Pertemuan antara garis dan kolom

• C.

Kumpulan sel berbentuk persegi panjang

• D.

Kumpulan sel sembarang

B. Pertemuan antara garis dan kolom
Explanation
The correct answer is "pertemuan antara garis dan kolom". In the context of Excel or spreadsheet software, the term "range" refers to the intersection or meeting point between rows and columns. It is where a group of cells form a rectangular shape. This definition aligns with the given answer option.

Rate this question:

• 9.

### Fungsi utama program Microsoft Excel adalah …

• A.

Pengolah kata

• B.

Mencari informasi

• C.

Pengolah data angka

• D.

Mengelola dokumen

C. Pengolah data angka
Explanation
The correct answer is "Pengolah data angka". Microsoft Excel is primarily used as a spreadsheet program, which means it is designed to handle and manipulate numerical data. It allows users to perform calculations, create graphs and charts, analyze data, and organize information in a tabular format. While it does have some word processing capabilities, its main function is to process and manage numerical data.

Rate this question:

• 10.

### Apa yang dimaksud dengan sel (Cell) dalam excel ?

• A.

Kumpulan dari worksheet

• B.

Lembar kerja dalam excel

• C.

Pertemuan antara sel dengan range

• D.

Pertemuan antara baris dengan kolom

C. Pertemuan antara sel dengan range
Explanation
The term "sel" in Excel refers to a single cell, while "range" refers to a group of cells. Therefore, the correct answer means the meeting or intersection between a single cell and a group of cells.

Rate this question:

• 11.

### Dalam mengedit isi sel bisa dilakukan dengan menggunakan tombol …

• A.

F1

• B.

F2

• C.

F4

• D.

F6

B. F2
Explanation
The correct answer is F2. F2 is used to edit the contents of a cell in various spreadsheet programs such as Microsoft Excel. Pressing F2 allows the user to enter into edit mode for the selected cell, where they can make changes to the text or formula within the cell. This shortcut is commonly used when working with large amounts of data and needing to quickly edit specific cells without using the mouse.

Rate this question:

• 12.

### Dalam menuliskan rumus pada excel harus didahului dengan …

• A.

• B.

" "

• C.

+

• D.

C.

A. =
Explanation
The correct answer is "=". In Excel, when you want to write a formula, it should always start with the equal sign (=). This tells Excel that the following characters are part of a formula and not just regular text. Without the equal sign, Excel will treat the input as text and not perform any calculations.

Rate this question:

• 13.

### Dibawah ini merupakan yang tidak termasuk dalam perintah memulai Microsoft excel adalah …

• A.

Start program microsoft word

• B.

Klik kanan icon Excel , Open

• C.

Double klik pada file latihan fungsi logika.xls

• D.

Double klik pada folder excel

A. Start program microsoft word
Explanation
The correct answer is "Start program Microsoft Word." This option is not included in the instructions for starting Microsoft Excel. The other options, such as right-clicking the Excel icon and opening it, double-clicking on the logic function practice file, and double-clicking on the Excel folder, are all valid ways to start Microsoft Excel.

Rate this question:

• 14.

### Fungsi dari File  Exit adalah …

• A.

Mengakhiri program

• B.

Menghapus program

• C.

Membuka program

• D.

Menjalankan program

A. Mengakhiri program
Explanation
The correct answer is "Mengakhiri program" which means "Ending the program" in English. The function of the File Exit is to terminate or close the program that is currently running. It allows the user to safely exit the program and return to the operating system or previous state. This option is commonly found in menu bars or toolbar of software applications, providing a convenient way for users to exit the program.

Rate this question:

• 15.

### Perintah untuk menggabungkan beberapa sel yang berdekatan dan data yang akan diformat rata tengah adalah ……….

• A.

Align Left

• B.

Center

• C.

Justify

• D.

Merge and Center

D. Merge and Center
Explanation
The correct answer is "Merge and Center". This command allows you to combine multiple adjacent cells and format the data in the middle of the merged cell. It is useful when you want to create a heading or title that spans across multiple columns or rows in a spreadsheet.

Rate this question:

• 16.

### Fungsi untuk perhitungan Jumlah menggunakan perintah ……….

• A.

Sum

• B.

Max

• C.

Average

• D.

Min

A. Sum
Explanation
The correct answer is "Sum". The function "Sum" is used for calculating the total sum of a set of numbers. It adds up all the numbers in the set and provides the sum as the result.

Rate this question:

• 17.

### Secara default, dalam lembar kerja Ms. Excel akan menampilkan ….

• A.

1 Sheet

• B.

2 Sheet

• C.

3 Sheet

• D.

4 Sheet

C. 3 Sheet
Explanation
By default, Microsoft Excel will display 3 sheets in a workbook. This means that when you open a new workbook, you will see three blank sheets where you can enter and organize your data. These sheets can be used to separate different types of information or to create multiple versions of the same data. You can easily add or delete sheets as needed to customize your workbook.

Rate this question:

• 18.

### Fungsi dalam Excel yang digunakan mencari nilai terkecil dari sekelompok nilai ….

• A.

MAX

• B.

MIN

• C.

SUM

• D.

Average

B. MIN
Explanation
The correct answer is MIN. The question is asking for the Excel function used to find the smallest value from a group of values. The MIN function in Excel is specifically designed to calculate the minimum value in a range of cells or a set of values.

Rate this question:

• 19.

### Fungsi dalam Excel yang digunakan mencari nilai terbesar dari sekelompok nilai ….

• A.

MAX

• B.

MIN

• C.

Average

• D.

SUM

A. MAX
Explanation
The correct answer is MAX because the question asks for the function in Excel that is used to find the largest value in a group of values. The MAX function in Excel returns the maximum value from a range of cells or a set of values.

Rate this question:

• 20.

### Berikut merupakan tombol yang digunakan dalam memformat teks agar menjadi tebal, yaitu ….

• A.

Ctrl + B

• B.

Ctrl + C

• C.

Ctrl + U

• D.

Ctrl + I

A. Ctrl + B
Explanation
The correct answer is Ctrl + B. This keyboard shortcut is commonly used to format text and make it bold in various applications and text editors. By pressing Ctrl + B, the selected text will be instantly formatted to appear in a bold font style.

Rate this question:

• 21.

• A.

Ctrl + U

• B.

Ctrl + B

• C.

Ctrl + I

• D.

Ctrl + S