Soal Ulangan Tik Kelas 8 Semester 2

Approved & Edited by ProProfs Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Anwar Mubarak

Anwar Mubarak

Community Contributor

Quizzes Created: 2 | Total Attempts: 44,044

Pertanyaan: 50 | Attempts: 23,020 | Updated: Mar 22, 2023

Quiz Flashcard

Questions

Settings

Feedback

During the Quiz End of Quiz

Create your own Quiz

Soal Ulangan Tik Kelas 8 Semester 2 - Quiz

Questions and Answers

1.

Microsoft Excel merupakan program aplikasi
- A.
  
  A. Spreadsheet
- B.
  
  B. Wordprosesor
- C.
  
  C. Presentation
- D.
  
  D. Animasi
Correct Answer
A. A. Spreadsheet

Explanation
Microsoft Excel is a program application that is specifically designed for creating and managing spreadsheets. It allows users to input and manipulate data, perform calculations, and create charts and graphs. Spreadsheets are used to organize and analyze data in a tabular format, making it easier to track and interpret information. Microsoft Excel is widely used in various industries and professions, such as finance, accounting, and data analysis.

Rate this question:

7
2.

Fungsi yang digunakan untuk menghitung penjumlahan data angka
- A.
  
  A. Sum
- B.
  
  B. Max
- C.
  
  C. Min
- D.
  
  D. Average
Correct Answer
A. A. Sum

Explanation
The correct answer is "a. Sum" because the function "Sum" is used to calculate the total sum of a set of numerical data. It adds up all the numbers in the dataset and provides the sum as the result. This function is commonly used in mathematical calculations and data analysis to find the total value or cumulative sum of a series of numbers.

Rate this question:

2
3.

Fungsi yang digunakan untuk menghitung nilai terbesar data angka
- A.
  
  A. Sum
- B.
  
  B. Max
- C.
  
  C. Min
- D.
  
  D. Average
Correct Answer
B. B. Max

Explanation
The correct answer is b. Max. The function "Max" is used to calculate the largest value among a set of numerical data. It returns the maximum value or the highest number from the given data.

Rate this question:

3
4.

Fungsi yang digunakan untuk menghitung nilai terkecil data angka
- A.
  
  A. Sum
- B.
  
  B. Max
- C.
  
  C. Min
- D.
  
  D. Average
Correct Answer
C. C. Min

Explanation
The correct answer is c. Min. The function "Min" is used to calculate the smallest value in a set of numeric data. It is commonly used to find the minimum value in a list or array of numbers. In this context, it can be used to find the smallest value among a group of numbers. The "Min" function is a mathematical operation that helps in identifying the minimum value present in a dataset.

Rate this question:

4
5.

Fungsi yang digunakan untuk menghitung rata-rata data angka
- A.
  
  A. Sum
- B.
  
  B. Max
- C.
  
  C. Min
- D.
  
  D. Average
Correct Answer
D. D. Average

Explanation
The correct answer is d. Average. The average function is used to calculate the average of a set of numerical data. It adds up all the values and divides the sum by the total number of values in the set. This provides a measure of the central tendency of the data set.

Rate this question:

4
6.

Fungsi yang digunakan untuk menghitung banyak data dalam range tertentu
- A.
  
  A. Count
- B.
  
  B. Large
- C.
  
  C. Small
- D.
  
  D. Rank
Correct Answer
A. A. Count

Explanation
The correct answer is "a. Count". The count function is used to calculate the number of data points within a specific range. It is commonly used in data analysis to determine the frequency or occurrence of certain values.

Rate this question:

6
7.

Baris yang digunakan untuk menampilkan informasi mengenai isi sel yang sedang aktif (disorot) di lembar kerja :
- A.
  
  A. Formula bar
- B.
  
  B. Toolbar
- C.
  
  C. Scroll bar
- D.
  
  D. Menu bar
Correct Answer
A. A. Formula bar

Explanation
The formula bar is used to display information about the contents of the active cell in a worksheet. It is located above the worksheet grid and shows the formula or value of the selected cell. This allows users to easily view and edit the data in the active cell without directly modifying the cell itself. The toolbar, scroll bar, and menu bar are not specifically designed for displaying information about the active cell.

Rate this question:

6
8.

