NEW
Font size
WorksheetsIT REVIEWER NG BEBE KO HEHE
Total questions: 51
Worksheet time: 24mins
One of the software of Microsoft Office that enables the users to clean, aggregate and visualize data.
Excel
Word
Sway
Forms
What does Data Design refer to?
The analysis and coding of data
The procedure of addressing and structuring data
The processing and output of data reports
The storage and retrieval of data
What is Predictive Analytics?
Atype of data analytics that examines past trends without forecasting future outcomes
Atype of data analytics that predicts the future base
Atype of data analytics focused solely on visualizing
Atype of data analytics that only identifies patterns
What does a timeline determine in data collection?
The scope and type of data to be analyzed
The time-period of the data to be collected depending on the decision to be made
The methods and tools to be used for data processing
The storage location for collected data
How does Business Intelligence support businesses?
By integrating data into various technologies to support decision-making
By storing data for long-term record-keeping
By enhancing employee productivity through training programs
By automating processes without analyzing data
What role does Data Analysis play in Business Intelligence?
It enables businesses to explore, analyze, and interpret data to identify patterns, trends, and correlations
tI focuses solely on storing data for future reference
I automates business processes without examining data
tI emphasizes employee training over data examination
What is the purpose of the Formula Bar in Microsoft Excel
It allows users to insert formulas for data processing
t displays only static text without any data processing
It serves as a tool for formatting cells and changing colors
What does the function SUM(A1:10) do?
Multiplies the values ni A1 to A10
Calculates the average of the values ni A1 to A10
Adds al the values in A1 to A10
Counts the number of
cells ni A1 to A10
What does the function SUM(A1:10) do?
Multiplies the values ni A1 to A10
Calculates the average of the values ni A1 to A10
Adds al the values in A1 to A10
Counts the number of
cells ni A1 to A10
What will the formula =A1+B1 return if A1 is 5 and B1 is 10?
15
510
10
5
How can you quickly fill a series of numbers in Excel?
Use the fill handle
Copy and paste
Use the SUM
function
Type them manually
Which of the following functions will return the highest number in a range?
MIN
AVERAGE
COUNT
MAX
In Excel, what does the dollar sign ($) signify in a formula?
It denotes a currency value
It makes a cell reference absolute (lock)
It makes a cell reference relative
tI is used for formatting
Which feature allows you to visually represent data
Pivot Table
Conditional Formatting
Data Validation
Chart
Which of the following is a common use of cloud computing in the workplace?
Local data storage
Remote collaboration and file sharing
Single-user applications
Hardware maintenance
What is phishing?
Amethod of network troubleshooting
Atype of cyberattack that tricks users into revealing
Away to improve system performance
Which of the following is an essential practice for ensuring cybersecurity in the workplace?
Ignoring software updates
Sharing passwords among coworkers
Using strong, unique passwords
Disabling
antivirus software
Which of the following technologies can help improve communication in the workplace?
Video conferencing tools
Word
processing applications
Database management systems
Local area networks
What was ARPANET?
The first name of the internet, which began as a research project of the US Department of Defense in the 1960s
Acommercial network used for business transactions ni the 1970s
Asatellite communication system developed for military use
Asocial media platform that emerged ni the 1980s
What does Analog refer to in Communication Technology?
A classifiction involving the transmiss on of continuous signals cepending on the amplituce or frequency
A method that exclusively uses digital signals for data transmissions
A technique for compressing to improve transmission speed
A system focus on satellite communication for broadcasting
What do wireless communication technology channels use to transmit data?
Fiber optic cables to convey signals
Electromagnetic waves to transmit data
Electric currents through wires
Infrared light for short-range communication
What is Telstar known for?
Being the first satellite launched that enables internet connection around the globe for satellite communication
Serving as a weather satellite that monitors atmospheric conditions
Functioning solely as a military reconnaissance satellite
Being a commercial satellite for broadcasting television signals only
It is a technology that converts voice into digital signals that can be transmitted over the internet.
Landline Telephony
VolP
Mobile Communications Protocol
Asoftware application used to access and view
W e b Browser
Website
World wide web
World war ||
Which of the following systems that originate social media?
Internet forums
Bulletin board systems
Both A and B are correct
All the above
A web platform that allows users to be connected virtually over the
internet.
Streaming Media
Multimedia
Social Media
Internet Media
How does social media help Small Medium Enterprises (SMEs)?
Through hosting website
Through online live selling
Through commercial
Through discounts
According to Philippine Star, which among the the year 2023 is the most type of problem in internet world?
Identity Theft
Online Scams
Why fact checking is a must?
To ensure the accuracy and reliability of information before sharing or acting on it
To increase the amount of information available to the public
To promote biased viewpoints and opinions
To save time by avoiding thorough research
It is a symbol used in at the beginning for integrating formula in Microsoft excel.
@
=
-
%
Which Excel formula can the user use to categorize the number
of sales as High or Low?
=IF(A1>100,"High","Low")
=AVERAGE(A1+A2)
=VLOOKUP(A1, B1)
=SUM(A1,A2(
=MAX(A1,A2)
According to RA 10173 (Data Privacy Act of 2012), what should you do fi your
friend asks you to share personal information about one of your classmates?
Share the information without hesitation, as it's harmless
Verify fi you have consent from the classmate before sharing
any personal information
Ignore the request and change the subject
Provide only basic information without considering privacy laws
In the DATA Analytics framework, which procedure determines what data should be collected?
Data Collection Procedure
Data Processing Procedure
Data Analysis Procedure
Data Requirement Gathering Procedure
What is the maximum time within which an organization must report a data breach to the National Privacy Commission (NC)?
72 minutes
72 hours
2 days
1 week
You discover that your social media account was hacked,
and someone posted content pretending to be you. What should you do under the RA 10175?
Delete your account
Report and change password
Post a message that you were hacked
Do nothing and hope it goes away
Under RA 10173 (Data Privacy Act of 2012), what should you do if you're asked to sign up for a service that collects your personal data, but you don't understand how your data wil be used?
Sign up anyway, as it may be beneficial
Request clarification on how your data wil be used before signing up
Ignore the request and move on
Sign up and read the privacy policy later
Under the Cybercrime Prevention Act of 2012, which agency is tasked with enforcing the law and investigating cybercrimes?
National Bureau of Investigation (NBI)
Department of Justice (DOJ)
Philippine National Police (PNP)
Department of Information and Communications
Which law provides the legal framework for electronic commerce, recognizing the
validity of electronic documents, contracts, and signatures in the Philippines?
Data Privacy Act of 2012
Electronic Commerce Act of 20
Cybercrime Prevention Act of 2012
Anti-Photo and
Video Voyeurism Act of 2009
Cloud computing, which became popular in the 2000s, allows businesses to:
Store data and run applications over the internet instead of local servers
Build websites without coding
Design graphics for marketing purposes
Secure files without encryption
Business Intelligence (BI) tools such as Power BI and Tableau are used in the workplace to
Analyze data for decision-making
Automate email communications
Secure network infrastructure
Design marketing materials
In modern workplaces, cybersecurity tools such as firewalls and antivirus software are essential for:
Protecting sensitive information
Enhancing graphics design
Managing social media campaigns
Organizing video conferences
Which of the following is prohibited under the Anti-Wiretapping Act of 1965 (RA 4200)?
Recording a phone call without the consent of either party involved.
Recording a public speech in an open event
Recording a lecture ni a classroom setting with permission from the professor
Encryption is a critical data protection measure used to:
Speed up internet connectivity
Securing data
Manage software development projects.
Back up data to local servers
What advantage do laptops and tablets provide to employees?
They restrict employees to work only ni the office
They allow employees to work from anywhere, making mobile computing
They limit access to company resources while on the go
Cybersecurity training in the workplace is important because it:
Reduces the cost of purchasing software
Educate employees to protect sensitive information from cyber threats.
Helps employees design websites
Eliminates the need for antivirus software
What is one of the major challenges of using TI in the workplace today?
Lack of modern technology
Trello
Cybersecurity threats
Microsoft PowerPoint
Video conferencing tools like Zoom and Microsoft Teams became essential in the workplace, especially during
The rise of personal computing ni the 1980s
The global pandemic and the shift ot
remote work
The advent of cloud computing ni the 2000s
The introduction of mainframe computers
Which law governs intellectual property rights, including software and digital content,
in the Philippines?
Anti-Camcording Act of 2010
Data Privacy Act of 2012
Intellectual Property Code of the Philippines
Free Internet Access in Public Places Act
What is the primary focus of the Anti-Photo and Video Voyeurism Act of 2009 (RA 9995)?
Protecting the use of electronic documents
Penalizing the unauthorized recording and
distribution of private acts
Regulating the use of online content for commercial purposes
Preventing illegal software distribution
Which of the following was one of the earliest uses of IT in the workplace?
Data processing and record-keeping
Social media marketing
Online video conferencing
Cloud computing
fI you receive a message from someone claiming to be your classmate, asking for your email password to help them with an assignment, what should you do?
Share your password, as they are a classmate and might need help
Ignore the message and do not respond
Verify the identity of the person by contacting them through another method before taking any action
Provide them with a temporary password instead
