Remedial Uas Kelas Xi ( Sebelas ) Sem. I Tahun 2016

To create a formula or equation in a spreadsheet, the equal sign (=) must be written at the beginning of the data. This signals to the software that the following characters are part of a formula and need to be calculated.

The correct answer is =MAX(L2:L7). This formula is used to find the maximum value within the range of cells from L2 to L7. It will evaluate all the values in that range and return the highest value.

The correct answer is = SUM(S3:S10). This is because the SUM function is used to calculate the total sum of a range of cells. In this case, the range specified is from cell S3 to S10, so the function will add up the values in those cells and return the total sum.

The correct answer is = SUM. The SUM function is used to add up a range of values in a spreadsheet. It allows you to easily calculate the total of a set of numbers.

The correct answer is "Start-Program-Microsoft Office- Microsoft Excel" because to open Microsoft Excel, you need to start the program, go to the Start menu, select the Program folder, find and open the Microsoft Office folder, and then open Microsoft Excel.

The given correct answer states that the Excel function SUM(B1:B5) is used to sum the numbers in the range from cell B1 to B5. This means that it will add up all the numbers in cells B1, B2, B3, B4, and B5 and provide the total sum as the result.

The correct answer is =MIN(H5:H12). This formula is used to find the minimum value within the range of cells from H5 to H12. The MIN function in Excel returns the smallest value from a given set of values. In this case, it will return the minimum value from the range of cells H5 to H12.

The correct answer is "Merge Center". This option is used when combining two column cells into one. It allows the content of both cells to be merged into a single cell, with the text centered within the merged cell. This can be useful for creating a more organized and visually appealing layout in a spreadsheet or table.

The formula used in cell D1 is "Min(A1:C1)", which calculates the minimum value among the numbers in cells A1, B1, and C1. Since the minimum value among 6000, 8000, and 9000 is 6000, the answer is 6000.

Jawaban yang benar adalah "Tidak lulus". Hal ini karena fungsi IF(A1>5,"LULUS","TIDAK LULUS") akan mengevaluasi apakah nilai di sel A1 lebih besar dari 5. Jika iya, maka akan menghasilkan "LULUS", jika tidak, maka akan menghasilkan "TIDAK LULUS". Karena nilai di sel A1 adalah 4, yang kurang dari 5, maka fungsi akan menghasilkan "TIDAK LULUS".

The function SUM(C1:C4) adds up the values in cells C1, C2, C3, and C4. The values in these cells are 24, 20, 17, and 23 respectively. Therefore, the sum of these values is 24 + 20 + 17 + 23 = 84.

The function MIN(C1:C4) will return the minimum value among the numbers in cells C1, C2, C3, and C4. The numbers in these cells are 24, 20, 17, and 23 respectively. The minimum value among these numbers is 17.

The correct answer is VLOOKUP. VLOOKUP is a command used to search for a value in a specified table and retrieve a corresponding value from another column in the same row. It is commonly used to perform vertical lookups in Excel and other spreadsheet programs. The "V" in VLOOKUP stands for vertical, indicating that the search is performed vertically in a column. It is different from HLOOKUP, which performs horizontal lookups in a row.

The correct answer is "Worksheet." In Ms. Excel, a worksheet is a single sheet within a workbook where data is organized and calculations are performed. It is used to enter, analyze, and manipulate data in a tabular format. A workbook can contain multiple worksheets, each identified by a sheet name, and they can be used for various purposes such as creating budgets, charts, and reports. Therefore, "Worksheet" is the appropriate term to describe a single sheet in Ms. Excel.

The correct answer is "Delete Column and row" because it states that both deleting a column and deleting a row can be done using the same command. This implies that there is a single command that can be used to delete both columns and rows, making it the most appropriate answer.

If we block the range from cell C2 to cell E9, it means we are blocking a total of 24 cells. This is because the range includes 3 columns (C, D, E) and 8 rows (2 to 9), resulting in a total of 24 cells being blocked.

The correct answer is "=IF(D4>50,”Naik Kelas”,”Tinggal Kelas”)". This formula checks if the value in cell D4 is greater than 50. If it is, it returns "Naik Kelas", indicating that the student has passed. If it is not, it returns "Tinggal Kelas", indicating that the student has failed. The quotation marks around the numbers in the other options are unnecessary and would cause an error in the formula.

The correct answer is =IF(D8>50,”Naik Kelas”,”Tinggal Kelas”). This formula checks if the value in cell D8 is greater than 50. If it is, it returns the text "Naik Kelas". If it is not, it returns the text "Tinggal Kelas".

HLOOKUP is the correct answer because it is a function used to search for a value in the top row of a table and return a corresponding value in the same column from a specified row. It is commonly used to search for data horizontally in a table.

The correct answer is "insert – row". This is because to insert a new row in a document or spreadsheet, the "insert" menu is used, and within that menu, the option to insert a row is selected.