Untuk mengakhiri Excel dapat menekan tombol :
- A.
  
  A. Alt + F4
- B.
  
  B. Ctrl + F4
- C.
  
  C. Alt + F2
- D.
  
  D. Ctrl + F2
Correct Answer
A. A. Alt + F4

Explanation
To close Excel, you can press the combination of keys "Alt + F4". This key combination is a commonly used shortcut to close a program or window in many applications, including Excel. By pressing "Alt + F4", you are instructing the program to close and exit, allowing you to end your Excel session.

Rate this question:

4
9.

Untuk mengedit sel, kita dapat menggunakan tombol :
- A.
  
  A. F1
- B.
  
  B. F2
- C.
  
  C. F3
- D.
  
  D. F4
Correct Answer
B. B. F2

Explanation
The answer is b. F2 because F2 is the function key that is commonly used for editing cells in various software applications, including Microsoft Excel. Pressing F2 allows the user to enter into the edit mode for the selected cell, where they can make changes to the cell's contents.

Rate this question:

3
10.

Yang bukan termasuk fungsi statistik di bawah ini adalah
- A.
  
  A. If
- B.
  
  B. Large
- C.
  
  C. Small
- D.
  
  D. Rank
Correct Answer
A. A. If

Explanation
The correct answer is "a. If". This is because "If" is not a statistical function but rather a conditional statement used in programming or logical operations. The other options, "Large", "Small", and "Rank", are all statistical terms or functions that are used to analyze and interpret data.

Rate this question:

1
11.

Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu
- A.
  
  A. Left
- B.
  
  B. Right
- C.
  
  C. Mid
- D.
  
  D. Value
Correct Answer
A. A. Left

Explanation
The correct answer is "a. Left". The Left function is used to extract a specified number of characters from the beginning (left) of a text string. It is commonly used to retrieve the leftmost characters of a string, based on a specified length.

Rate this question:

1
12.

Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu
- A.
  
  A. Left
- B.
  
  B. Right
- C.
  
  C. Mid
- D.
  
  D. Value
Correct Answer
B. B. Right

Explanation
The correct answer is "b. Right" because the right function is used to extract a specified number of characters from the right side of a text string. It is commonly used to extract file extensions or the last few digits of a number.

Rate this question:

2
13.

Fungsi yang digunakan untuk mengambil beberapa karakter di tengah-tengah data teks
- A.
  
  A. Left
- B.
  
  B. Right
- C.
  
  C. Mid
- D.
  
  D. Value
Correct Answer
C. C. Mid

Explanation
The correct answer is c. Mid. The Mid function is used to extract a specific number of characters from the middle of a text string. It requires three arguments: the text string, the starting position, and the number of characters to extract. This function is commonly used in programming to manipulate and extract substrings from text data.

Rate this question:

2
14.

14. Fungsi yang digunakan untuk mengubah data teks menjadi data numeric
- A.
  
  A. Left
- B.
  
  B. Right
- C.
  
  C. Mid
- D.
  
  D. Value
Correct Answer
D. D. Value

Explanation
The function "Value" is used to convert text data into numeric data. This function takes a text input and returns its corresponding numeric value. It is commonly used when dealing with data that is stored as text but needs to be treated as numbers for mathematical calculations or comparisons.

Rate this question:

1
15.

Yang bukan termasuk fungsi string di bawah ini adalah :
- A.
  
  A. Text
- B.
  
  B. Lower
- C.
  
  C. Upper
- D.
  
  D. If
Correct Answer
D. D. If

Explanation
The correct answer is d. If. This is because "if" is not a string function. It is a conditional statement used for decision-making in programming. String functions are used to manipulate and perform operations on strings, such as finding the length, converting case, or extracting substrings. The other options, a. Text, b. Lower, and c. Upper, are all examples of string functions.

Rate this question:

3
16.

Yang disebut fungsi logika di bawah ini adalah
- A.
  
  A. If
- B.
  
  B. Sumif
- C.
  
  C. Logif
- D.
  
  D. Countif
Correct Answer
A. A. If

Explanation
The correct answer is "a. If". The term "If" refers to a logical function in programming or spreadsheet software that allows for conditional statements. It is used to perform different actions based on whether a certain condition is true or false. This function is commonly used in programming languages and spreadsheet formulas to control the flow of the program or to perform calculations based on specific conditions.

