WorksheetsLatihan Soal ICT Level 7
Total questions: 45
Worksheet time: 29mins
What is the device called the brain of the computer?
A computer consists of 3 main parts, including ...
Hardware, Software, Brainware
Which of the devices below is not an input device?
Projector
In computer specifications, we usually see Intel Core i5 or AMD Ryzen 5. What does that indicate?
Monitor
HARDDISK
RAM
Processor
The hardware part functioning to enter data or programs in the form of digital data that will be processed by the computer is?
Which includes storage devices?
SSD
The software is included in the section?
Browser
Antivirus
Application
Operating System
Which is not an example of a job that includes brainware?
Farmer
Gamer
Who is the inventor of Microsoft Office?
Bill Gates
The extension of a Microsoft Word file is?
The following menus are available in Microsoft Word, except ...
Page Layout
References
Data
If we want to create an invitation to send to many people in Microsoft Word, what features can we use?
Slide
Mail merge
Google form
Google Drive
To use the Mail Merge function, there are 2 applications needed, namely ...
Ms Word & Ms Powerpoint
Ms Word & Ms Excel
Ms Powerpoint & Ms Excel
Ms Excel & Photoshop
To combine more than 1 column or row using, we can use ...
Merge & Center
Wrap Text
Chart
Currency
Formula operations in Microsoft Excel always start by using a ... symbol.
()
;
Excel files are saved with what extension format?
This type of diagram is also called a ... diagram.
pie
Circle
Doughnut
bar
A function in Ms. Excel that is used to read tables horizontally is ...
What is the main function of AppSheet?
making presentations online
managing social media
developing mobile and web applications without coding
designing game characters
Which type of view would be most suitable for displaying image galleries in AppSheet?
What is the "Image" data type in Appsheet used for?
filling in date
uploading photo
uploading document files
filling in time/hour
What data type is used to input the user's location in Appsheet?
Image
Text
LatLong
Enum
To input date data into the AppSheet according to today, you can use the initial value ...
Key columns cannot be the same, and that's why the appsheet has a key generator. It is ....
LIST()
UNIQUEID()
HERE()
TIME()
The "Father of Computers" is…
(a)
The main components of a computer that cannot be touched are called …
(a)
The keyboard combination keys used to save documents is ...
(a)
To add a table in Microsoft Word, use the menu …
(a)
The meeting between columns and rows in Microsoft Excel is called (a)
The formula for multiplying the numbers in cells A1 & B1 is …
(a)
The function in Microsoft Excel that is used to read tables that are located vertically is...
(a)
The type of AppSheet used to display a drop-down menu that allows the user to select one value from a given list of values is..
(a)
The most common data source used to create applications in AppSheet is…
(a)
The examples of applications used for browsing, Except ...
Google Chrome
Mozilla Firefox
Microsoft Edge
Microsoft Word
The examples of applications that can be created using Appsheet, except ...
Class Cash App
Class Attendance App
Class Inventory App
Design App
What the difference between Enum & EnumList data types in Appsheet?
What is the formula for finding the lowest value on the sheet?
=MAX(A2:B10)
=MIN(A2:B10)
=MIN(A2:A10)
=MAX(A2:A10)
To find out the amount of Ahmad's money from January 2 to January 4, what is the formula?
=SUM(C2:E6)
=SUM(C2:E2)
=SUM(C6:E6)
=SUMIF(C2:D2)
Based on the Goods Sales List table below. The appropriate formula analysis used to find item name data is...
=HLOOKUP(C3;A10:C13;3)
=VLOOKUP(B3;A10:C13;2)
=HLOOKUP(B3; A10:C13;2)
=VLOOKUP(B3;B10:C13;3)
If the graduation requirements are >=80, then those who pass are...
Dede, Asep, Eka
Dede, Eka
Ade, Dena
Asep
If the PASS requirement is >=85 then CELL D6 is filled in with the following formula...
=IF(C6>85;"PASSED";"NOT PASSED")
=IF(D2>85;"PASSED";"NOT PASSED")
=IF(C6>=85;"PASSED";"NOT PASSED")
=IF(D2>=85;"PASSED";"NOT PASSED")
The result of =SUM(C11:E11) is ...
(a)
The result of =MAX(C7:C11) is ...
(a)
The result of =MIN(E7:E11) is ...
(a)
The result of =IF(E7>=80;”PASSED”;”NOT PASSED”) is ...
(a)
