NEW
Font size
WorksheetsMidterm Examination - Living in IT Era
Total questions: 50
Worksheet time: 25mins
Which of the following is NOT a spreadsheet software?
Microsoft Excel
Google Sheets
LibreOffice Calc
Adobe Photoshop
In Excel, what symbol is used to start a formula?
@
=
#
$
What function is used to calculate the average of a range?
=SUM()
=AVERAGE()
=COUNT()
=ROUND()
Which shortcut inserts a new row in Excel?
Ctrl + R
Ctrl + N
Ctrl + Shift + +
Ctrl + Alt + R
What does the cell reference A1 represent?
Column A, Row 1
Row A, Column 1
Column 1, Row A
First worksheet cell only
Which chart type is best for showing percentages?
Pie chart
Line chart
Column chart
Scatter chart
Conditional Formatting in Excel is used to:
Sort numbers
Highlight cells based on rules
Merge cells
Create hyperlinks
What is the maximum number of worksheets in an Excel workbook?
1 only
Unlimited (limited by memory)
10 sheets
255 sheets
What function counts only numeric entries in a range?
COUNT
COUNTA
COUNTIF
SUM
Which of the following is a relative cell reference?
$A$1
A1
$A1
A$1
Which software is commonly used for presentations?
MS Word
MS PowerPoint
MS Excel
Adobe Premiere
Which file extension is default for PowerPoint?
.docx
.pptx
.xlsx
.jpg
Which view shows slides as thumbnails?
Slide Sorter
Slide Show
Reading View
Outline View
Which feature allows animation effects between slides?
Slide Transition
Slide Layout
Slide Master
Slide Theme
What shortcut starts a presentation from the beginning?
F1
F2
F5
F12
A slide master is used to:
Control overall slide design
Delete slides
Insert charts
Print slides
Which element is NOT typically part of a slide?
Title
Placeholder
Footer
Formula bar
In PowerPoint, SmartArt is used to:
Insert formulas
Represent data visually
Create pivot tables
Insert audio
The default orientation of a presentation slide is:
Portrait
Landscape
Square
Vertical
Which feature records narration in PowerPoint?
Record Slide Show
Slide Transition
Rehearse Timings
Insert Comment
Which of the following is an input audio device?
Speaker
Headphones
Microphone
Amplifier
Which unit measures loudness of sound?
Hertz
Decibel
Volt
Watt
Which connector is commonly used for headphones?
HDMI
USB
3.5mm jack
VGA
Which device converts sound waves into electrical signals?
Speaker
Microphone
Amplifier
Sound Card
Noise-cancelling headphones are designed to:
Amplify sound
Block background noise
Increase bass
Record audio
What does an audio mixer do?
Compresses files
Adjusts sound levels
Stores sound
Plays music
Which is NOT an example of an audio output device?
Earphones
Speakers
Soundbar
Microphone
What device converts digital signals to analog audio?
DAC (Digital-to-Analog Converter)
Microphone
Modem
Router
Which file format is commonly used for compressed audio?
.mp3
.wav
.txt
.docx
Bluetooth speakers transmit audio through:
Infrared
Wi-Fi
Radio waves
Wires
Digital literacy means:
Reading books online only
Ability to use digital tools effectively
Knowing how to repair computers
Only browsing the internet
Which of the following shows ethical digital behavior?
Copy-pasting without citation
Respecting intellectual property rights
Sharing passwords
Downloading pirated software
Strong passwords should:
Use only letters
Include numbers, symbols, and cases
Be simple and easy to guess
Be the same for all accounts
Which is an example of cyberbullying?
Sending study materials online
Posting hurtful comments on social media
Sharing useful links
Participating in an online class
Which law in the Philippines protects against cybercrime?
Data Privacy Act of 2012
Cybercrime Prevention Act of 2012
Anti-Bullying Act
Intellectual Property Code
A phishing attack is intended to:
Teach digital skills
Steal personal information
Fix software errors
Speed up browsing
Which is a cloud storage service?
Dropbox
MS Paint
Notepad
VLC Media Player
Which is the safest way to verify website security?
Check for “https” in the URL
Trust any email link
Ignore website warnings
Share personal data freely
Digital footprint refers to:
The trace of data left online by users
Footprints scanned digitally
Software updates
Cloud backup storage
Which of the following is NOT an example of digital literacy?
Evaluating online sources
Using productivity software
Understanding search engines
Handwriting letters only
Which is a search engine?
Which company owns Bing?
Apple
Microsoft
Amazon
The function of a search engine is to:
Store personal files
Index and retrieve web information
Create presentations
Play videos
Which of the following is NOT a search engine?
Yahoo
Baidu
Mozilla Firefox
DuckDuckGo
The “cache” in search engines refers to:
Stored copy of a webpage
Malware in a site
Paid advertisement
Website security key
Which Boolean operator is used to narrow a search?
OR
AND
NOT
BOTH
Search engine optimization (SEO) aims to:
Protect websites
Improve ranking in search results
Speed up computers
Remove viruses
Which search engine is most popular in China?
Baidu
Bing
DuckDuckGo
Which part of Google shows paid results?
Sidebar ads
Organic listings
Sponsored links
Search bar
Which search technique uses quotation marks (“ ”)?
Broad search
Exact phrase search
Exclusion search
Wildcard search