Rate this question:

3
17.

Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu :
- A.
  
  A. Tabel
- B.
  
  B. Data
- C.
  
  C. Grafik
- D.
  
  D. Rumus
Correct Answer
A. A. Tabel

Explanation
The correct answer is a. Tabel. The Vlookup and Hlookup functions are used to read data from a table. These functions allow you to search for a specific value in a table and retrieve corresponding data from the same row or column. They are commonly used in Excel to perform lookups and retrieve information from large datasets organized in a tabular format.

Rate this question:

2
18.

Perintah untuk menyimpan lembar kerja excel dengan menekan tombol
- A.
  
  A. Ctrl S
- B.
  
  B. Ctrl N
- C.
  
  C. Ctrl V
- D.
  
  D. Ctrl A
Correct Answer
A. A. Ctrl S

Explanation
The correct answer is "a. Ctrl S". This keyboard shortcut is commonly used to save Excel workbooks. By pressing Ctrl S, the user can quickly save their current work without having to navigate through the File menu or use the mouse to click on the Save button. This shortcut is a time-saving feature that allows users to easily save their progress and prevent data loss.

Rate this question:

6
19.

Untuk mengatur tinggi baris table menggunakan perintah
- A.
  
  A. format, wide, height
- B.
  
  B. format, row, height
- C.
  
  C. format, coloum, autoselection
- D.
  
  D. format, row, autoselection
Correct Answer
B. B. format, row, height

Explanation
The correct answer is b. format, row, height. This is because when formatting a table, one can adjust the height of the rows using the "format" command and specifying the "row" option. This allows for customization and control over the appearance of the table. The "height" parameter determines the desired height of the rows in the table.

Rate this question:

1
20.

Untuk mengatur lebar kolom table secara otomatis menggunakan perintah
- A.
  
  A. format, wide, height
- B.
  
  B. format, row, height
- C.
  
  C. format, coloum, autofit colum width
- D.
  
  D. format, row, autoselection
Correct Answer
C. C. format, coloum, autofit colum width

Explanation
The correct answer is c. format, column, autofit column width. This is because the question is asking for the command to automatically adjust the width of the columns in a table. The command "autofit column width" is used in the "format" menu to achieve this. The other options mentioned in the question (a. format, wide, height, b. format, row, height, d. format, row, autoselection) do not accurately describe the command for automatically adjusting column width.

Rate this question:

3
21.

Berikut ini yang bukan termasuk kelompok program Microsoft office adalah
- A.
  
  A. Microsoft excel
- B.
  
  B. Microsoft word
- C.
  
  C. Microsoft power point
- D.
  
  D. Microsoft windows
Correct Answer
D. D. Microsoft windows

Explanation
Microsoft Windows is not a program in the Microsoft Office suite. It is an operating system developed by Microsoft. The other options, Microsoft Excel, Microsoft Word, and Microsoft PowerPoint, are all programs included in the Microsoft Office suite.

Rate this question:

2
22.

Berikut ini yang tidak dapat digunakan untuk menjalankan excel adalah
- A.
  
  A. Shortcut excel di desktop
- B.
  
  B. Start menu
- C.
  
  C. File excel
- D.
  
  D. Dokumen word
Correct Answer
D. D. Dokumen word

Explanation
A Word document cannot be used to run Excel. Word and Excel are two different Microsoft Office applications with different functionalities. Word is primarily used for creating and editing documents, while Excel is used for creating and managing spreadsheets. Therefore, a Word document cannot be used to open or run Excel.

Rate this question:
23.

Untuk menampilkan toolbar dilakukan di menu
- A.
  
  A. Insert
- B.
  
  B. View
- C.
  
  C. Format
- D.
  
  D. Data
Correct Answer
B. B. View

Explanation
The correct answer is b. View. The toolbar can be displayed by selecting the "View" menu.

Rate this question:

2
24.

Bagian jendela excel yang berfungsi untuk menampilkan alamat sel yang sedang aktif adalah
- A.
  
  A. bar rumus
- B.
  
  B. bar nama
- C.
  
  C. bar status
- D.
  
  D. bar judul
Correct Answer
B. B. bar nama

