Font size
WorksheetsLATIHAN PSAS
Total questions: 81
Worksheet time: 41mins
An antivirus program is used to …
Draw pictures
Create presentations
Protect the computer from viruses
Calculate data
The hardware that functions to store data permanently is …
RAM
ROM
SSD
The software that serves as a bridge between hardware and users is …
Application
Operating System
Utility
Driver
Canva is used to design UI for social media, presentations, posters, documents, and other visual content. The Canva application falls into the following categories:
Word processing application
Graphic design application
Presentation application
Number processing application
In 2013, Canva's feature that allowed users to collaborate in real time was...
Canva Pro
Canva Education
Canva for Teams
Canva Enterprise
Canva is an online graphic design platform that allows anyone to easily create various types of visual content. The Canva feature that allows users to remove image backgrounds is...
Magic Eraser
Transparent Maker
Background Remover
Canva has various downloadable file formats. Name the file formats that can be downloaded from Canva...
.exe
.psd
.jpg, .png, .pdf
.Docx
The Canva feature that allows users to automatically arrange the layout of design elements is...
Auto Arrange
Magic Layout
Intelligent Design
Smart Layout
Design files created in Canva have several save features. To save a design to a Canva account, users need to…
Download it to their computer
Save it to the Canva cloud
Save it to WordPress
Save it to Microsoft Office
A student wants to create a digital poster for an environmental campaign. The correct first step is…
Select a poster template in Canva
Type text in a worksheet
Download Adobe Illustrator
Create a table in Excel
To create an infographic design that is easy to read, students need to…
Use contrasting colors and concise text
Include all data in one image
Use multiple fonts
Eliminate visual icons
To create a simple learning video in Canva, the features used are…
Templates, text, images, and video editing tools
Spreadsheet functions and pivot tables
Programming scripts and code editor
3D modeling and animation tools
To create a website, we can use WordPress to make our work easier. The "Theme" function in WordPress functions to…
Manage server speed
Determine the appearance and layout of the site
Delete old content
Add new plugins
Someone who wants to learn how to create a website can use a "Content Management System (CMS)," one of which is WordPress. WordPress.com is a platform for…
Editing videos
Creating and managing websites/blogs
Designing posters
Writing program code
Website domain extensions come in various styles. The following free website addresses on WordPress.com usually end in...
.org
.edu
.com
.rf.gd
When we install a new printer, the computer needs a driver so that...
The printer can print with better colors
The operating system can communicate with the printer hardware
The printer can be used without cables
The printer can store documents
When we turn on the computer, but it cannot enter the operating system and only shows a black screen, the monitor light blinks, and a beep sound appears, the hardware most likely to be faulty is …
Hard disk
Monitors
RAM
Keyboards
To ensure there are no typing errors in the document, the feature that should be used is …
Page Layout → Orientation
Review → Spelling & Grammar
View → Zoom
Insert → Symbol
If we want to make a report with a wider left margin for binding, the setting to use is …
Page Layout → Orientation
Page Layout → Size
Page Layout → Margins → Mirrored
Page Layout → Margins → Custom
The feature used to create a mass letter document with name and address data is…
Mail Merge
Track Changes
SmartArt
Hyperlink
The document looks messy when printed. Analyze the most likely cause…
Incorrect margin settings and paper size
Too many hyperlinks
Too little text
Not using a template
A teacher gives two Word reports from her students. The best assessment criteria for choosing the more professional one are…
Content structure, formatting consistency, and readability
Attractive text color
If you want to sort student grades from highest to lowest, use the menu…
Text to Columns
Data Validation
Conditional Formatting
Sort & Filter → Sort Z to A
In an exam score list, the teacher wants to know the students' ranking. The formula used to display the rank is…
=SORT()
=RANK(B2, B 2: B 30,0)
=LARGE(B2:B30,3)
=MAX(B2:B30)
Miss Deandra is an ICT teacher who is preparing her class's grade report. How would Miss Deandra calculate the total scores from cells B2 to B10 in Excel…
=COUNT(B2:B10)
=SUM(B2:B10)
=AVERAGE(B2:B10)
=MAX(B2:B10)
The formula to display the text "Pass" if the value in cell D2 is ≥ 70 and "Fail" if it is less than 70 is…
=IF(D2>=70,"Pass","Fail")
=IF(D2<70,"Pass","Fail")
=IF(D2=70,"Pass","Fail")
=IF(D2>70,"Fail","Pass")
In evaluating an AppSheet application based on student attendance, the best indicator is…
Number of theme colors
Number of tables
Accuracy of attendance data and ease of input
Font size
To create an automatic status column of "Paid" if the payment is ≥ the total bill, the formula in AppSheet is…
IF([Payment]>=[Total],"Paid","Not Paid")
IF([Total]>[Payment],"Paid","Not Paid")
IF([Payment]=0,"Paid","Not Paid")
SUM([Payment])
When the AppSheet application displays duplicate student data, the appropriate evaluation step is…
Disable the input form
Add color to the table
Change the Chart View display
Check if the key column is unique
A computer technician is asked to improve the performance of an old computer so it can run heavy design applications. The most effective solution is…
Replacing the computer case
Increasing the RAM and SSD capacity
Deleting files in the Recycle Bin
Replacing the operating system with an older version
Design a simple strategy to optimize the performance of a low-spec school computer so it remains effective for online learning.
Use a lightweight OS, remove startup files, and use web-based applications
Use professional design software
Add graphic effects
Use high resolution
If a document contains more than 100 pages, what creative strategy can be used to maintain consistent navigation and formatting?
Save in TXT format
Copy the document to multiple files
Use a single font for all files
When creating scientific documents, tables of figures do not appear automatically. The most professional solution is…
Create a list of figures manually
Use the Insert Caption and Table of Figures features
Copy a table from Excel
Adding Lines Manually
If the formula =IF(AVERAGE(C2:C10)>70,"Good","Poor") produces inconsistent results, the correct evaluation step is…
Replace the formula with SUM
Change the range to A1:A5
Add quotation marks
Ensure all data is numeric
An analyst wants to evaluate workforce efficiency using Excel. The best feature to use is…
SmartArt
Mail Merge
Data Analysis Tool
Text to Column
If you want to create an attendance application with an automatic "Late" status based on the input time, the AppSheet expression to use is…
DATE([Time]>TIME("07:00:00"),"Late","On Time")
SUM([Time]>TIME("07:00:00"),"Late","On Time")
MAX([Time]>TIME("07:00:00"),"Late","On Time")
IF([Time]>TIME("07:00:00"),"Late","On Time")
If teachers want to create interactive presentation templates, the Canva feature they should use is…
Text only
Animation + Interactive Link + Audio
Screenshot from PowerPoint
Contrasting colors
To create a consistent school visual identity, the Canva feature they should use is…
Resize
Gradient Fill
Magic Write
Brand Kit
If they want to automatically display the latest articles on the front page, the feature they should use is…
Gallery
Page Template
Widget Recent Posts
HTML Editor
When a WordPress website experiences a performance decline even though the hosting is still adequate, the most effective evaluation step is to…
Remove unused plugins
Change the theme to the default theme
Analyze Database Queries with the Query Monitor plugin
Remove all images from the homepage
Which of the following are storage devices?
Hard disk
Keyboard
SSD
Touchpad
The main function of system software is…
Managing the operation of hardware and other software
Providing an interface between the user and the hardware
Creating text documents.
Creating digital multimedia.
RAM (Random Access Memory) is generally a flat circuit board with attached memory chips called memory modules. The main function of RAM is…
Storing data temporarily while the computer is running
Storing data permanently
Processing data
Displaying data
Microsoft Word is an application used for processing documents. The command used to save a document is…
File → Save
Ctrl + O
Ctrl + S
Ctrl + P
Microsoft Word has a variety of comprehensive features for processing documents, such as paragraph settings, line spacing, text type, text size, etc. The function of the Insert menu in Microsoft Word is…
Adjusting spacing
Changing the font type
Inserting images
Adding tables
The following are text formatting features in Microsoft Word:
Inserting images
Italics
Bold
Inserting numbering
Microsoft Excel is an application used to process numeric data. The data types in Excel are…
Numbers
Text
Dates
Images
The main data source for AppSheet can come from…
Google Sheets
Google sites
Google Slides
The UX (User Experience) feature in AppSheet is used for…
Writing program code
Automating certain processes
Customizing the application interface
Changing menu colors and icons
AppSheet is a no-code application development platform. The Automation feature in AppSheet functions to…
Changing the application design
Sending notifications automatically
Changing the application design
Creating automated workflows
Canva is a website for designing images and various multimedia products. The elements that can be added to Canva are…
Text
Images
Format Cells
Code Editor
To collaborate on designs, Canva provides the following features:
Share link
Format Cells
Comments
Code Editor
WordPress is a Content Management System (CMS), which means…
Game Engine Platform
Image processing application
Website management system
Adding themes and plugins
WordPress is a very popular and easy-to-use open-source content management system (CMS) for creating various types of websites. The functions of the WordPress Dashboard are…
Adding themes and plugins
Creating posts and pages
Managing users
Customizing site settings
Lakeisha has a laptop she uses for school, but the computer often freezes when running heavy programs. The possible causes are...
Overheating processor
Windows Bug
GPU not supported
RAM memory needs to be upgraded
Abilio is a laptop technician who wants to increase the speed of his customers' computers without replacing the CPU. The components that should be added are...
(Image of a keyboard)
(Image of a GPU)
(Image of a SSD: Samsung 990 PRO NVMe M.2 SSD)
If the monitor doesn't display an image, the problem is likely with...
Loose VGA/HDMI cable
Keyboard not working
LAN cable problem
Damaged graphics card
Ferrendra is a student at Al Abidin Middle School and serves as the Student Council Secretary at the school. When creating student council work reports, the appropriate feature to use in Microsoft Word is...
Styles
Header & Footer
AutoSum
Watermark
The feature used to analyze typing errors is...
Spelling & Grammar
Proofing tools
Track changes
Smart Art
Mr. Arkan is a teacher analyzing his students' grades. To analyze data for students with grades ≥ 75, what feature can Mr. Arkan use?
Wrap Text
Merge Cells
Conditional Formatting
Filter
If you want to search for data based on a specific column, the correct formula is…
(a)
Which of the following is a function in Google Sheets?
=HLOOKUP()
=LEFT()
=VLOOKUP()
=VLOOKUP()
AppSheet data stored in Google Sheets needs to be analyzed periodically to…
Ensure data consistency
Determine font style
Avoid duplication
Change the application theme.
To analyze application performance, users can check…
App performance analyzer
Activity log
Theme color
Font style
Seza's homeroom teacher asked her to collect official photos. The Canva feature that allows you to add a photo background is...
Audio mixer
Styles
Background tool
Upload image & adjust position
Nazran is working on an ICT assignment to create an animation on the Canva website. To create a simple animation in Canva, Nazran can use the features...
Animate
Insert object
Clipart
Page Animation
To analyze WordPress site performance, users can use...
Google Analytics
Plugin tool
Code editor
Site Health
When managing website security, the appropriate action is...
Update plugins and themes regularly
Use a security plugin
Grant free access to all users
Disable passwords.
Miss Tamara is an ICT teacher who wants to calculate the average student exam score using data from cells B2:B11. The formula Ms. Tamara can use is...
=AVERAGE(B2:B11)
=MAX(B2:B11)
=SUM(B2:B11)/COUNT(B2:B11)
=VLOOKUP(B2:B11)
If Mr. Kenzi wants to display the data on his report card with the text "PASS" if the score in cell C2 is 75 or higher and "FAIL" if it is less, the correct formula is...
=AVERAGEIF(A1:A10,">=80")
=COUNTA(A1:A10,">=80")
=COUNTIFS(A1:A10,">=80",B1:B10,"L")
=COUNTIF(A1:A10,">=80")
Khanza is working on an ICT assignment using Excel. Khanza is confused about the formula =VLOOKUP("Andi",A2:C10,3,FALSE). Help her understand this formula...
Sorting data
Searching for "Andi" in the first column of the range A2:C10
Retrieving the value in the third column of the found row
Calculating the average of the data
To edit design elements so they align proportionally, the features that can be used are...
Grid and Snap to Grid
Blur and Sharpen
Crop and Resize
Rotate and Flip
When creating a poster in Canva, important steps to take are...
Adjusting color contrast to your personal preferences
Choosing a template that suits your audience
Using a variety of fonts
Determining the design's purpose
In ICT learning practices, one way to improve WordPress security is...
Deleting the index.php file
Installing all plugins
Installing a security plugin
Regularly updating themes and plugins
Ahza was assigned by his ICT teacher to create a portfolio page in WordPress. The steps Ahza took were:
Choosing a theme that supports the portfolio
Creating a new page
Adjusting the parallax settings
Determining the appearance
Domains with the .sch.id extension are typically used for…
Company blogs
Personal blogs
Indonesian educational institutions
Official school websites
76. The working process of a computer from input to output involves which sequence?
Input → Processing → Output
Output → Processing → Input
Processing → Input → Output
Input → Output → Processing
Mr. Amar is an ICT teacher at Al Abidin School. Which Excel formula should he use to calculate the average grades of three subjects for seventh-grade students, starting from cells A1 to A3?
=AVERAGE(A1:A3)
=SUM(A1:A3)/2
=MEDIAN(A1:A3)
=COUNT(A1:A3)
Thorik has been asked to create a lab report to automatically calculate student grades, displaying "Pass" if the score is ≥75, and "Fail" if it is less than 75. Which formula should Thorik use?
=IF(score>=75, "Pass", "Fail")
=IF(score<75, "Pass", "Fail")
=IF(score>75, "Pass", "Fail")
=IF(score<=75, "Pass", "Fail")
A student wants to create a personal portfolio website on WordPress.com. Which of the following is the correct sequence of steps to make the site publicly accessible?
Publish the site and set its visibility to public in the WordPress.com settings.
Only save the site as a draft and do not change visibility settings.
Delete the site after creating it to make it public.
Set the site visibility to private and do not publish.
A WordPress blog displays slowly when accessed. What is a technical solution to speed up the website's performance?
Increase image sizes on the website
Disable caching plugins
Optimize database and enable caching
Add more external scripts
