Ulangan Smk Pgri 2 X
SOAL UNTUK ULANGAN HARIAN KELAS X AKUNTANSI
Questions and Answers
- 1.
Perintah menyembunyikan kolom lembar kerja adalah .…
- A.
A. format, rows, hide
- B.
B. format, coloum, unhide
- C.
C. format, coloum, hide
- D.
D. insert, coloum, hide
- E.
E. format, rows, unhide
Correct Answer
C. C. format, coloum, hideExplanation
The correct answer is c. format, column, hide. This is because to hide a column in a worksheet, we need to use the format option and select the column we want to hide.Rate this question:
-
- 2.
Fungsi yang digunakan untuk menghitung jumlah sel pada sebuah lembar kerja adalah....
- A.
A. sum
- B.
B. average
- C.
C. min
- D.
D. max
- E.
E. and
Correct Answer
A. A. sumExplanation
The correct answer is "a. sum". The sum function is used to calculate the total number of cells in a worksheet. It adds up all the values in a range of cells and returns the sum as the result.Rate this question:
-
- 3.
Fungsi yang berguna untuk membaca data dalam tabel yang disajikan secara vertikal adalah....
- A.
A. FLOOKUP
- B.
B. VLOOKUP
- C.
C. HLOOKUP
- D.
D. IFLOOKUP
- E.
E. ORLOOKUP
Correct Answer
B. B. VLOOKUPExplanation
VLOOKUP is a useful function for reading data in a table presented vertically. It allows users to search for a specific value in the first column of a table and retrieve the corresponding value from a different column. This function is commonly used in data analysis and reporting to extract information from large datasets efficiently.Rate this question:
-
- 4.
Penulisan rumus pada soal berikut yang benar adalah : jika JML>=65 (Sel E6) maka “LULUS” dan jika JML<65 (Sel E6) maka “TIDAK LULUS”.
- A.
A.=VLOOKUP(IF(E6>65;”LULUS”;”TIDAK LULUS”))
- B.
B.=IF(E6>=65;”LULUS”;”TIDAK LULUS”)
- C.
C.=(IF(E6>=65;”LULUS”;”TIDAK LULUS”))
- D.
D.=IF(E6>=65;LULUS;TIDAK LULUS)
- E.
E.=IF(AND(E6>=65;”LULUS”;”TIDAK LULUS”))
Correct Answer
B. B.=IF(E6>=65;”LULUS”;”TIDAK LULUS”)Explanation
The correct answer is b.=IF(E6>=65;”LULUS”;”TIDAK LULUS”). This formula uses the IF function to check if the value in cell E6 is greater than or equal to 65. If it is, the formula returns "LULUS", otherwise it returns "TIDAK LULUS". This formula correctly follows the given condition for determining whether a student passes or fails based on their score.Rate this question:
-
- 5.
Pada rumus =D5+D6+D7+D8 dapat disingkat dengan menggunakan fungsi ….
- A.
A. =SUMIF (D5..D8)
- B.
B. =SUM (D5:D8)
- C.
C. =AVERAGE (D5..D8)
- D.
D. =SUMIF (D5:D8)
- E.
E. =MAX (D5..D8
Correct Answer
B. B. =SUM (D5:D8)Explanation
The correct answer is b. =SUM (D5:D8). This formula calculates the sum of the values in cells D5 to D8.Rate this question:
-
- 6.
Prosedur di bawah ini untuk mengaktifkan lembar kerja Microsoft excel 2003 adalah dengan mengklik….
- A.
A. start, all program, microsoft excel 2003
- B.
B. start, all program, microsoft office, excel 2003
- C.
C. start, all program, microsoft office, microsoft office excel 2003
- D.
D. start, all program, microsoft office, microsoft excel 2003
- E.
E. start, all program, microsoft office, microsoft office 2003
Correct Answer
C. C. start, all program, microsoft office, microsoft office excel 2003Explanation
The correct answer is c. This option correctly states the procedure to activate Microsoft Excel 2003 by clicking on "start," then navigating to "all programs," followed by "Microsoft Office," and finally selecting "Microsoft Office Excel 2003."Rate this question:
-
- 7.
Berikut ini adalah hal-hal yang mungkin dibuat menggunakan program aplikasi lembar sebar, kecuali….
- A.
A. membuat mail merge
- B.
B. mengurutkan data
- C.
C. membuat grafik
- D.
D. menghitung data
- E.
E. membuat tabel
Correct Answer
A. A. membuat mail mergeExplanation
The correct answer is "a. membuat mail merge". Mail merge is a feature commonly found in word processing software, such as Microsoft Word, and not in spreadsheet applications. Spreadsheet applications, like Microsoft Excel or Google Sheets, are primarily used for organizing and analyzing data, performing calculations, creating charts and graphs, and creating tables. Therefore, creating mail merges is not a function typically performed in a spreadsheet application.Rate this question:
-
- 8.
Untuk mengedit sel, kita dapat menggunakan tombol….
- A.
A. F1
- B.
B. F2
- C.
C. F3
- D.
D. F4
- E.
E. F10
Correct Answer
B. B. F2Explanation
To edit a cell, we can use the F2 key.Rate this question:
-
- 9.
Yang bukan termasuk fungsi statistik di bawah ini adalah….
- A.
A. if
- B.
B. large
- C.
C. small
- D.
D. rank
- E.
E. average
Correct Answer
A. A. ifExplanation
The given question asks for the function that does not belong to statistics. The functions listed are if, large, small, rank, and average. Among these, "if" is not a statistical function. In statistics, "if" is a conditional statement that is used to perform different calculations or actions based on a certain condition. However, it is not a specific statistical function like the others listed, which are commonly used in statistical analysis and calculations.Rate this question:
-
- 10.
Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu adalah….
- A.
A. left
- B.
B. right
- C.
C. mid
- D.
D. value
- E.
E. text
Correct Answer
A. A. leftExplanation
The function "left" is used to extract a specified number of characters from the left side of a text string.Rate this question:
-
- 11.
Pertemuan antara baris dan kolom disebut dengan....
Correct Answer
selExplanation
The correct answer is "sel". In Indonesian, "sel" refers to the intersection between a row and a column in a table or grid. So, when we talk about the meeting or intersection point between a row and a column, we use the term "sel".Rate this question:
- 12.
Kumpulan dari beberapa sel disebut dengan....
Correct Answer
rangeExplanation
The correct answer is "range". In the given question, it is stated that a collection of several cells is called "range". This term is commonly used in the context of spreadsheets or data analysis, where a range refers to a group of cells that are selected or grouped together. A range can be used for various purposes, such as performing calculations, applying formatting, or referencing data in formulas.Rate this question:
- 13.
Gambar program yang terdapat pada desktop disebut dengan istilah....
Correct Answer
short cutExplanation
The correct answer is "short cut". A short cut refers to a program or file that is accessed quickly from the desktop. It is a convenient way to access frequently used programs without navigating through multiple folders. Short cuts are represented by icons on the desktop and can be created by right-clicking on a program or file and selecting the "Create shortcut" option. By double-clicking on a short cut, the associated program or file can be opened directly.Rate this question:
- 14.
Gambar yang berfungsi untuk memudahkan membuka suatu aplikasi disebut dengan....
Correct Answer
IconExplanation
An icon is a visual representation or symbol that is used to facilitate the opening or launching of an application. It serves as a shortcut or a quick access point to the application, making it easier for users to locate and use the desired application. Icons are commonly used in computer interfaces and mobile devices to represent different applications, functions, or features. They are designed to be easily recognizable and intuitive, allowing users to quickly navigate and access the desired application without having to search for it in a list or menu.Rate this question:
- 15.
Banyaknya baris dalam Ms. Excel 2007 adalah....
Correct Answer
1048576Explanation
The correct answer is 1048576 because in Microsoft Excel 2007, there are a total of 1,048,576 rows available. This allows users to input and organize a large amount of data in a single spreadsheet.Rate this question:
- 16.
Fungsi logika diawali dengan perintah....
Correct Answer
=IF
IFExplanation
The correct answer is "=IF,IF" because the question is asking for the command that initiates a logical function. The "=IF" command is used to perform logical tests and return different values based on the result of the test. The "IF" command is also used for conditional statements in programming and spreadsheets. Both commands are commonly used to implement logic in various programming languages and spreadsheet applications.Rate this question:
- 17.
Fungsi yang digunakan untuk mengambil beberapa karakter sebanyak karakter tertentu dari tengah adalah....
Correct Answer
=MID
MIDExplanation
The correct answer is =MID. The MID function is used to retrieve a specific number of characters from the middle of a text string. It requires three arguments: the text string, the starting position of the characters to be retrieved, and the number of characters to be retrieved. In this case, the function is used to extract some characters from the middle of a text string.Rate this question:
- 18.
Jika kita mempunyai table yang melebar ke samping,maka sebaiknya kita memilih orientasi kertas…
Correct Answer
LandscapeExplanation
The correct answer is "Landscape" because when we have a table that extends horizontally, it is more suitable to choose landscape orientation. Landscape orientation allows for a wider view of the table, making it easier to read and analyze the data. This orientation is commonly used for tables, charts, and graphs that have more columns than rows.Rate this question:
- 19.
Perintah yang digunakan untuk menampilkan angka dengan format tampilan menggunakan lambang uang adalah….
Correct Answer
accounting
CurrencyExplanation
The correct answer is "accounting, Currency". These are the commands used to display numbers with a currency symbol in the format. The "accounting" command is used to display numbers in the accounting format, which includes a currency symbol and places negative numbers in parentheses. The "Currency" command is used to display numbers with a currency symbol, but does not include parentheses for negative numbers.Rate this question:
- 20.
Function yang berfungsi untuk pengisian tanggal dan jam adalah....
Correct Answer
date and timeExplanation
The correct answer is "date and time" because the question is asking for the function that is used for filling in the date and time. "Date and time" is a commonly used term to refer to the function that allows users to input and display the current date and time in a program or application. This function is important for various applications that require accurate time tracking or scheduling.Rate this question:
- 21.
Untuk berpindah dari workbook yang satu ke workbook yang lainnya dapat dilakukan dengan menekan tombol….
- A.
A. Ctrl + F1
- B.
B. Ctrl + F6
- C.
C. Alt + F1
- D.
D. Alt + F6
- E.
E. Ctrl + Alt + F1
Correct Answer
D. D. Alt + F6Explanation
To switch from one workbook to another, you can press the "Alt + F6" keys.Rate this question:
-
- 22.
Salah satu fasilitas di dalam Microsoft Excel adalah fasilitas sort. Fasilitas ini berguna untuk….
- A.
A. menyaring data
- B.
B. men-scan file
- C.
C. menjumlah data
- D.
D. mengurutkan data
- E.
E. menset tabel
Correct Answer
D. D. mengurutkan dataExplanation
Fasilitas sort di dalam Microsoft Excel berguna untuk mengurutkan data. Dengan menggunakan fasilitas ini, pengguna dapat mengurutkan data dalam urutan tertentu, seperti dari terkecil ke terbesar atau sebaliknya. Fasilitas sort ini sangat berguna dalam mengorganisir dan menganalisis data dalam spreadsheet.Rate this question:
-
- 23.
Salah satu fasilitas di dalam Microsoft Excel adalah fasilitas sort. Fasilitas ini berguna untuk….
- A.
A. menyaring data
- B.
B. men-scan file
- C.
C. menjumlah data
- D.
D. mengurutkan data
- E.
E. menset tabel
Correct Answer
D. D. mengurutkan dataExplanation
Fasilitas sort di Microsoft Excel digunakan untuk mengurutkan data. Dengan menggunakan fasilitas ini, pengguna dapat mengatur urutan data berdasarkan nilai, teks, tanggal, atau kriteria lainnya. Hal ini memudahkan dalam mencari dan menganalisis data yang terurut secara teratur.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