Explanation
The correct answer is b. bar nama. The "bar nama" in Excel is the name box, which displays the address of the currently active cell. This allows users to easily identify the location of the cell they are working on. The formula bar (a) displays the contents of the active cell, the status bar (c) shows information about the current status of Excel, and the title bar (d) displays the name of the Excel workbook.

Rate this question:

1
25.

Bagian excel yang digunakan untuk mengerakan lembaran kerja dalam arah horizontal adalah
- A.
  
  A. scroll bar vertical
- B.
  
  B. scroll bar horizontal
- C.
  
  C. control lembaran kerja
- D.
  
  D. taks pane
Correct Answer
B. B. scroll bar horizontal

Explanation
The correct answer is b. scroll bar horizontal. The horizontal scroll bar in Excel is used to move the worksheet left or right along the horizontal axis. It allows users to view and access cells that are not currently visible on the screen. By dragging the scroll bar to the right, the worksheet moves to the right, and by dragging it to the left, the worksheet moves to the left. This feature is helpful when working with large spreadsheets that extend beyond the visible area of the screen.

Rate this question:

1
26.

Tombol yang digunakan untuk menjalankan sebuah perintah disebut
- A.
  
  A. menu bar
- B.
  
  B. toolbar
- C.
  
  C. statusbar
- D.
  
  D. formula bar
Correct Answer
B. B. toolbar

Explanation
The correct answer is b. toolbar. A toolbar is a set of icons or buttons that provide quick access to commonly used commands or functions in a software application. It is usually located at the top or bottom of the screen and allows users to perform tasks or execute commands with just a single click.

Rate this question:

1
27.

Perbesaran lembaran kerja diatur dengan menggunakan perintah
- A.
  
  A. customs view
- B.
  
  B. full screen
- C.
  
  C. zoom
- D.
  
  D. view sheets
Correct Answer
C. C. zoom

Explanation
The correct answer is c. zoom. Zoom is a command that allows for the enlargement or reduction of the worksheet view. It is used to adjust the size of the worksheet to fit the user's preference or to focus on specific details. The other options, customs view, full screen, and view sheets, do not directly relate to adjusting the size of the worksheet.

Rate this question:
28.

Formula bar dapat diatur agar ditampilkan atau tidak ditampilkan dengan menggunakan kotak dialog options atau menuview.perintah untuk menampilkan kotak dialog options terdapat dimenu
- A.
  
  A. view
- B.
  
  B. format
- C.
  
  C. insert
- D.
  
  D. tools
Correct Answer
D. D. tools

Explanation
The correct answer is d. tools. The formula bar can be configured to be displayed or not displayed using the options dialog box or the view menu. The tools menu contains the command to display the options dialog box.

Rate this question:

1
29.

Toolbar yang ditampilkan secara default dijendela excel adalah toolbar
- A.
  
  A. formatting dan standard
- B.
  
  B. standard dan chart
- C.
  
  C. chart dan formatting
- D.
  
  D. standard
Correct Answer
A. A. formatting dan standard

Explanation
The correct answer is a. formatting dan standard. The default toolbar displayed in the Excel window includes both the formatting toolbar and the standard toolbar. The formatting toolbar allows users to quickly apply formatting options such as font style, size, and color, while the standard toolbar provides access to common commands like save, copy, paste, and undo.

Rate this question:

1
30.

Bagian jendela excel yang harus diklik untuk menampilkan lembaran kerja yang tidak aktif adalah
- A.
  
  A. scroll bar lembaran kerja
- B.
  
  B. tab lembaran kerja
- C.
  
  C. control jendela lembaran kerja
- D.
  
  D. menu bar
Correct Answer
B. B. tab lembaran kerja

Explanation
The correct answer is b. tab lembaran kerja. In Excel, each worksheet is displayed as a tab at the bottom of the window. By clicking on the tab of the inactive worksheet, you can switch to that worksheet and display it in the window. The tab lembaran kerja refers to the worksheet tab, so by clicking on it, you can display the inactive worksheet.

Rate this question:
31.

Perintah open dapat dijalankan dari menu file dan tombol open di toolbar standar.selain itu, perintah open dapat juga dijalankan dengan menekan tombol…dikeyboard.
- A.
  
  A. ctrl V
- B.
  
  B. ctrl O
- C.
  
  C. ctrl U
