NEW
Font size
WorksheetsBOCA Quiz
Total questions: 49
Worksheet time: 25mins
Which part of the computer is considered the "brain"?
Monitor
CPU
Keyboard
Mouse
The CPU consists of which major components?
ROM and RAM
ALU and Control Unit
Mouse and Keyboard
Printer and Scanner
Which device is used for permanent data storage?
RAM
Hard Disk Drive
Monitor
CPU
What does IoT stand for?
Internet of Topics
Information of Technology
Internet of Things
Input Output Terminal
Cloud computing mainly provides resources via:
Satellites
Local storage
Internet
Bluetooth
System software includes:
Operating System
Word Processor
Spreadsheet
Presentation software
Application software is used for:
System maintenance
User tasks
Network connections
Computer booting
Data mining helps in:
Data entry
Discovering patterns
Formatting documents
Creating graphs
OLAP stands for:
Online Analytical Processing
Office Location and Access Point
Open LAN Access Protocol
Outlook Application Program
Which symbol is used to start formulas in Excel?
@
#
=
$
To sum values in cells A1 to A5, which formula is correct?
SUM[A1:A5]
=SUM(A1:A5)
Add(A1-A5)
=ADD(A1:A5)
The intersection of a column and a row is called a:
Graph
Cell
Table
Formula
To apply formats automatically use:
Manual Format
Auto Format
Quick Access
Quick Styles
Which function finds average in Excel?
MEAN()
SUM()
AVERAGE()
AVG()
Conditional formatting is used for:
Changing font style
Formatting based on criteria
Adding charts
Adding equations
Linking workbooks allows data to be:
Hidden
Shared across files
Deleted
Printed
Pivot tables are mainly used for:
Data printing
Data analysis
Chart creation
Sorting data only
Which function returns today’s date in Excel?
DATE()
NOW()
TODAY()
CURRENT()
To filter data in Excel, use:
Insert menu
Data tab
Review tab
Home tab
Artificial intelligence is:
Human learning
Machine imitation of human intelligence
Physical exercise for robots
Manual processing
NLP stands for:
Neural Link Processing
Natural Language Processing
Node Language Programming
Non-Linear Programming
Business application of AI includes:
Making coffee
Automating decisions
Changing lights
Starting computers
Deep learning deals with:
Shallow networks
Large neural networks
Text formatting
Data entry
Which is NOT a technique of AI?
Neural network
Fuzzy logic
Comparison shopping
Expert system
An expert system is designed to:
Replace all human employees
Give advice and solve problems
Draw pictures
Run games
Machine learning is about:
Manually instructing machines
Machines learning from data
Changing screen colors
Formatting documents
Fuzzy logic is used for:
Binary decisions only
Handling uncertainty in data
Making websites
Filing reports
Supervised learning requires:
No data
Labeled data
Only images
Only text
Which is a real-life use of AI?
Browsing the internet
Facial recognition on phones
Turning on a fan
Drawing manually
To merge documents for mailing, use:
Conditional formatting
Mail-merge
Auto format
Quick Access
In Word, inserting images is done through:
Insert menu
Review tab
Page layout tab
View tab
A database table consists of:
Columns and rows
Only columns
Only rows
Cells without structure
To store multiple records, which object is used in Access?
Form
Table
Report
Query
Which key term in DBMS refers to a unique data type for each entry?
Record
Table
Field
Sheet
To retrieve specific data from tables, you use:
Query
Form
Table
Mail-merge
In Access, forms are used for:
Data entry and modification
Printing only
Formatting reports
Creating charts
Which Access object is used to print and summarize data?
Report
Table
Query
Form
Mail merge with Excel allows:
Connection of Word and Excel data
Formatting documents
Creating pivot tables
Encrypting data
In Access, manipulating table relationships involves:
Insert menu
Relationships tool
Page Layout tab
Review tab
Cybersecurity protects:
Only hardware
Only software
Information and systems
Printers
Popular cyber-attack type involving holding data for ransom:
Denial of service
Ransomware
Malware
Phishing
Cryptography is the science of:
Formatting data
Data encryption
Sorting files
Analyzing graphics
A firewall’s primary function:
Connect to internet
Prevent unauthorized access
Monitor printers
Print documents
Penetration testing is used for:
Fixing computers
Assessing vulnerabilities
Formatting hard drives
Styling reports
Digital forensics mainly deals with:
Audio editing
Investigating cyber crimes
Drawing images
Printing documents
Antivirus programs are used to:
Analyze documents
Remove harmful software
Format hard disk
Encrypt data
Which is a popular CRM application?
Canva
Salesforce
Google form
MS Word
Google Analytics is mainly used for:
Tracking website traffic
Formatting documents
Sending emails
Image editing
Google Workspace allows for:
Online collaboration and productivity
Offline gaming
Watching movies
Hardware repair
