Informatics School Pre-Test

1.         The youngest member of BTS’s full name is ….

• Jimin

• Min Yoongi

• Rap Monster

• Jeon Jungkook

To count the average net worth of all BTS’s member we can use formula such as ….

• =AVG(D2:D8)

• =AVG(C2:C8)

• =AVERAGE(D2:D8)

• =AVERAGE(C2:C8)

Lewandowski has a coffee shop. He makes a simple cash flow report to note the purchase history daily in Microsoft Excel. By the end of the report, he wants to know what time does the highest purchase of the day. To do so, Lewandowski can start by using … function.

• sorting

• filtering

• data validation

• find and replace

Variable first_phrase, second_phrase, and result_phrase are string variables. The first_phrase is ‘I love informatics’. The second_phrase is ‘Informatics is easy’. The program commands as follows:

result_phrase = second_phrase + first_phrase

The value of result_phrase is … .

• I love informatics. Informatics is easy.

• Informatics is easyI love informatics

• Informatics is easy. I love informatics.

• I love informaticsInformatics is easy

Variable A and B are string variables. The default value of A is ‘abc’. The program commands as follows:

B = A + 1

After the program executed, the value of B is ‘bcd’ (PS: Remember Caesar Cipher). If the user change the value of A into ‘joy’, the value of B is … .

• jpz

• kpy

• koz

• kpz

LAN is a computer network that interconnects computers within a limited area such as a residence, school, laboratory, university campus or office building. LAN is an abbreviation of ….

• Local Area Node

• Local Administration Network

• Local Area Network

• Local Associate Node

Your driver is in the gas station. He requests to buy 10 litres of Pertamax Turbo. Pertamax Turbo costs Rp 15.500,- each. The machine has an indicator display the price and the amount of gas. The petrol filler starts to fill the tank. The machine will stop automatically when the price indicator reach ….

• Rp 15.500,-

• Rp 155.500,-

• Rp 155.000,-

• Rp 150.500,-

A money counter machine in bank is counting a bundle of money. The machine has a screen showing the amount of money. Before the machine counts, the initial amount of money should be ….

• 0

• 100

• 1000

• blank

Before we solve problem using program, we need to understand the problem by increasing the common knowledge regarding the situation. For example, basketball score should be counted from … for both teams.

• 100

• 50

• 25

• 0

An "app" is a shortened form of the word "application". In the context of technology and computing, an app refers to a software program designed to perform specific functions on digital devices, such as smartphones, tablets, computers, and other electronic devices. The followings are the educational apps, except … .

• Waze

• Quizlet

• Duolingo

• Khan Academy