- D.
  
  D. ctrl B
Correct Answer
B. B. ctrl O

Explanation
The correct answer is "b. ctrl O". The explanation is that the question is asking for the keyboard shortcut to execute the "open" command. The other options (ctrl V, ctrl U, ctrl B) are not commonly associated with the "open" command.

Rate this question:

1
32.

Berikut ini tombol yang dapat digunakan untuk menggeser sel yang aktif adalah
- A.
  
  A. tombol enter
- B.
  
  B. tombol tab
- C.
  
  C. tombol arah
- D.
  
  D. semua benar
Correct Answer
D. D. semua benar

Explanation
The correct answer is d. semua benar (all of the above). This means that all of the options mentioned (tombol enter, tombol tab, tombol arah) can be used to shift the active cell.

Rate this question:
33.

Salah satu cara untuk memilih seluruh data di lemburan kerja adalah dengan menekan tombol…di keyboard.
- A.
  
  A. ctrl S
- B.
  
  B. ctrl P
- C.
  
  C. ctrl B
- D.
  
  D. ctrl A
Correct Answer
D. D. ctrl A

Explanation
To select all data in a document or spreadsheet, you can use the keyboard shortcut "ctrl A". This combination of keys will highlight or select all the text, tables, or cells in the current document or spreadsheet. This is a commonly used shortcut in various applications and can save time when you need to select and manipulate a large amount of data.

Rate this question:

3
34.

Perintah yang digunakan untuk menggandakan data adalah
- A.
  
  A. cut dan paste
- B.
  
  B. copy dan paste
- C.
  
  C. copy dan cut
- D.
  
  D. select all dan copy
Correct Answer
B. B. copy dan paste

Explanation
The correct answer is b. copy dan paste. Copy and paste is the command used to duplicate data. This command allows the user to select a portion of text or an object and create a duplicate of it in another location or document. The copied data is temporarily stored in the computer's clipboard, and then it can be pasted in the desired location. This command is commonly used in various applications and operating systems to quickly duplicate information without having to retype or recreate it.

Rate this question:
35.

Selain dengan cara drag and drop.memindahkan data dapat juga dilakukan dengan cara menjalankan perintah
- A.
  
  A. cut dan paste
- B.
  
  B. copy dan paste
- C.
  
  C. copy dan cut
- D.
  
  D. select all dan copy
Correct Answer
A. A. cut dan paste

Explanation
The correct answer is a. cut dan paste. This is because the sentence states that data can be moved by running a command, and the command mentioned here is "cut dan paste" which translates to "cut and paste" in English. This command involves cutting the data from its original location and pasting it to a new location.

Rate this question:
36.

Mengatur lebar kolom dimulai dengan mengklik menu
- A.
  
  A. insert
- B.
  
  B. format
- C.
  
  C. data
- D.
  
  D. table
Correct Answer
B. B. format

Explanation
To adjust the width of a column, you need to click on the "format" menu. This menu usually contains various formatting options, including the option to modify the width of columns. By selecting the "format" menu, you can access the necessary tools to adjust the column width according to your requirements.

Rate this question:
37.

Mengatur tanda decimal dan ribuan yang digunakan di lakukan di kotak dialog
- A.
  
  A. options
- B.
  
  B. format cells
- C.
  
  C. print
- D.
  
  D. page setup
Correct Answer
B. B. format cells

Explanation
The correct answer is "b. format cells" because the question is asking about how to adjust decimal and thousand separators, which is a formatting feature. In Excel, the "Format Cells" option allows users to customize the appearance of cells, including the decimal and thousand separators. This option can be accessed through the "Format" tab in the Excel ribbon or by right-clicking on a cell and selecting "Format Cells" from the context menu.

Rate this question:

2
38.

Menambahkan tanda pemisah ribuan ke data yang di lembaran kerja dilakukan di kotak dialog
- A.
  
  A. options
- B.
  
  B. format cells
- C.
  
  C. print
- D.
  
  D. page setup
Correct Answer
B. B. format cells

Explanation
The correct answer is b. format cells. In Microsoft Excel, the "Format Cells" option allows users to customize the appearance of cells, including adding a thousand separator to data in a worksheet. This can be done by selecting the desired cells, opening the "Format Cells" dialog box, navigating to the "Number" tab, selecting the "Number" category, and choosing the desired format with a thousand separator.

