Search Header Logo

Informatics School Pre-Test

Authored by Nikolaus Permana

Computers

9th Grade

Used 2+ times

Informatics School Pre-Test
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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

Jimin

Min Yoongi

Rap Monster

Jeon Jungkook

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

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)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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,-

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?