Font size
WorksheetsLONG TEST IN ETECH (ICT, ONLINE SAFETFY, WORD, EXCEL)
Total questions: 75
Worksheet time: 37mins
An act transmitting messages.
(a)
Invented the World Wide Web
(a)
The magazine that declared Makati City, Philippines as the selfiest city around the world.
(a)
This refers to the knowledge obtained from reading, investigation, study or research.
(a)
This dynamic webpage focuses on user participation.
(a)
Users are just merely readers of the content of the webpage.
(a)
This enables users to find information through tagging.
(a)
An operating system that is used by Nokia devices.SYMBIAN
(a)
An operating system for pocket PCs.
(a)
This allows users to interact, communicate, and share information in a virtual community.
(a)
ICT deals with the use of different communication technologies that locates, saves, send, and edit information. This acronym stands for?
Information and Communications Technology
Inform and Communicate Technology
Information and Computing Technologies
Informing and Computing Technologies
At the age of 49, Lola Maria created her Facebook account, and learned to use Messenger as a medium for communication. Her grandchild taught her how to use these two social networking sites. As a digital person, her grandchild is considered as _______________.
Digital Immigrant
None among the options
Digital Native
Both Digital Native and Digital Immigrant
Through Tim Berners-Lee proposal, this system was developed which enables the user to access hypertext documents and other files over the Internet.
World Wide Web
Web 2.0
Web 1.0
Web 3.0
There are three versions of web: Web 1.0, Web 2.0 and Web 3.0. Which one is not a key feature of Web 2.0?
Mass Participation
Vagueness
Software as a Service
Long Tail
. One of the key features of Web 2.0 refers to diverse of information sharing through universal web access.
Mass Participation
Software as a Service
Vagueness
Long Tail
Innovation is a common thing in the ICT industry. The _______________ media is a non-profit service designed to help the people who have visual and reading impairments.
Assistive
Folksonomy
Blogging
Social
Developed by Google, Android is an open source operating system that is being used by several mobile phone companies. Which device uses iOs?
Nokia devices
Blackberry devices
Smart TVs
Apple devices
Which of the following is not a component of the mail merge?
File name
Data source
Main Document
Merge Document
What feature of Microsoft Word allows you to efficiency create documents that have the same general content but may have different recipients or purpose.
Print merge
Mail merge
View merge
Send merge
Social Media is a website, application, or online channel that enables web users to create, co-create, discuss, modify, and exchange user-generated content. Which one of the options is NOT an example of social media?
Social Networks
Social Networks and Media Sharing
Media Sharing
None among the option
Currently, this is the fastest mobile network.
(a)
Name the Logo.
(a)
Name the Logo.
(a)
Name the Logo.
(a)
Name the Logo.
(a)
Name the Logo.
(a)
It displays unwanted ads when a user is surfing the internet.
(a)
This is a form of malicious software and internet fraud that misleads users into believing there is a virus on their computer and convince them to pay for a fake malware removal tool.
(a)
They present themselves as harmless computer programs so that hackers can penetrate your computer without being detected.
(a)
It can monitor your keystrokes, read and delete your files, reformat your hard drive, and access your applications.
(a)
These are unwanted emails.
(a)
They usually make their way on to a computer via a malicious email attachment or USB stick.
(a)
They are often attached to files for download, shared via CDs, DVDs, and USB sticks, or loaded on to computers by opening infected email attachments.
(a)
This is often linked to identity and intellectual property theft
(a)
These are official-looking emails that are sent impersonating a well-known provider, such as a bank.
(a)
A code of good behavior on the Internet
(a)
This is defined as an information superhighway.
(a)
They create web pages mimicking that of a trustworthy business, such as an online banking log-in page.
(a)
This records a user’s keyboard input.
(a)
This is not a direct threat but many can contain malware.
(a)
It leaves your computer completely unprotected.
(a)
Which of the following cannot be inserted in yourdocument?
Chart
ClipArt
Shape
Sound
Where can you find the Start Mail Merge button?
Mailing tab
File tab
Home tab
Layout tab
What types of document you create using mail merge?
Posters
Letters
Envelopes
Labels
What button allows you to see the result of your mail merge even before you print or send it out?
Address block
Greeting line
Insert Merge Field
Preview Results
What file contains the information you need to merge with your main document?
Address block
Greeting line
Contact List
Directory
What are the steps in creating a simple mail merge?
Create data source; insert place holders; preview; print
Preview; insert place holders; create form document; print
Create main document; create data source; insert place holders; preview
Create form document; preview; insert place holders; print
Under what ribbon group does “Insert ► Shape” fall?
Media
Pages
Illustrations
Apps
What image compression/file type is capable of displaying simple animation?
.gif
.bmp
.jpg
.tiff
Among the text wrap options, which one allows you to place an image or external material in line with the text, treating the image like how a text is treated?
Square
In line with text
Tight
Through
What external material allows you to insert organizational or structural templates like organizational charts and flow charts on your document?
Smart Art
Chart
Screenshot
Pictures
Which image compression type allows you to display images in full color just like in digital pictures?
.tiff
.gif
.jpg
.bmp
Where can you find the Citations and Bibliography in MS Word?
Mailing tab
Home tab
Reference tab
Insert
What features of MS Word that corrects common spelling errors well as capitalization?
AutoFormat
Grammar Checker
Auto checker
AutoCorrect
What application program designed to create spreadsheets which can later be used to analyze statistical data?
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Publisher
What feature of MS Excel that can contain up to 1024 characters and must always start with an equal sign (=).
Absolute Referencing
Formula
Functions
Relative Referencing
What number format that puts a dollar symbol before each value by default?
Percent
Currency
Comma
date / time
What symbols that tell Excel exactly what type of calculations to perform.
Math Operators
Symbol Operators
Absolute Referencing
Relative Referencing
What function that adds a range cells.
ADD
PLUS
TOTAL
SUM
What do you call the cells that do not change?
Math Operators
Symbol Operators
Absolute Referencing
Formula Operators
This is the tab in the Format Cells dialog box where you can change the orientation of a text.
View
Orientation
File
Alignment
What function that gets the average of range of cells?
MEDIAN
AVERAGE
MEAN
SUM
Which among the following is not part of the syntax for AVERAGEIF?
Logical Test
Range
Average Range
Criteria
Short cut key for Display Go To Dialog Box
(a)
What function used to add a certain range of cells if a condition is met?
ADDIF
TOTALIF
SUMIF
PLUSIF
What features of MS Excel refers to the angle at which a text is displayed?
Layout
Layout View
Orientation
Formula in Cell
What function used to count the cells with content in a range?
COUNTNOW
COUNTING
COUNTIF
COUNT
Which among the following is the shortcut key for the Format Cells dialog box?
Ctrl + F
Alt + F
Ctrl + 1
Shift + 1
What syntax used in the AVERAGEIF function that includes the value or label that determine if the cell is part of the range to be average?
Criteria
Range
Logical Test
Average Range
SHORT CUT KEY FOR SELECT ALL
(a)
SHORT CUT KEY FOR BOLD TEXT
(a)
CTRL + C
(a)
SHORT CUT KEY FOR SHOW FONT DIALOG BOX
(a)
SHORT CUT KEY FOR CUT A SELECTED TEXT
(a)
CTRL + Y
(a)