Rate this question:

2
39.

Mengatur tanda rupiah untuk data yang berupa uang dilakukan di kotak dialog
- A.
  
  A. options
- B.
  
  B. format cells
- C.
  
  C. print
- D.
  
  D. page setup
Correct Answer
B. B. format cells

Explanation
The correct answer is b. format cells. In the format cells dialog box, you can customize the appearance of the data, including applying currency formatting to display the data as currency with the appropriate currency symbol, such as the rupiah symbol in this case.

Rate this question:
40.

Perintah page setup dijalankan dari menu
- A.
  
  A. file
- B.
  
  B. insert
- C.
  
  C. view
- D.
  
  D. format
Correct Answer
A. A. file

Explanation
The correct answer is a. file. The page setup command is typically found in the file menu of various software applications. This command allows users to adjust the settings and layout of a document or page before printing or exporting it. By selecting the file menu and choosing the page setup option, users can access a range of settings such as paper size, orientation, margins, and headers/footers.

Rate this question:

1
41.

Jika kita mempunyai table yang melebar ke samping,maka sebaiknya kita memilih orientasi kertas
- A.
  
  A. landscape
- B.
  
  B. portraid
- C.
  
  C. tegak
- D.
  
  D. terserah apa saja
Correct Answer
A. A. landscape

Explanation
The correct answer is a. landscape. When we have a table that extends horizontally, it is more suitable to choose the landscape orientation for the paper. This allows the table to fit better on the page and makes it easier to read and analyze the data. Portrait orientation, on the other hand, is more suitable for vertical content or documents that have more text than tables. Tegak and terserah apa saja are not relevant options for choosing the orientation of the paper.

Rate this question:

1
42.

Perintah untuk menambahkan header and footer dijalankan dari menu
- A.
  
  A. file
- B.
  
  B. insert
- C.
  
  C. view
- D.
  
  D. format
Correct Answer
C. C. view

Explanation
The correct answer is c. view. This is because the command to add a header and footer is typically found in the "view" menu of most software programs. The "view" menu usually contains options for customizing the display of the document, such as showing or hiding certain elements like headers and footers. Therefore, it is logical to assume that the command to add a header and footer would be located in the "view" menu.

Rate this question:

2
43.

Perintah yang digunakan untuk membatalkan perintah yang sudah terlanjur diberikan adalah :
- A.
  
  A. Undo
- B.
  
  B. Redo
- C.
  
  C. Copy
- D.
  
  D. Paste
Correct Answer
A. A. Undo

Explanation
The correct answer is "a. Undo". The undo command is used to reverse or cancel the previous command that has been given. It allows users to revert back to a previous state or action, effectively undoing any changes made. This can be useful in various applications, such as word processors, graphic design software, or even in operating systems, where users can undo their actions and restore the system to a previous state.

Rate this question:

1
44.

Perintah yang digunakan untuk menampilkan angka dengan format tampilan menggunakan lambang uang adalah :
- A.
  
  A. Currency
- B.
  
  B. Percent Style
- C.
  
  C. Comma Style
- D.
  
  D. Dollar
Correct Answer
A. A. Currency

Explanation
The correct answer is a. Currency. The currency format is used to display numbers with a currency symbol. This format is commonly used when working with financial data or when displaying monetary values. It adds a currency symbol (such as $ or €) to the number and formats it according to the currency conventions of the locale.

Rate this question:
45.

Print preview digunakan untuk
- A.
  
  A. melihat tampilan halaman sebelum dicetak
- B.
  
  B. mencetak lembaran kerja
- C.
  
  C. mencetak bagian lembaran kerja tertentu
- D.
  
  D. tidak ada jawaban benar
Correct Answer
A. A. melihat tampilan halaman sebelum dicetak

Explanation
Print preview digunakan untuk melihat tampilan halaman sebelum dicetak. Dengan menggunakan fitur ini, pengguna dapat melihat bagaimana halaman akan terlihat ketika dicetak, termasuk tata letak, teks, gambar, dan elemen-elemen lainnya. Hal ini memungkinkan pengguna untuk memeriksa apakah halaman telah diformat dengan benar sebelum mencetaknya, sehingga mengurangi kemungkinan kesalahan dan memastikan hasil cetakan yang diinginkan.

