Ujian Online Microsoft Excel 1

The correct answer is "=" because in order to input a formula or equation, it needs to be preceded by the equal sign. This is a common convention in many spreadsheet programs and mathematical software, indicating that the following characters are part of a calculation rather than plain text.

The correct answer is AVERAGE. The AVERAGE function is used in statistics to calculate the mean or average value of a range of numbers. It adds up all the values in the range and divides the sum by the number of values to find the average.

The function "=LEFT("INDONESIA",3)" in Excel extracts the first three characters from the word "INDONESIA", resulting in the output "IND".

When entering a formula or data, if the column width is too narrow, the contents of the cell will be displayed as "########".

The correct answer is =AVERAGE(B2:D2) because the AVERAGE function calculates the average of the values in the range B2 to D2, which are 57, 43, and 50.

HLOOKUP is the correct answer because it is a function used in Excel to search for a value in the top row of a table and return a corresponding value from a specified row. It stands for "Horizontal Lookup" and is commonly used when the data is organized in a horizontal format. This function is useful for retrieving data from large tables or databases where the desired value is located in a specific row.

The correct answer is "Insert Chart" because to create a graph or chart, the command or option used is usually "Insert Chart." This command allows the user to select the desired chart type and input the data to be represented graphically. The other options listed, such as "View Chart," "Review Chart," "Data Sort," and "Formula," are not directly related to creating a chart.

The correct answer is =SUM(E5:E9) because the question asks for the correct formula to sum the data in the range E5 to E9. The SUM function in Excel is used to add up numbers in a specified range, so =SUM(E5:E9) will give the sum of the values in that range.

The correct answer is "Currency" because the symbol "Rp" is commonly used to represent the currency of Indonesia, which is the Indonesian Rupiah. Therefore, it is logical to find the symbol for the currency under the option "Currency".

The correct answer is 43 because the MIN function is used to find the smallest value in a range of cells. In this case, the range is from cell B2 to cell D2. The smallest value in this range is 43, so that is the result of the MIN function.

A cell is the intersection point between a row and a column in a spreadsheet or a table. It is the basic unit of data storage in a spreadsheet, where data can be entered, edited, and manipulated. Cells allow for the organization and presentation of data in a structured manner.

The given correct answer is "Pie". This suggests that the type of graph shown in the diagram is a pie chart. A pie chart is a circular statistical graphic that is divided into slices to represent numerical proportions. Each slice of the pie chart represents a different category or data point, and the size of each slice corresponds to the proportion of the whole.

The correct answer is "Pengolah Angka" because Microsoft Excel is a spreadsheet program that is primarily used for organizing, analyzing, and manipulating numerical data. It allows users to perform calculations, create charts and graphs, and store large amounts of numerical information in a structured and organized manner. Therefore, it is most commonly used as a tool for working with numbers and performing mathematical operations.

To correct a mistyped data, you can press the F2 key.

The correct answer is 3500 because the formula =MAX(A1:C1) calculates the maximum value from cells A1, B1, and C1. In this case, the maximum value is 3500, which is the content of cell B1.

The correct answer is "Multiply" because the question is asking for the term used to refer to the * operator. In mathematics and programming, the * operator is commonly used to perform multiplication between two numbers. Therefore, "Multiply" is the appropriate term to describe the * operator.

The correct answer is "=IF(A1>5,”SARJANA”,”SMA”)". This is because the IF function in Excel is used to perform a logical test and return different values based on the result of the test. In this case, the logical test is whether the value in cell A1 is greater than 5. If it is, the function will return "SARJANA", otherwise it will return "SMA". This formula is correctly written with the correct syntax and quotation marks for the text values.

The correct answer is that if the second letter of the code appears twice and is equal to "SM", then the output will be "Semen". This means that the formula is checking if the second letter of the code is "S" and the following letter is "M". If both conditions are met, the formula will return "Semen".

To create an absolute cell reference in a formula, the dollar sign ($) symbol is used. This symbol is placed in front of both the column letter and row number of the cell reference. By using the dollar sign, the cell reference will not change when the formula is copied or filled to other cells. Therefore, the correct answer is $ as it is the symbol used to create an absolute cell reference.

The correct answer is "Jelek" because the VLOOKUP function is used to search for a value in the first column of a range and return a corresponding value from a different column. In this case, the function is searching for the value in cell B30 within the range B36:D40. The function will return the value in the second column of the range, which is "Jelek".

The correct answer is "AN" because the =RIGHT(B3,2) function extracts the last two characters from the text in cell B3, which is "AN" in this case.

The correct answer is COUNT. COUNT is a logical function used to find the number of data within a specified range. It counts the number of cells in a range that contain numbers or values. This function is commonly used in data analysis and reporting to determine the total count of specific data points or to calculate frequencies.

