Informatics School Pre-Test

Front

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

Back

Jeon Jungkook

Front

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

Back

=AVERAGE(D2:D8)

Front

What function can Lewandowski use in Excel to determine the time of the highest purchase of the day? Options: sorting, filtering, data validation, find and replace.

Back

sorting

Front

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 … .

Back

Informatics is easyI love informatics.

Front

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 … .

Back

kpz

Front

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 ….

Back

Local Area Network

Front

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 ….

Back

Rp 155.000,-

Front

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 ….

Back

0

Front

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.

Back

0

Front

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 … .

Back

Waze