Rate this question:

2
46.

Berikut ini adalah tombol yang terdapat pada jendela excel pada kondisi tampilan print preview, kecuali
- A.
  
  A. print
- B.
  
  B. back
- C.
  
  C. zoom
- D.
  
  D. close
Correct Answer
B. B. back

Explanation
The correct answer is b. back. In the print preview mode, the back button is not available because it is used to navigate back to the previous screen or window. The other options, print, zoom, and close, are commonly found in the print preview mode and are used for their respective functions.

Rate this question:

1
47.

Perintah print dapat juga dijalankan dari tombol keyboard dengan cara menekan tombol
- A.
  
  A. ctrl V
- B.
  
  B. ctrl C
- C.
  
  C. ctrl Shift P
- D.
  
  D. ctrl P
Correct Answer
D. D. ctrl P

Explanation
The correct answer is d. ctrl P. This is because the question is asking about the keyboard shortcut to execute the print command, and pressing ctrl P is the correct shortcut to do so. The other options (ctrl V, ctrl C, ctrl Shift P) are not related to the print command.

Rate this question:

1
48.

Untuk mencetak rumus yang terdapat di lembaran kerja,kita perlu megatur agar lembaran kerja berada pada kondisi formula auditing mode.formula auditing mode dijalankan dari menu
- A.
  
  A. view
- B.
  
  B. insert
- C.
  
  C. tools
- D.
  
  D. format
Correct Answer
C. C. tools

Explanation
To print the formulas on a worksheet, we need to set the worksheet to formula auditing mode. Formula auditing mode is accessed from the "tools" menu.

Rate this question:
49.

Menghitung rata-rata data angka menggunakan fungsi :
- A.
  
  A. Average
- B.
  
  B. Min
- C.
  
  C. Max
- D.
  
  D. Sum
Correct Answer
A. A. Average

Explanation
The correct answer is a. Average because the question asks for the function used to calculate the average of numerical data. The average function calculates the sum of all the numbers and then divides it by the total count of numbers, giving the average value.

Rate this question:

3
50.

Menambahkan fungsi di lembaran kerja dapat dilakukan dengan menjalankan perintah function. Perintah function terdapat di menu
- A.
  
  A. insert
- B.
  
  B. format
- C.
  
  C. tools
- D.
  
  D. data
Correct Answer
A. A. insert

Explanation
To add a function in a worksheet, you can use the "insert" command. The "insert" command allows you to add various elements, such as functions, charts, tables, etc., to your worksheet. Therefore, option a. "insert" is the correct answer as it specifically mentions the command that is used to add functions in a worksheet.

Rate this question:

1

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, 2023

Quiz Edited by
ProProfs Editorial Team
Feb 21, 2011

Quiz Created by
Anwar Mubarak

Recent Quizzes

Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia Sekolah Global Mandiri - Wilayah Negara Kesatuan Republik Indonesia

Yusra Series Unani Mcqs. Yusra Series Unani Mcqs.

Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020 Seleksi Penerimaan Mahasiswa Baru Poltekkes Hermina Tahun 2020

Seleksi Masuk POLTEKKES HERMINA JAKARTA TA 2020/2021 Seleksi Masuk POLTEKKES HERMINA JAKARTA TA 2020/2021

PRE TEST : MIP - Mandiri Golden Offshore Fund PRE TEST : MIP - Mandiri Golden Offshore Fund

Sejauh mana kamu kenal SMB/SSMB? Yakin sudah kenal banget? Sejauh mana kamu kenal SMB/SSMB? Yakin sudah kenal banget?

Featured Quizzes

Which Phobia Do I Have? Quiz Which Phobia Do I Have? Quiz

First 20 Elements Of The Periodic Table Quiz First 20 Elements Of The Periodic Table Quiz

Soulmate Quiz: Who Is My Soulmate? Soulmate Quiz: Who Is My Soulmate?

The Ultimate College Football Quiz Trivia The Ultimate College Football Quiz Trivia

Waifu Quiz: Who Is Your Waifu? Waifu Quiz: Who Is Your Waifu?

What Is My Korean Name? Quiz What Is My Korean Name? Quiz

Back to top