The correct answer for this question is "Merger and Center". This option suggests that to display data with a position in the middle of certain columns, the command "Merger and Center" should be used. This command combines the selected cells and centers the content within them.

The correct answer is "Dari besar ke kecil" which means "From large to small" in English. This means that when arranging or sorting data in descending order, the largest values will be placed first, followed by the smaller values.

The correct answer is "Paragraph". The other options listed (Number, Alignment, Border, Pattern) are all features or settings that can be found in the Format Cells menu. However, "Paragraph" is not a feature or setting that is typically included in the Format Cells menu. It is more commonly found in word processing programs or text editors, where it is used to adjust the formatting and layout of paragraphs of text.

The correct answer is A because the function in cell A2 is an IF statement that checks if the value in A2 is less than 65. If it is, it returns "C". If not, it checks if the value is less than 75. If it is, it returns "B". If neither condition is met, it returns "A". Since the value in A2 is 75, it is not less than 65 or 75, so the function will return "A".

The given correct answer suggests that the icon is used to arrange data in ascending order. This means that the icon can be used to organize data in a way that starts with the lowest value and goes up to the highest value. It is a way to sort data in increasing order.

Autofilter adalah fitur yang digunakan untuk menampilkan data dengan syarat tertentu. Dengan menggunakan autofilter, pengguna dapat memfilter atau menyaring data berdasarkan kriteria tertentu, seperti nilai tertentu, teks tertentu, atau rentang tanggal tertentu. Autofilter memungkinkan pengguna untuk melihat hanya data yang relevan atau yang memenuhi kriteria yang ditentukan, sehingga memudahkan analisis dan pemrosesan data.

The correct answer is =SUM(B3:D3). This is because the SUM function is used to calculate the total sum of the values in a range of cells. In this case, the range B3:D3 represents the production of sedan cars for the past 3 years. By using the SUM function, we can add up the values in these cells to get the total production of sedan cars for the past 3 years.

The correct answer is =IF(A3>100,”Door Prize”,”Kasihan Deh Lo”). This formula is using the IF function in Excel to check if the value in cell A3 is greater than 100. If it is, it will display "Door Prize", otherwise it will display "Kasihan Deh Lo".

The given formula is =10+6/2*3. According to the order of operations in mathematics, we need to perform the division first, then the multiplication, and finally the addition. So, 6 divided by 2 equals 3, and then 3 multiplied by 3 equals 9. Finally, adding 10 to 9 gives us the result of 19.

The correct answer is =B9*D9 because when the formula =B4*D4 is copied from cell F5 to cell F10, the formula adjusts automatically based on the relative position of the cells. In this case, since the formula is copied down, the row numbers in the formula also change accordingly. So, when copied to F10, the formula becomes =B9*D9.

The correct answer is "Kuda" because the given formula is an IF statement that checks the value in cell B3. If B3 is equal to "A", the result is "Anjing". If B3 is equal to "B", the result is "Bebek". If B3 is equal to "C", the result is "Cicak". If none of these conditions are met, the result is "Kuda". Since B3 contains the letter "E", which does not match any of the conditions, the result is "Kuda".

The formula in cell C1 checks two conditions: if the value in cell A1 is greater than 50 and if the value in cell A2 is less than 100. In this case, the value in cell A1 is 49 and the value in cell A2 is 102, so both conditions are not met. Therefore, the formula will return the value 200, as specified in the formula.

The correct answer is =MID("INDONESIA",4,3). This is because the MID function is used to extract a specific number of characters from a text string, starting from a specified position. In this case, the function will start at the 4th position of the word "INDONESIA" and extract 3 characters, resulting in the word "ONE".

The correct answer is "Data" because to sort data, we need to access the data itself. The "Data" menu typically contains options such as sorting, filtering, and organizing data in a spreadsheet or database. Therefore, selecting the "Data" menu is the appropriate choice for sorting data.

The correct answer is "Bar" because a bar chart is commonly used to compare different categories or groups. It uses rectangular bars of equal width to represent the data and the length of each bar corresponds to the value of the data. This type of chart is effective in visually displaying comparisons between different categories or groups.

The correct answer is =VLOOKUP(B30,$B$36:$D$40,3). This is because the VLOOKUP function is used to search for a value in the first column of a range and return a corresponding value in a specified column. In this case, we want to search for the value in cell B30 and find the corresponding value in the third column of the range $B$36:$D$40, which is "Melompong".

The correct answer is "=IF(B7>=70,"LULUS","REMIDIAL")" because it uses the logical function IF to determine whether the value in cell B7 is greater than or equal to 70. If it is, the formula will return "LULUS", indicating that the student has passed. If it is not, the formula will return "REMIDIAL", indicating that the student needs to take remedial action.

not-available-via-ai