Font size
WorksheetsCCAS Final Exam Review Game 90 Questions
Total questions: 90
Worksheet time: 45mins
What are some important rules for creating strong passwords?
Use at least 8 characters, mix upper/lowercase, include numbers/symbols, avoid dictionary words.
Use only your birthdate and name for easy recall.
Keep your password short and simple for convenience.
Use the same password for all your accounts to avoid confusion.
Logic bomb: ________ code triggered by specific events.
Malicious
Encrypted
Obsolete
Temporary
Ransomware: Malware that ________ files and demands payment for release.
encrypts
deletes
compresses
shares
Denial of Service (DoS): Attack that ________ a system, making it unavailable.
overwhelms
protects
repairs
optimizes
Ways a virus spreads: Email attachments, infected downloads, USB drives, ________.
phishing links
antivirus software
firewall updates
safe browsing
Biometrics: Authentication using ________ traits like fingerprints or facial recognition.
physical
chemical
digital
virtual
Encryption: The process of encoding data to prevent ________ access.
unauthorized
authorized
encrypted
public
Benevolent hackers are also known as ________ hackers; they help find and fix security flaws.
white-hat
black-hat
grey-hat
blue-hat
Benefits of networks include resource sharing, communication, centralized data, and ________.
scalability
fragmentation
redundancy
isolation
Bluetooth is a short-range ________ technology for connecting devices.
wireless
wired
optical
magnetic
A smartphone is a mobile device with computing functions, apps, and ________ features.
communication
cooking
painting
swimming
Text messaging is sending short typed messages via ________ networks.
mobile
satellite
radio
television
Megapixels are a measure of camera ________; more means clearer pictures.
resolution
weight
battery life
color
Video on Demand is ________ video content anytime.
streaming
downloading
recording
editing
Podcasting refers to audio programs delivered over the ________.
internet
radio
television
satellite
Aspect ratio is the ratio of screen width to ________ (e.g., 16:9).
height
depth
brightness
contrast
Mashup: Content created by combining elements from multiple ________.
sources
colors
languages
devices
An E-reader is a device for reading ________ books (e.g., Kindle).
digital
paper
audio
comic
A database is an organized collection of ________.
data
books
furniture
paintings
Characteristics of good information include being accurate, timely, relevant, and ________.
complete
expensive
random
outdated
Data storage/retrieval is stored in structured formats (e.g., databases) for ________.
efficiency
security
redundancy
simplicity
The Turing Test assesses a machine's ability to exhibit ________-like intelligence.
human
animal
robotic
artificial
CAPTCHA is a test to distinguish humans from ________.
bots
animals
aliens
plants
Horizontal flow of information is sharing data between departments (e.g., sales to ________).
marketing
finance
production
human resources
Vertical flow of information: Strategic is for executives making ________-term decisions.
long
short
medium
immediate
Vertical flow of information: Tactic is for managers executing ________.
plans
meetings
budgets
reports
Vertical flow of information: Operational is for daily tasks by ________.
employees
managers
customers
shareholders
Data mining is analyzing data to find ________.
patterns
colors
sounds
shapes
A benefit of DBMS is data consistency, easier access, and improved ________.
security
latency
redundancy
complexity
Data cleansing is removing ________/incomplete data.
inaccurate
accurate
relevant
organized
What is the smallest unit of data storage?
Bit
Byte
Kilobyte
Megabyte
Byte is ______ bits.
8
4
16
32
Field is a single data ________.
element
table
record
file
Record is a collection of related ________.
fields
tables
files
databases
File is a group of ________.
records
files
characters
fields
Database is a collection of ________.
files
tables
folders
pages
Fill in the blank: The correct data storage hierarchy order is Bit > Byte > Field > Record > File > ________.
Database
Table
Folder
Document
Fill in the blank: Data = raw facts; Information = ________, meaningful data.
processed
random
deleted
encrypted
Which of the following is a good example of a primary key?
First Name
StudentID
Date of Birth
Address
Fill in the blank: A database administrator manages databases and ensures ________.
security
confusion
disorder
neglect
Fill in the blank: Metadata is data about ________ (e.g., file size, creation date).
data
music
colors
numbers
Where is the Quick Access Toolbar located?
Bottom-right corner
Top-left corner
Home tab
Insert tab
Fill in the blank: The Ribbon contains ________ commands.
grouped
random
hidden
separate
What is the default file extension for Word 2010 documents?
.xlsx
.doc
.docx
.txt
Fill in the blank: Format Painter copies ________ from one area to another.
formatting
text
images
numbers
Where are the Cut, Copy, and Paste options located?
Insert tab
Home tab
View tab
File tab
Fill in the blank: The default margin setting is ________ inch.
1
0.5
1.5
2
Which keyboard shortcut is used to copy?
Ctrl+V
Ctrl+C
Ctrl+X
Ctrl+P
Fill in the blank: The keyboard shortcut for paste is ________.
Ctrl+V
Ctrl+C
Ctrl+X
Ctrl+Z
Fill in the blank: The keyboard shortcut for save is ________.
Ctrl+S
Ctrl+P
Ctrl+O
Ctrl+Z
Fill in the blank: The keyboard shortcut for underline is ________.
Ctrl+U
Ctrl+B
Ctrl+I
Ctrl+Shift+U
Fill in the blank: The keyboard shortcut for end of document is ________.
Ctrl+End
Ctrl+Home
Alt+End
Shift+End
Fill in the blank: Bullets are found in the ________ tab.
Home
Insert
Design
Review
Fill in the blank: Leaders are dotted/dashed lines in ________ settings.
tab
page
font
margin
Fill in the blank: Theme refers to predefined ________/colors/styles.
fonts
shapes
icons
sounds
Fill in the blank: Watermark is background text/image. Design > ________.
Watermark
Header
Footer
Page Color
Fill in the blank: Worksheet = single spreadsheet; Workbook = file with ________ sheets.
multiple
single
empty
colored
Where are tabs located for navigating sheets?
Top
Bottom
Left
Right
What is the default file extension for Excel 2010?
.docx
.xlsx
.xls
.txt
Fill in the blank: Range is a group of selected ________.
cells
rows
columns
tables
Fill in the blank: Formula bar displays content/formulas of ________ cell.
selected
active
first
last
Fill in the blank: Functions are predefined ________ (e.g., SUM, AVERAGE).
formulas
tables
charts
cells
Fill in the blank: Absolute reference uses ________ (e.g., A 1).
$
&
@
#
Fill in the blank: Relative reference changes when copied (e.g., ________).
A1
$A$1
A$1
$A1
Fill in the blank: IF function parts: logical test, value if true, value if ________.
false
maybe
none
zero
Fill in the blank: Proof formulas use ________ tools to verify.
Formula Auditing
Charting
Sorting
Formatting
What is the formula to display formulas or gridlines in a spreadsheet?
Formulas tab > Show Formulas; View tab > Gridlines.
Home tab > Conditional Formatting; Insert tab > Table.
Data tab > Filter; Review tab > Protect Sheet.
File tab > Save As; Page Layout tab > Themes.
What is a cell name in a spreadsheet?
Cell reference (e.g., A1).
Sheet title (e.g., Sheet1).
Formula used in the cell.
The color of the cell.
What does the PMT function calculate in a spreadsheet?
Loan payment.
Interest rate.
Total loan amount.
Number of periods.
What does the FV function represent in a spreadsheet?
Future value of an investment.
File version of a document.
Frequency value of a dataset.
Format value of a cell.
What does the PV function represent in a spreadsheet?
Present value of an investment.
Projected value of sales.
Personal value of assets.
Previous value of data.
What does PEMDAS stand for in order of operations?
Parentheses, Exponents, Multiplication, Division, Addition, Subtraction.
Parentheses, Exponents, Multiplication, Addition, Division, Subtraction.
Parentheses, Exponents, Division, Multiplication, Addition, Subtraction.
Parentheses, Multiplication, Exponents, Division, Addition, Subtraction.
What is the default file extension for Access 2010?
.accdb
.mdb
.xlsx
.docx
Which of the following is NOT one of the 4 types of objects in a database?
Table
Report
Chart
Query
What is a record in a database table?
One row of data in a table.
A column header in a table.
A type of database software.
A unique key for each table.
What is a primary key in a database?
Unique identifier.
A type of database backup.
A column that stores duplicate values.
A field used for sorting data.
What is the function of join lines in a database?
Connect related fields in queries.
Delete duplicate records from tables.
Encrypt sensitive data automatically.
Generate random values for fields.
What do relationship reports show in a database?
Table relationships.
Data entry forms.
User passwords.
Database backups.
What does the navigation pane list in a database?
All database objects.
Only tables.
Only queries.
Only forms.
What is the purpose of a filter in a database?
View specific data temporarily.
Delete all data permanently.
Change the database structure.
Encrypt the entire database.
What is the maximum character length of a field name in a database?
64 characters.
128 characters.
32 characters.
255 characters.
What is the design view used for in a database?
Create/edit table structure.
Enter data into tables.
Generate reports automatically.
Sort records by default.
What is validation text in a database?
Message shown if rule is violated.
A type of database field.
A method to encrypt data.
A command to delete records.
What is a validation rule in a database?
Restriction on data entry (e.g., >0).
A type of database backup.
A method for sorting records alphabetically.
A tool for generating reports.
What is an input mask in a database?
Format for data entry (e.g., phone number).
A type of database relationship.
A method for encrypting data.
A tool for generating reports.
What is a one-to-one relationship in a database?
One record matches only one in another table.
One record matches many in another table.
Many records match one in another table.
Many records match many in another table.
What is a one-to-many relationship in a database?
One record matches multiple in another table.
One record matches only one in another table.
Multiple records match only one in another table.
Every record matches every record in another table.
What does referential integrity ensure in a database?
Ensures linked data is consistent.
Ensures data is always encrypted.
Ensures only numeric data is stored.
Ensures faster query execution.
What does an update query do in a database?
Modifies data in bulk.
Deletes the entire database.
Creates a new table.
Retrieves only the table structure.
What does an append query do in a database?
Adds records to another table.
Deletes records from a table.
Modifies the structure of a table.
Removes duplicate records from a table.