Soal Ulangan Tik Kelas 8 Semester 2

Microsoft Excel merupakan program aplikasi

Fungsi yang digunakan untuk menghitung penjumlahan data angka

Fungsi yang digunakan untuk menghitung nilai terbesar data angka

Fungsi yang digunakan untuk menghitung nilai terkecil data angka

Fungsi yang digunakan untuk menghitung rata-rata data angka

Fungsi yang digunakan untuk menghitung banyak data dalam range tertentu

Baris yang digunakan untuk menampilkan informasi mengenai isi sel yang sedang aktif (disorot) di lembar kerja :

Untuk mengakhiri Excel dapat menekan tombol :

Untuk mengedit sel, kita dapat menggunakan tombol :

Yang bukan termasuk fungsi statistik di bawah ini adalah

Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu

Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu

Fungsi yang digunakan untuk mengambil beberapa karakter di tengah-tengah data teks

14. Fungsi yang digunakan untuk mengubah data teks menjadi data numeric

Yang bukan termasuk fungsi string di bawah ini adalah :

Yang disebut fungsi logika di bawah ini adalah

Fungsi Vlookup dan Hlookup digunakan untuk membaca suatu :

Perintah untuk menyimpan lembar kerja excel dengan menekan tombol

Untuk mengatur tinggi baris table menggunakan perintah

Untuk mengatur lebar kolom table secara otomatis menggunakan perintah

Berikut ini yang bukan termasuk kelompok program Microsoft office adalah

Berikut ini yang tidak dapat digunakan untuk menjalankan excel adalah

Untuk menampilkan toolbar dilakukan di menu

Bagian jendela excel yang berfungsi untuk menampilkan alamat sel yang sedang aktif adalah

Bagian excel yang digunakan untuk mengerakan lembaran kerja dalam arah horizontal adalah

Tombol yang digunakan untuk menjalankan sebuah perintah disebut

Perbesaran lembaran kerja diatur dengan menggunakan perintah

Formula bar dapat diatur agar ditampilkan atau tidak ditampilkan dengan menggunakan kotak dialog options atau menuview.perintah untuk menampilkan kotak dialog options terdapat dimenu

Toolbar yang ditampilkan secara default dijendela excel adalah toolbar

Bagian jendela excel yang harus diklik untuk menampilkan lembaran kerja yang tidak aktif adalah

Perintah open dapat dijalankan dari menu file dan tombol open di toolbar standar.selain itu, perintah open dapat juga dijalankan dengan menekan tombol…dikeyboard.

Berikut ini tombol yang dapat digunakan untuk menggeser sel yang aktif adalah

Salah satu cara untuk memilih seluruh data di lemburan kerja adalah dengan menekan tombol…di keyboard.

Perintah yang digunakan untuk menggandakan data adalah

Selain dengan cara drag and drop.memindahkan data dapat juga dilakukan dengan cara menjalankan perintah

Mengatur lebar kolom dimulai dengan mengklik menu

Mengatur tanda decimal dan ribuan yang digunakan di lakukan di kotak dialog

Menambahkan tanda pemisah ribuan ke data yang di lembaran kerja dilakukan di kotak dialog

Mengatur tanda rupiah untuk data yang berupa uang dilakukan di kotak dialog

Perintah page setup dijalankan dari menu

Jika kita mempunyai table yang melebar ke samping,maka sebaiknya kita memilih orientasi kertas

Perintah untuk menambahkan header and footer dijalankan dari menu

Perintah yang digunakan untuk membatalkan perintah yang sudah terlanjur diberikan adalah :

Perintah yang digunakan untuk menampilkan angka dengan format tampilan menggunakan lambang uang adalah :

Print preview digunakan untuk

Berikut ini adalah tombol yang terdapat pada jendela excel pada kondisi tampilan print preview, kecuali

Perintah print dapat juga dijalankan dari tombol keyboard dengan cara menekan tombol

Untuk mencetak rumus yang terdapat di lembaran kerja,kita perlu megatur agar lembaran kerja berada pada kondisi formula auditing mode.formula auditing mode dijalankan dari menu

Menghitung rata-rata data angka menggunakan fungsi :

Menambahkan fungsi di lembaran kerja dapat dilakukan dengan menjalankan perintah function. Perintah function terdapat di menu