Ujian Teori Microsoft Excel Kelas 8
UJIAN TEORI ONLINE TIK KELAS 8 SMP LABSCHOOL JAKARTA Materi Microsoft Excel 2003
Questions and Answers
- 1.
Selain menggunakan mouse, keyboard juga dapat digunakan untuk mengaktifkan menu. Perintah berikut yang digunakan untuk mengaktifkan menu file adalah :
- A.
Ctrl + F
- B.
Ctrl + O + F
- C.
Alt + F4+ F3
- D.
Alt + F
Correct Answer
D. Alt + FExplanation
The correct answer is Alt + F. This key combination is commonly used to activate the menu bar in many software applications, including file menus. By pressing Alt + F, users can access various options related to file operations, such as opening, saving, or closing files.Rate this question:
-
- 2.
Lembar kerja excel terdiri atas baris yang diwakili oleh angka 1,2,…dan kolom yang diwakili oleh huruf A, B, …. Banyaknya jumlah baris dan kolom Excel adalah
- A.
65536 dan 256
- B.
65356 dan 265
- C.
63556 dan 526
- D.
66355 dan 625
Correct Answer
A. 65536 dan 256Explanation
The correct answer is 65536 and 256. In Microsoft Excel, the maximum number of rows is 65536 and the maximum number of columns is 256. This means that an Excel worksheet can have a total of 65536 rows and 256 columns.Rate this question:
-
- 3.
Fungsi yang digunakan untuk mengambil bagian kiri dari data teks sebanyak karakter tertentu
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
A. LeftExplanation
The correct answer is "Left". The Left function is used to extract a specified number of characters from the beginning of a text string.Rate this question:
-
- 4.
Yang bukan termasuk fungsi statistik di bawah ini adalah
- A.
If
- B.
Large
- C.
Small
- D.
Rank
Correct Answer
A. IfExplanation
The word "If" is not a function in statistics. In statistics, functions are mathematical operations or calculations that are used to analyze and interpret data. "If" is a conditional statement that is used in programming or logical reasoning, but it is not a statistical function.Rate this question:
-
- 5.
Fungsi yang digunakan untuk menghitung penjumlahan data angka
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
Correct Answer
A. SumExplanation
Sum is the correct answer because it is the function used to calculate the total sum of a set of numerical data. It adds up all the numbers in the data set to give the final sum.Rate this question:
-
- 6.
Fungsi yang digunakan untuk menghitung nilai terbesar data angka
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
Correct Answer
B. MaxExplanation
The correct answer is "Max". The function "Max" is used to calculate the largest value among a set of numerical data. It returns the maximum value from the given data.Rate this question:
-
- 7.
Microsoft Excel merupakan program aplikasi
- A.
Spreadsheet
- B.
Wordprosesor
- C.
Presentation
- D.
Animasi
Correct Answer
A. SpreadsheetExplanation
The correct answer is Spreadsheet. Microsoft Excel is a program application that is specifically designed for creating and managing spreadsheets. It allows users to input and organize data in a tabular format, perform calculations, create charts and graphs, and analyze data using various functions and formulas. It is widely used in business and finance for tasks such as budgeting, financial analysis, and data manipulation.Rate this question:
-
- 8.
Fungsi yang digunakan untuk menghitung nilai terkecil data angka adalah:
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
Correct Answer
C. MinExplanation
The correct answer is "Min". The function "Min" is used to calculate the smallest value among a set of numeric data. It returns the minimum value from the given data.Rate this question:
-
- 9.
Fungsi yang digunakan untuk menghitung rata-rata data angka adalah
- A.
Sum
- B.
Max
- C.
Min
- D.
Average
Correct Answer
D. AverageExplanation
The function used to calculate the average of numerical data is "Average". This function sums up all the data values and divides the sum by the total number of values, giving the average value.Rate this question:
-
- 10.
Fungsi yang digunakan untuk menghitung banyak data dalam range tertentu adalah:
- A.
Count
- B.
Large
- C.
Small
- D.
Rank
Correct Answer
A. CountExplanation
The correct answer is Count. Count is a function that is used to calculate the number of data points within a specific range. It is commonly used in data analysis and statistics to determine the frequency or occurrence of certain values in a dataset. By using the Count function, we can easily count the number of data points that meet a specific condition or fall within a certain range, providing valuable insights into the dataset.Rate this question:
-
- 11.
Fungsi yang digunakan untuk mendapatkan bilangan terbesar ke-n dari sekumpulan data adalah :
- A.
Count
- B.
Large
- C.
Small
- D.
Rank
Correct Answer
B. LargeExplanation
The function "Large" is used to obtain the largest nth number from a set of data.Rate this question:
-
- 12.
Fungsi yang digunakan untuk mendapatkan bilangan terkecil ke-n dari sekumpulan data adalah :
- A.
Count
- B.
Large
- C.
Small
- D.
Rank
Correct Answer
C. SmallExplanation
The function "Small" is used to retrieve the nth smallest number from a set of data.Rate this question:
-
- 13.
Fungsi yang digunakan untuk menghasilkan rangking suatu bilangan dari sekumpulan data adalah:
- A.
Count
- B.
Large
- C.
Small
- D.
Rank
Correct Answer
D. RankExplanation
The correct answer is "rank". The rank function is used to generate the ranking of a number within a set of data. It assigns a numerical value to each data point based on its position in the ordered set, with the highest value assigned to the highest-ranked data point. This function is commonly used in statistics and data analysis to determine the relative position or importance of a particular data point within a dataset.Rate this question:
-
- 14.
Fungsi yang digunakan untuk mengambil bagian kanan dari data teks sebanyak karakter tertentu adalah :
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
B. RightExplanation
The correct answer is "Right". The Right function is used to extract a specified number of characters from the right side of a text string. It is commonly used when you need to extract the last few characters from a cell or a string of text.Rate this question:
-
- 15.
Fungsi yang digunakan untuk mengambil beberapa karakter di tengah-tengah data teks adalah :
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
C. MidExplanation
The Mid function is used to extract a specific number of characters from the middle of a text string. This function requires three arguments: the text string from which to extract the characters, the starting position of the extraction, and the number of characters to extract. Therefore, the Mid function is the correct choice for extracting characters from the middle of a text.Rate this question:
-
- 16.
Fungsi yang digunakan untuk mengubah data teks menjadi data numeric adalah :
- A.
Left
- B.
Right
- C.
Mid
- D.
Value
Correct Answer
D. ValueExplanation
The Value function is used to convert text data into numeric data. It takes a string argument and tries to convert it into a number. If the conversion is successful, it returns the numeric value; otherwise, it returns an error. The Left, Right, and Mid functions are used for extracting specific portions of a text string, but they do not convert the text into numeric data.Rate this question:
-
- 17.
Yang bukan termasuk fungsi string di bawah ini adalah :
- A.
Text
- B.
Lower
- C.
Upper
- D.
If
Correct Answer
D. IfExplanation
The function "If" is not a string function. It is a conditional statement used for making decisions in programming. String functions are used for manipulating and working with strings, such as changing the case of letters (Lower and Upper) or extracting specific parts of a string (Text).Rate this question:
-
- 18.
Yang disebut fungsi logika di bawah ini adalah :
- A.
If
- B.
Sumif
- C.
Logif
- D.
Countif
Correct Answer
A. IfExplanation
The correct answer is "If". This is because "If" is a logical function used in programming and spreadsheet applications to test a condition and return different values based on whether the condition is true or false. It allows for conditional execution of code or formulas, making it an essential tool in decision-making processes.Rate this question:
-
- 19.
Tempat mengetik naskah di excel adalah :
- A.
Worksheet
- B.
Editing
- C.
Sheet
- D.
Range
Correct Answer
A. WorksheetExplanation
The correct answer is "Worksheet". In Excel, a worksheet is a single sheet within a workbook where you can enter and manipulate data. It is the main working area where you can type and edit text, numbers, and formulas. Worksheets are organized in tabs at the bottom of the Excel window, allowing you to have multiple sheets within a single workbook.Rate this question:
-
- 20.
Perintah untuk menyimpan lembar kerja excel dengan menekan tombol adalah :
- A.
Ctrl S
- B.
Ctrl N
- C.
Ctrl V
- D.
Ctrl A
Correct Answer
A. Ctrl SExplanation
The correct answer is Ctrl S. This keyboard shortcut is commonly used to save a document in various applications, including Excel. By pressing Ctrl S, the user can quickly save their work without having to navigate through the menu options. It is a convenient and efficient way to ensure that any changes made to the Excel worksheet are saved and can be accessed later.Rate this question:
-
- 21.
Untuk mengatur tinggi baris table menggunakan perintah adalah :
- A.
Format, wide, height
- B.
Format, row, height
- C.
Format, coloum, autoselection
- D.
Format, row, autoselection
Correct Answer
B. Format, row, heightExplanation
The correct answer is "format, row, height". This is because when we want to adjust the height of a row in a table, we use the "format" command, followed by specifying that we want to adjust the height of a row using the "row" parameter, and then we specify the desired height using the "height" parameter. This allows us to customize the height of specific rows in a table.Rate this question:
-
- 22.
Untuk mengatur LEBAR KOLOM table menggunakan perintah adalah :
- A.
Format, column, width
- B.
Format, row, heigh
- C.
Format, coloum, autoselection
- D.
Format, row, autoselection
Correct Answer
A. Format, column, widthExplanation
The correct answer is "format, column, width." To adjust the width of a column in a table, the format command is used, followed by the keyword "column" and then the desired width value. This command allows for precise control over the visual appearance of the table by adjusting the width of individual columns to accommodate the content within them.Rate this question:
-
- 23.
Berikut ini yang bukan termasuk kelompok program Microsoft office adalah
- A.
Microsoft excel
- B.
Microsoft word
- C.
Microsoft power point
- D.
Microsoft windows Vista
Correct Answer
D. Microsoft windows VistaExplanation
Microsoft Windows Vista is not a program in the Microsoft Office suite. It is an operating system developed by Microsoft. The other options listed (Microsoft Excel, Microsoft Word, and Microsoft PowerPoint) are all programs included in the Microsoft Office suite.Rate this question:
-
- 24.
Berikut ini yang tidak dapat digunakan untuk menjalankan excel adalah
- A.
Shortcut excel di desktop
- B.
Start menu
- C.
File excel
- D.
Dokumen word
Correct Answer
D. Dokumen wordExplanation
Dokumen Word tidak dapat digunakan untuk menjalankan Excel karena Excel dan Word adalah dua program yang berbeda. Excel adalah program spreadsheet yang digunakan untuk mengelola data dan melakukan perhitungan, sedangkan Word adalah program pengolah kata yang digunakan untuk membuat dan mengedit dokumen teks.Rate this question:
-
- 25.
Untuk menampilkan toolbar dilakukan di menu
- A.
Insert
- B.
View
- C.
Format
- D.
Data
Correct Answer
A. InsertExplanation
To display the toolbar, you need to go to the Insert menu.Rate this question:
-
- 26.
Bagian jendela excel yang berfungsi untuk menampilkan alamat sel yang sedang aktif adalah
- A.
Bar rumus
- B.
Bar nama
- C.
Bar status
- D.
Bar judul
Correct Answer
C. Bar statusExplanation
The "bar status" in Excel refers to the status bar, which is located at the bottom of the Excel window. It displays various information about the active cell or selection, such as the cell reference (address) and the content of the cell. This information is helpful for users to keep track of their current location in the spreadsheet and to quickly access important details about the selected cell.Rate this question:
-
- 27.
Bagian excel yang digunakan untuk menggerakkan lembaran kerja dalam arah horizontal adalah
- A.
Scroll bar vertical
- B.
Scroll bar horizontal
- C.
Control lembaran kerja
- D.
Taks pane
Correct Answer
B. Scroll bar horizontalExplanation
The correct answer is "scroll bar horizontal." This is because a horizontal scroll bar is used in Excel to move the worksheet horizontally, allowing the user to view data that is not currently visible on the screen. It enables the user to navigate through the columns of the worksheet.Rate this question:
-
- 28.
Tombol yang digunakan untuk menjalankan sebuah perintah disebut
- A.
Menu bar
- B.
Toolbar
- C.
Statusbar
- D.
Formula bar
Correct Answer
B. ToolbarExplanation
The correct answer is "toolbar". A toolbar is a set of icons or buttons that provide quick access to various commands or functions in a software program. It is typically located at the top or bottom of the screen and allows users to perform common actions easily without having to navigate through menus or use keyboard shortcuts. In this context, the toolbar is the button or set of buttons that can be clicked to execute a command.Rate this question:
-
- 29.
Perbesaran lembaran kerja diatur dengan menggunakan perintah
- A.
Custom view
- B.
Full screen
- C.
Zoom
- D.
View sheets
Correct Answer
C. ZoomExplanation
The correct answer is "zoom". Zoom is the command used to adjust the magnification level of a worksheet. It allows users to enlarge or reduce the size of the sheet to fit their needs and make it easier to view and work on. This command is commonly used in spreadsheet software to enhance visibility and improve the overall user experience.Rate this question:
-
- 30.
Bagian jendela excel yang diklik untuk menampilkan lembaran kerja yang tidak aktif adalah
- A.
Scroll bar lembaran kerja
- B.
Tab lembaran kerja
- C.
Control jendela lembaran kerja
- D.
Menu bar
Correct Answer
C. Control jendela lembaran kerjaExplanation
The correct answer is "control jendela lembaran kerja" because it refers to the control or button in the Excel window that is clicked to display the inactive worksheet. This control allows the user to switch between different worksheets within the Excel application. The scroll bar, tab lembaran kerja, and menu bar are not specifically related to displaying the inactive worksheet.Rate this question:
-
- 31.
Formula bar dapat diatur agar ditampilkan atau tidak ditampilkan dengan menggunakan kotak dialog options atau menu view. Perintah untuk menampilkan kotak dialog options terdapat dimenu
- A.
View
- B.
Format
- C.
Insert
- D.
Tools
Correct Answer
A. ViewExplanation
The formula bar can be adjusted to be displayed or not displayed by using the options dialog box or the view menu. The command to display the options dialog box is found in the view menu.Rate this question:
-
- 32.
Toolbar yang ditampilkan secara default di jendela excel adalah toolbar
- A.
Formatting dan standard
- B.
Standard dan chart
- C.
Chart dan formatting
- D.
Standard
Correct Answer
A. Formatting dan standardExplanation
The correct answer is "formatting dan standard" because the question asks for the default toolbar displayed in an Excel window. The formatting toolbar contains various options for formatting cells, such as changing font style, size, and color, while the standard toolbar includes basic functions like saving, copying, and pasting. Therefore, both the formatting and standard toolbars are displayed by default in an Excel window.Rate this question:
-
- 33.
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.
Ctrl V
- B.
Ctrl O
- C.
Ctrl U
- D.
Ctrl B
Correct Answer
B. Ctrl OExplanation
The correct answer is Ctrl O. The explanation is that the command "open" can be executed from the file menu and the open button on the standard toolbar. Additionally, the open command can also be executed by pressing the Ctrl O key combination on the keyboard.Rate this question:
-
- 34.
Berikut ini tombol yang dapat digunakan untuk menggeser sel yang aktif adalah
- A.
Tombol enter
- B.
Tombol tab
- C.
Tombol arah
- D.
Semua benar
Correct Answer
D. Semua benarExplanation
Semua jawaban yang diberikan adalah benar. Tombol enter digunakan untuk memindahkan kursor ke sel di bawahnya, tombol tab digunakan untuk memindahkan kursor ke sel di sebelah kanan, dan tombol arah digunakan untuk memindahkan kursor ke sel di sebelah atas, bawah, kanan, atau kiri. Oleh karena itu, semua jawaban tersebut adalah benar.Rate this question:
-
- 35.
Salah satu cara untuk memilih seluruh data di lemburan kerja adalah dengan menekan tombol…….......di keyboard.
- A.
Ctrl S
- B.
Ctrl P
- C.
Ctrl B
- D.
Ctrl A
Correct Answer
D. Ctrl AExplanation
To select all data in a document or spreadsheet, the correct key combination is "ctrl A" on the keyboard. This shortcut is commonly used to quickly highlight and select all content in a given file or document.Rate this question:
-
- 36.
Perintah yang digunakan untuk menggandakan data adalah
- A.
Cut dan paste
- B.
Copy dan paste
- C.
Copy dan cut
- D.
Select all dan copy
Correct Answer
B. Copy dan pasteExplanation
The correct answer is "copy dan paste". This is because the command "copy" is used to duplicate or make a copy of data, while the command "paste" is used to insert the copied data into a new location or document. Therefore, using the "copy dan paste" command allows you to duplicate data effectively.Rate this question:
-
- 37.
Mengatur tanda decimal dan ribuan yang digunakan di lakukan di kotak dialog
- A.
Options
- B.
Format cells
- C.
Print
- D.
Page setup
Correct Answer
B. Format cellsExplanation
The given statement suggests that the task of setting decimal and thousand separators can be performed in a dialog box. The correct answer, "format cells," aligns with this explanation as it is the option in Excel that allows users to customize the format of cells, including the decimal and thousand separators.Rate this question:
-
- 38.
Selain dengan cara drag and drop.memindahkan data dapat juga dilakukan dengan cara menjalankan perintah
- A.
Cut dan paste
- B.
Copy dan paste
- C.
Copy dan cut
- D.
Select all dan cut
Correct Answer
A. Cut dan pasteExplanation
The correct answer is "cut and paste." This means that data can be moved by cutting it from one location and pasting it into another. This method involves selecting the data that needs to be moved, cutting it from its current location, and then pasting it into the desired location.Rate this question:
-
- 39.
Mengatur lebar kolom dimulai dengan mengklik menu
- A.
Insert
- B.
Format
- C.
Data
- D.
Table
Correct Answer
A. InsertExplanation
The correct answer is "insert" because the question is asking how to start adjusting the width of a column. When adjusting column width in a document or spreadsheet, the "insert" menu typically provides options for manipulating columns, such as inserting or deleting columns, which can include adjusting their width. Therefore, clicking on the "insert" menu would be the appropriate action to take in order to begin adjusting the width of a column.Rate this question:
-
- 40.
Menambahkan tanda pemisah ribuan ke data yang di lembaran kerja dilakukan di kotak dialog
- A.
Options
- B.
Data data data format cells
- C.
Data edit
- D.
Page setup
Correct Answer
B. Data data data format cellsExplanation
The correct answer is "format cells". This is because adding a thousand separator to data in a worksheet is a formatting task, and the "format cells" option in the dialog box allows users to apply various formatting options to the selected data, including adding a thousand separator.Rate this question:
-
- 41.
Mengatur tanda rupiah untuk data yang berupa uang dilakukan di kotak dialog
- A.
Options
- B.
Format cells
- C.
Print
- D.
Page setup
Correct Answer
B. Format cellsExplanation
The correct answer is "format cells" because it is the option that allows users to customize the appearance of data, including currency formatting. The "format cells" option can be accessed through a dialogue box where users can select the currency format and apply it to the desired data. This option is commonly used when working with financial data or any other data that involves currency values.Rate this question:
-
- 42.
Perintah page setup dijalankan dari menu
- A.
File
- B.
Insert
- C.
View
- D.
Format
Correct Answer
A. FileExplanation
The page setup command is typically executed from the "file" menu. This menu usually contains options related to managing and manipulating files, such as saving, opening, and printing. The page setup command allows users to customize the layout and formatting of a document before printing it, such as adjusting the page size, margins, and orientation. Therefore, it makes sense for this command to be located in the "file" menu, as it is closely related to managing and preparing the document for printing.Rate this question:
-
- 43.
Perintah untuk keluar dari Excel di menu utama adalah
- A.
Exit
- B.
Close
- C.
Open
- D.
New
Correct Answer
A. ExitExplanation
The correct answer is "Exit" because it is the command used to exit or close the Excel program.Rate this question:
-
- 44.
Perintah untuk membuka file Excel adalah :
- A.
New
- B.
Open
- C.
Close
- D.
Exit
Correct Answer
B. OpenExplanation
The correct answer is "open" because when we want to open a file in Excel, we use the "open" command. This command allows us to access and view the contents of the Excel file. The other options provided, such as "new," "close," and "exit," are not relevant to the action of opening a file.Rate this question:
-
- 45.
Perintah yg digunakan untuk mengatur besarnya baris adalah :
- A.
Klik Format, row, height
- B.
Klik Format, coloumn, height
- C.
Klik Format, row, coloum
- D.
Klik Format, coloumn, width
Correct Answer
A. Klik Format, row, heightExplanation
The correct answer is "Klik Format, row, height." In Microsoft Excel, to adjust the height of a row, you need to click on the "Format" tab, then select "Row" from the options, and finally choose "Height" to specify the desired height for the row.Rate this question:
-
- 46.
Perintah yang digunakan untuk mengatur lebarnya kolom adalah :
- A.
Klik Format, row, height
- B.
Klik Format, coloumn, height
- C.
Klik Format, row, widhth
- D.
Klik Format, coloumn, width
Correct Answer
A. Klik Format, row, heightExplanation
The correct answer is "Klik Format, row, height". This is because to adjust the width of a column in a spreadsheet, you would typically click on the "Format" tab, then select "row" to indicate that you want to adjust the height of a row, and finally select "height" to specify the desired height for the row.Rate this question:
-
- 47.
Perintah yg digunakan untuk mencetak lembar excel adalah:
- A.
Print
- B.
Print Preview
- C.
Page setup
- D.
Print Page setup
Correct Answer
A. PrintExplanation
The command used to print an excel sheet is "Print". This command allows the user to directly print the excel sheet without having to go through any additional steps or previews. It initiates the printing process and sends the document to the printer.Rate this question:
-
- 48.
Print preview digunakan untuk
- A.
Melihat tampilan halaman sebelum dicetak
- B.
Mencetak lembaran kerja
- C.
Mencetak bagian lembaran kerja tertentu
- D.
Tidak ada jawaban benar
Correct Answer
A. Melihat tampilan halaman sebelum dicetakExplanation
Print preview digunakan untuk melihat tampilan halaman sebelum dicetak. Ini memungkinkan pengguna untuk melihat bagaimana halaman akan terlihat ketika dicetak, sehingga mereka dapat memeriksa tata letak, teks, gambar, dan elemen lainnya sebelum mencetaknya. Dengan melihat tampilan sebelumnya, pengguna dapat memastikan bahwa hasil cetakan akan sesuai dengan yang diinginkan dan menghindari kesalahan atau ketidaksesuaian yang mungkin terjadi setelah mencetak.Rate this question:
-
- 49.
Berikut ini adalah tombol yang terdapat pada jendela excel pada kondisi tampilan print preview, kecuali
- A.
Print
- B.
Back
- C.
Zoom
- D.
Close
Correct Answer
B. BackExplanation
The given options are print, back, zoom, and close. These buttons are typically found in the print preview window of Excel. However, the "back" button is not usually present in the print preview window. It is more commonly found in web browsers or file explorer windows. Therefore, the correct answer is "back".Rate this question:
-
- 50.
Perintah print dapat juga dijalankan dari tombol keyboard dengan cara menekan tombol
- A.
Ctrl V
- B.
Ctrl C
- C.
Ctrl Shift P
- D.
Ctrl P
Correct Answer
D. Ctrl PExplanation
The correct answer is Ctrl P. The question is asking for the keyboard shortcut to execute the print command. Ctrl P is a commonly used keyboard shortcut to open the print dialog box in many applications.Rate this question:
-
.jpg "Perintah print dapat juga dijalankan dari tombol keyboard dengan cara menekan tombol")
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, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 14, 2011Quiz Created by
Wijayalabs
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