Ulangan Harian-1 Tik Kls 8 Semester 2 Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Roedy
R
Roedy
Community Contributor
Quizzes Created: 3 | Total Attempts: 45,453
Questions: 20 | Attempts: 2,710

SettingsSettingsSettings
Ulangan Harian-1 Tik Kls 8 Semester 2 Quiz - Quiz


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 Calc
    Explanation
    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 Sheet
    Explanation
    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.384
    Explanation
    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. Sel
    Explanation
    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 Bar
    Explanation
    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/range
    Explanation
    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 Toolbar
    Explanation
    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 Home
    Explanation
    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 27
    Explanation
    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. View
    Explanation
    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. Home
    Explanation
    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. Close
    Explanation
    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 Style
    Explanation
    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 & Center
    Explanation
    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. Text
    Explanation
    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. F2
    Explanation
    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.000
    Explanation
    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. AutoSum
    Explanation
    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

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 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 07, 2012
    Quiz Created by
    Roedy
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.