Ani wants to create a personal finance report for a week so her pocket money does not run out quickly. Which sequence of steps is the most logical for Ani to perform?

A beginner programmer tries to calculate a math operation in a spreadsheet by typing =12 + 8 / 2. What result will the system display?

A teacher has student data that is very long, up to thousands of rows. He finds it difficult because when scrolling downward, the column headings (Name, Score, Remarks) disappear. Which feature should be activated?

In a competition, the committee has the scores of 10 participants in cells B1 through B10. They want to know how many people scored above 75. Which function is correct?

Rina is learning to copy formulas in Excel. She sees her friend using the $$symbol in a cell reference like$$ C$5. What is the main purpose of using this symbol?

A weather application records the highest temperature 25°C, the lowest 10°C, and the current 15°C. If the system uses a formula to find the difference between the highest and the lowest of the three numbers, what is the result?

Siska wants the title "DAFTAR NILAI KELAS 8" to be exactly centered across columns A through F without changing column widths. Which feature should be used?

A gate system uses logic: If vehicle weight > 5 tons, show the message "Danger"; otherwise, show "Safe". If the current vehicle weight is 10 tons, which message appears?

In an Informatics test, students are asked which cell address will not change at all (absolute) when the formula is dragged down or sideways. Which choice is correct?

After collecting questionnaire answers from all students, Andi notices some responses are unreadable or blank. He decides to fix the data. In the data analysis cycle, Andi is at the stage of...

A library has stock: Novels (50), Comics (100), and Magazines (30). The manager wants to know the average number of books for each category automatically. Which function should be used?

A journalist wants to share table data from a research result so others can open it using Microsoft Excel, Google Sheets, or even Notepad without breaking its structure. Which file format is most recommended?

While processing attendance data, the name "Dodi" appears twice with identical data. Why should the data processor delete one of the duplicate names?

A ticket pricing system decides: If age > 100, ticket is "Free"; if age = 100, ticket is "Discount"; if below that, ticket is "Normal". If a grandfather is exactly 100 years old, which category is obtained?

The neighborhood head wants to know how many residents throw trash at night by standing near the garbage bin without asking people. This data collection method is called...

You are asked to find the price of an item based on its item code in a reference table that is arranged vertically. Which spreadsheet function do you need?

On a worksheet, a student selects a block of cells from column A row 1 to column C row 3. What is the total number of cells in the block?

After calculating all height data of class 8A students, a researcher writes the conclusion: "The average height of class 8A is 155 cm." The researcher is performing the stage of...

In a cashier application, the system must check if the scanned item is not "egg". Which comparison operator is used to express "not equal to"?

A farmer wants to show buyers how chili prices have gone up and down each month over the past year. Which chart best shows this movement?

In a pie chart about students' hobbies, the category "Sports" takes exactly 25% of the circle. If the full circle is 360 degrees, what is the angle for "Sports"?

You create a bar chart with 3 different colors: Red for Male, Blue for Female, and Green for Teacher. To help people understand what the colors mean, which chart element should be present?

You are asked to compare the savings amounts among 5 different friends. Why is a bar chart recommended over a pie chart?

In a running competition, the times of 5 runners are recorded as 5 minutes, 8 minutes, 5 minutes, 10 minutes, and 12 minutes. If the data are sorted, what value lies exactly in the middle (median)?

A bar chart shows that ice cream sales are very high in January (summer) and very low in July (winter). The most logical interpretation is...

A teacher wants cells with values below 60 to automatically turn red so they are easy to recognize. Which feature should be used?

Out of a total of 200 votes in a class president election, candidate number 1 received 40 votes. If this result is shown in a chart, what percentage is the vote share of candidate number delighted ?

A student presents a chart without a title. Classmates are confused whether the chart is about body weight or height. This proves that...

A researcher wants to see whether there is a relationship between "Study Time" and "Exam Score" by plotting points on X and Y coordinates. Which chart should be used?

A hospital must ensure that a patient’s blood type data cannot be altered by a malicious person so that a wrong transfusion does not occur. This principle is called...

You have a survey file of classmates that contains home addresses and phone numbers. What is the safest way to send this data to the homeroom teacher?

A researcher publishes average national exam scores but replaces student names with initials or ID numbers to protect privacy. This process is called...

A raw file is 2 MB (2000 KB). After compression for secure transmission, its size becomes 500 KB. What is the ratio of the original size to the compressed size?

A business owner wants the company to look very profitable to investors, so the numbers in the report table are changed to turn a loss into a profit. This action violates...

To prevent a registration officer from entering an incorrect age (for example, 500), the system is limited to accept only numbers from 1 to 100. This feature is called...

A writer wants to work on an article at school, at home, and while traveling without carrying data cables or a flash drive. The best place to store the data is...

You want to create a folder key using 4 digits (0–9). How many possible number combinations would someone have to try to break it?

A store manager uses sales data from 2010 to determine stock for 2024. The most likely risk is...

An e-commerce company uses automated robots to collect price data from competitors’ websites every hour. The technical term for this activity is...

In a scholarship selection system, the requirement is: "Math score > 80 AND English score > 80." If Budi has 85 in both subjects, the logical output is...

A child may play on a phone if: "Has finished homework" or "Has helped Mom." This condition uses the logical function...

Cell A1 contains the word "Informatika." If you want to take the first 4 letters from the left so the result is "Info," which function should be used?

You have data for 5000 sales transactions. Your boss asks for a summary report: "What is the total sales per product category?" without calculating one by one. The fastest feature is...

Three friends have money: 10 thousand, 20 thousand, and 30 thousand. If each amount is multiplied by 2 (because they received a bonus), then the average money they have now is...

When using VLOOKUP, you want the system to return a result only if the lookup value matches exactly. In the last part of the formula, you should enter...

Andi interviews chili farmers directly (Data A), while Budi takes chili price data from the Statistics Bureau website (Data B). The correct statement is...

You want to calculate 15 to the power of 5 in a spreadsheet. Which formula should be typed?

A sociologist concludes "All Indonesian teenagers like K-Pop" after asking only 10 of their child’s friends. This analysis error is called...

You have a random list of names from C to A. You want to sort it so that names beginning with A appear at the top. Which feature do you click?