NEW
Font size
WorksheetsTech4Ed Post-Test
Total questions: 50
Worksheet time: 17mins
In Microsoft Word, creating a Template allows a user to __________
auto-save progress
start with a pre-set design
lock the file
translate text
In Microsoft Word, inserting a 3D Model allows the reader to __________.
add a video background
rotate the object 360 degrees
create a spreadsheet
scan for viruses
A user wants to check a document for advanced writing issues, such as clarity, conciseness, and formal language, beyond just spelling. Which feature should be used?
Microsoft Editor
Word Count
Thesaurus
AutoCorrect
A user has a list of names separated by commas in Microsoft Word and wants to instantly organize them into a grid. Which feature should be used?
Text Directions
Merge Cells
Columns
Convert Text to Table
The Immersive Reader tool in Word is built to __________.
translate files
hide toolbars
improve reading focus
summarize text
What is the fundamental difference between an Excel Workbook and an Excel Worksheet?
A Workbook is a single page, while a Worksheet is the entire file.
A Workbook is the entire file containing multiple pages called Worksheets.
A Workbook contains only formulas, while a Worksheet only contains text.
There is no difference; the terms are interchangeable
Which tab in the Excel Ribbon contains the options to insert PivotTables and Charts?
Home
Page Layout
Insert
Data
What is the primary use of the CONCAT function?
To calculate the average of a range of cells.
To combine text from multiple cells or strings into one single cell.
To find the highest value in a column.
To count only the cells that contain numbers
In Conditional Formatting, which category would you use to change the background color of cells based on the "Greater than or equal to" rule?
Data Bars
Icon Sets
Highlight Cells Rules
Color Scales
What is the correct way to save an Excel file as a PDF for easy sharing?
Change the file extension manually from .xlsx to .pdf.
Go to File > Export (or Save As) and select PDF from the file type list.
Take a screenshot of the spreadsheet and paste it into a photo editor.
Excel files cannot be saved as PDFs.
In Microsoft PowerPoint, the primary purpose of PowerPoint Designer is to __________.
Record the presentation with audio narration
Automatically generate professional design ideas and layouts for your slides
Translate text into different languages
Insert live camera feeds into the slide
Which of the following is a transition effect in PowerPoint that allows for smooth animation between slides by moving objects?
Flash
Split
Morph
Checkerboard
In PowerPoint, what is a Transition?
An effect that happens when you move from one slide to the next
An effect applied to text or images inside a slide
A tool to check for spelling errors
A way to print your slides
What does the Ribbon display in the PowerPoint interface?
A list of all recent files only
The speaker notes for the current slide
Tabs and available tools to discover contextual commands
The presenter view for the audience
Which action allows you to create a linked data visualization in PowerPoint?
Inserting a Screenshot
Inserting a 3D Model
Inserting a linked Excel Chart
Using the Dictate tool
Microsoft SharePoint is primarily described as a __________.
Video editing software
Social media platform for the public
Secure place to store, organize, share, and access information
Tool for fixing computer viruses
What is the SharePoint Start Page used for?
To delete all your emails
To find sites, news, and content you are following or working on
To format a Word document
To restart your computer
When you create a Team in Microsoft Teams, what is automatically created in the background?
A SharePoint Site
A Facebook Group
A Google Drive folder
A YouTube Channel
Which feature in SharePoint allows you to broadcast updates, stories, or status reports to your team?
News Posts
Recycle Bin
Site Settings
Page Layouts
Which page acts as the "Start Page" where you can see frequent sites and recent activity?
The Home Page
The Admin Center
The Permissions Page
The Workflow Settings
What is the common use of Microsoft Teams?
Gaming
Team collaboration
Photo editing
Hardware diagnostics
Which feature allows users to schedule and join virtual meetings in Teams?
Calendar
Files
Wiki
Chat
Teams allow for "Together Mode" which does what?
Merges multiple documents into one
Places meeting participants in a shared virtual background
Allow two people to use the same mouse
Send a group email to everyone
In the DepEd ecosystem, what is the primary account used to log in to Microsoft Teams?
Personal Gmail account
DepEd Microsoft 365 account
Yahoo Mail account
Facebook account
In Microsoft Teams, what is the primary difference between a Standard channel and a private channel?
A Standard channel is available to all team members, while a Private channel is restricted to a specific subset of people within the team.
A Standard channel allows video calls, while a Private channel only allows for text-based chat and file sharing.
A Standard channel stores files in SharePoint, while a Private channel stores files exclusively on the creator’s local computer.
A Standard channel can be seen by external guests, while a Private channel is only visible to the organization's IT Administrator.
A OneDrive user wants to organize disjointed project documents into a single container for better structure. What should they create?
A Shared Link
A Backup Plan
A New Folder
A Shortcut
A department using OneDrive needs a centralized space where files belong to the team rather than an individual. What should be created?
Personal Vault
Public Folder
Distribution List
Shared Library
A teacher wants to use OneDrive to collect student files securely without them seeing each other's submissions. Which feature is correct?
Request Files
Share Link
Manage Access
Copy Link
If a user accidentally removes an important document from OneDrive and needs to get it back, where should they go?
Version History
Shared with me
The Recycle Bin
Settings
Two colleagues are working on the same OneDrive Excel spreadsheet simultaneously and seeing edits in real-time. What is this process?
File Syncing
Check-out / Check-in
Co-authoring
Versioning
Power Apps for DepEd users consist of three (3) main data sources. Which of the following is the correct set?
SQL Server, MySQL, Oracle
SharePoint, Excel, Dataverse
Access, CSV, XML
Google Sheets, Firebase, SQL
In Microsoft Power Apps, which feature shows all screens, components, variables, and controls in a hierarchical structure?
Properties Pane
Formula Bar
Tree View
Data Pane
To make a container fill the entire screen in Power Apps, what values should be set for its Height and Width?
Screen.Height and Screen.Width
App.Height and App.Width
Parent.Height and Parent.Width
100% Height and 100% Width
What is the correct RGBA color code commonly used for DepEd blue in Power Apps?
RGBA(0, 0, 255, 1)
RGBA(0, 102, 204, 1)
RGBA(51, 153, 255, 1)
RGBA(0, 51, 153, 1)
True or False: Power Apps is a highly sophisticated coding language similar to Java or C#.
True
False
Maybe
None of the Above
Which feature is commonly found in Learning Accelerators?
Fixed pacing for all students
One-size-fits-all content
Real-time feedback
Manual grading
How do Learning Accelerators support differentiated instruction?
By adapting content to student needs
By removing student choice
By assigning the same tasks to all students
By embracing group work
Which statement best describes the role of teachers when using Learning Accelerators?
Technology supersedes teachers.
Teachers monitor technical issues.
Teachers are not involved.
Teachers facilitate and guide learning.
Which of the following best describes 'adaptive learning' as used in Learning Accelerators?
Instruction delivered only by teachers and school administrators
Instruction with feedback
Instruction that is not the same for all students
Instruction that changes based on student performance
Which feature is not included in the Learning Accelerators button of a class Team assignment creation interface but is still classified as a learning accelerator?
Reading Progress
Search Progress
Math Progress
Reflect
What is Microsoft Copilot primarily designed to do?
Replace Microsoft Office applications
Assist users with tasks using AI within Microsoft products
Act as a standalone antivirus program
Manage computer hardware settings
What type of technology powers Microsoft Copilot?
Virtual reality technology
Artificial intelligence and machine learning
Blockchain technology
Computer hardware drivers
How does Microsoft Copilot generate responses and suggestions?
By using pre-written scripts only
By searching files manually entered by users
By using artificial intelligence and large language models
By copying content from the internet without processing
Which task can Microsoft Copilot assist with in Microsoft PowerPoint?
Repairing damaged presentation files
Creating slides and suggesting presentation content
Installing new software on the computer
Managing email accounts
What is one key benefit of using Microsoft Copilot?
It works without internet access at all times
It eliminates the need for human decision-making
It increases productivity by automating and assisting with tasks
It replaces all IT professionals
Which type of password attack involves systematically trying all possible combinations of letters, numbers, and symbols until the correct one is found?
Dictionary Attack
Brute-Force Attack
Whaling Phishing
Content Injection
Which phishing attack involves sending highly personalized messages to a specific individual or group to trick them into revealing sensitive information?
Smishing
Vishing
Spear phishing
Pharming
What term describes the permanent record of everything an individual posts, uploads, or "likes" online?
Access control
Digital footprint
Data stewardship
Audit trail
Which type of adware is characterized as being "legal and transparent," where users specifically agree to view advertisements in exchange for free services like the Spotify Free version or YouTube?
Legitimate Adware
Deceptive Adware
Abusive Adware
Malicious Adware
What is the primary reason the sources advise scanning USB drives before opening them on school workstations?
To verify if the storage device is encrypted and password-protected.
To check if the files on the drive have been backed up to the DepEd Cloud.
To prevent USB-borne malware from spreading automatically and infecting school networks.
To ensure the drive is compatible with the latest Microsoft 365 updates.
