Font size
WorksheetsU6 Unit 2 REVISION
Total questions: 100
Worksheet time: 50mins
Which datatype can store both text and numbers
Boolean
Image
Number
Text
In a database, a "form" allows you to...
Create a query
Enter data and edit it in a simple form that consists of the fields from a table
What are the 4 main objects in a database?
Tables, Forms, Reports, Keys
Spell Check, Grammar, Ruler, Tools
Tables, Queries, Forms, Reports
Cells, Columns, Rows, Sheet
Which of the following is an easy way to enter and browse data in a large database?
Forms
Tables
Spreadsheets
Records
While you can always enter data directly into database tables, you might find it easier to use ________.
queries
tables
forms
Which of the following would you use to display the data from a query in a professional format?
Table
Form
Query
Report
In a TABLE, a column is known as a...
Record
Field
Row
Data
In a database, all the information about one person or thing is called a
Worksheet
Presentation
Record
File
Which of the following would be used to uniquely identify a record?
Validation
Data type
Primary key
Field size
(a) must be common between two tables to create a relationship.
We can use (a) to answer, perform calculations, combine data from different tables, add, modify or delete data.
Check the three ways to delete the unnecessary slides.
Press the Delete key on the keyboard.
Select the first Slide.
Press the Backspace key on the keyboard.
Press the Ctrl key while clicking on the slides.
Right-click on the slide and select Delete Slide.
Which one is the display of MS PowerPoint?
What feature was used to center the heading “The Small Bookstore”?
Center
Merge and center
Merge
Wrap text
When a Spreadsheet is printed the gridlines are not automatically printed. What feature is used to get the gridlines as seen in the Spreadsheet above?
add gridlines
style
borders
table
What cell alignment feature is used so that the text looks like this?
Merge and center
Center
Wrap Text
Alignment
If the table is sorted in Ascending order by Classification, state the title of the book that will appear at the top from the list given below
In Touch with God
Eagle and the Falcon
The Dark Side
Outer Plant Experience
Besides being in the home tab, identify another tab in which the Sort option be found.
Data
Insert
View
Review
What is the number format of the values in the column Unit cost?
text
currency
number
two decimal places
What is the formula in Excel to calculate the Total cost of the book entitled Apocalypse using relative cell referencing?
24 * $51.00 =
= 24 * $51.00
E5 * F5 =
=E5 * F5
= E5 x F5
Type the formula in Excel to calculate the Total number of copies sold by the author James Brown. Use CAPS lock when typing your answer.
(a)
Select the ways in which data can be sorted (multiple answers)
Ascending
Descending
Filter
Custom
Sorting by Classification THEN by Title is a ..................
single column sort
multi column sort
custom sort
none of the above
What is software?
The intangible parts of the computer that tells the hardware what to do
The tangible part of the computer that allows programs to run
Decimal machines
A type of virus
Software can be split into two types. They are ... and ....
Systems and Application
Systems and Operating Systems
Application and Artificial Intelligence
Programming Languages and Artificial Intelligence
Systems Software is split into (select all that apply)
Digital Media
Operating System
Programming Langauges
Utility Software
Examples of OS
Windows
MacOS
Linux
Unix
Android
General Purpose software, is software that is widely available to the public and accomplishes common tasks.
True
False
Customized Software is
software that is widely available to the public and is used to solve common or general tasks
software that was written to serve a specific purpose in an organization
general-purpose software that has been modified to perform specific tasks for the user
Specialized Software
software that was written to serve a specific purpose in an organization
software that serves a particular task
software that combines several applications in one program
•software that is widely available to the public and is used to solve common or general tasks
What are all the examples of Utiltiy Software
Antivirus
File Management
Disk Cleanup
A videogame
Are these sources of external information used by the Industry Experts?
Select all the options that apply
Governments
Social Media
Witness statements
Newspapers
Journalists’ articles
Are these sources of external information used by the Banks?
Select all the options that apply
Websites
Social Media
Yearbooks
Telephone directories
Magazines
Are these sources of external information used by the News sources?
Select all the options that apply
Broadcasts
Official records
Witness statements
Newspapers
Journalists’ articles
Are these sources of external information used by the Government?
Select all the options that are applicable
Banks
Trade Associations
Websites
Newspapers
Industry Experts
PRINTED
BROADCAST
ONLINE
BROADCAST
ONLINE
Which of the following is NOT an example of Non-Print?
Microsoft Excel
Microsoft Powerpoint
Notepad
The following are examples of Print, except ...
Yearbook
Almanac
Atlas
Website
Which of these Non-Print resources talks about sound communication by waves, usually through the transmission of music, news, and other types of programs.
TV
Radio
CD player
Tape Recorder
Which of the following Non-Print resources can provide infinite information that you can read?
TV
CD player
Radio
Website
It is a Digital material where you can watch and upload different videos.
Youtube
Linked In
Below are sources of Digital material except ...
Tiktok
E-books
Journals
2. Mrs. Cometa used the chart which she bought from the local bookshop in explaining the water cycle.
broadcast
online
3. Alex tours around Tayabas city using the interactive map installed in his phone.
broadcast
online
Identity the authenticity
Registered to a government agency
Have an imprint
Privacy policy
Editorial board
Identify the source of information
(Interview)
Primary research
Print source
Media source
Online/digital electronic source
Identify the source of information
(Magazine)
Primary research
Print source
Media source
Online/digital electronic source
Identify the source of information
(Podcast)
Primary research
Print source
Media source
Online/digital electronic source
Which among the following sentences best describes secondary sources of information?
material that contains firsthand accounts of events and that were created contemporaneous to those events or later recalled by an eyewitness
publications that summarize and digest the information in primary and secondary sources to provide background on a topic, idea, or event
a work that is not based on direct observation of or evidence directly associated with the subject but instead relies on sources of information
a work of fiction by a person whose stories are reflected on his/ her work
It refers to
the department that manages information systems
in organizations.
management information system
Human resource department
Operation department
Administrative department
it is a type of system thatis suited for repetitive , large volume transaction computing task
Decision support system
office automation system
management information system
transaction processing system
A primary source is
an eyewitness account or a firsthand report of an event
a story told by someone
a piece of art, or a scientific evidence
an account told from someone's perspective
Select ALL the disadvantages of using a questionnaire?
participants' identity is protected
provides limited insight about the problem at hand
easily administered
misleading responses
HTML stands for
Hypretext Markup Language
Hypertext Media Language
Hyper Text Marker Line
Hypertext Mangement List
The structure of a web page is primarily created with which of the following?
HTML
CSS
Javascript
C++
The difference between a beginning tag and ending tag is the...
/
\
;
:
A web document must have which of the following tags?(multiple choice qn)
<html>
<body>
<p>
<img>
<head>
The structure of an html document will fall in between which tags?
<body></body>
<head></head>
<title></title>
<p></p>
sets the color of words in a paragraph
h1 {
color: pink;
}
img {
color: pink;
}
body {
color: pink;
}
p {
color: pink;
}
Select the rule set to make all the text in your web page blue and centered.
p {
color: blue;
}
body {
text-align: left;
color: blue;
}
p {
text-align: center;
color: blue;
}
body {
text-align: center;
color: blue;
}
Which tag is used to add an image?
<image>
<img>
<<img>>
</image>
What is missing from this HTML skeleton?
<!DOCTYPE html>
<html>
<body>
</body>
</html>
<head></head>
<div></div>
<img></img>
<head>
The title of the web page is located between which tags?
<head>
<html>
<body>
<header>
An HTML element is comprises of which of the following?
Beginning Tag
Ending Tag
Semicolon
Content
Colon
Consider the following for a specific paragraph: external style for <p> is green; internal style is blue; and inline style is red;
What will be color of the <p> content?
green
blue
red
black - default
Which of the following is an attribute of a tag?
href
src
a
mark
What are the three most common Web site structures?
Linear, vertical, hierarchical
Horizontal, vertical, random
Hierarchical, linear, random
Random, hierarchical, horizontal
Which of the following is not influenced by the Web site’s target audience?
Web authoring tools used
Overall look and feel of the Web site
Writing style and tone of content
Multimedia content used
Which of the following should not be considered when determining a Web site’s target audience?
Gender
Age
Nationality
Internet Address
The process of planning and creating websites.
web creation
website
web development tools
web content
What is a 'url'?
a computer virus
the address for a website
a webpage index
an automatic spellchecker
The computer that uses a browser on the web that sends a request via the internet is called ______
Client
Server
Internet
Where does the <title> tag appear on web page?
URL
At the top of a web page
In the browser tab
At the bottom of a web page
Which tag is where the web page content is placed?
<html>
<head>
<body>
<title>
What tag do you use to insert a hyperlink?
<p>
<img src>
<a href>
<div>
What does the term Emerging Technology mean?
Brand new ideas and systems using technology that are in the design phase which has not yet started to come out in the marketplace
New technologies that are currently developing which will ensure that there is minimal impact on our environment and to make society a better place to live
New technologies that are currently developing or will be developed over the next five to ten years, and which will substantially alter the business and social environment.
New design concepts which utilize the many new materials and technologies that have only recently been developed.
A tape recorder is considered to be _______
Emerging Technology
Current Technology
Obsolete Technology
Crazy Technology
Which of the following are advantages of emerging technologies?
(more than one correct answer)
Less chance of human error
Reduces employment workforce
Lower running costs
Opportunities for higher skilled workers
Where can new technologies be used?
Automation
Robotics
Specialist buildings
All of the above
What from the following are disadvantages of new and emerging technologies?
(more than one correct answer)
Loss of jobs
Health risks
Initial costs are often high
All of the above
What is the definition of a Robot?
A machine which resembles a human being
A machine capable of carrying out complex series of actions automatically, especially one programmable by a computer
A machine which can think for itself, especially if the thought processes are logical
Any machine which can follow instructions
Which of the following is not an advantage of robots?
They can be used in dangerous environments
They can assist humans with disabilities
They can replace jobs
They don't get tired or require a break
Artificial Intelligence has the potential to revolutionize many aspects of modern life
TRUE
FALSE
What technology enables the delivery of computing services over the internet?
(a)
What is the most common use of artificial intelligence?
Image Recognition
Speech Recognition
NPL
all of the above
In the 1960s computers became more compact due to what type of technology?
Microchip
Microwave
Micropower
Microsoft
PDAs were the first device to use what technology?
Touchscreen
Keyboard
Mouse
Headphones
Before CD's and DVD's were used, how were games loaded onto game consoles?
Cartridge
Download
Cables
Hard Drive
What does AI stand for?
Artificial Intelligence
Authentic Internet
Actual Intellect
Accurate Information
Which of the following is not an example of biometric technology?
Passwords
Fingerprints
Voice Recognition
Iris Scanner
Amazon Go is a no checkout experience meaning you don't need to pay for your shopping.
True
False
Firms that allow employees to use their own devices are embracing which of the following?
BYOD
Wearable computing
Cloud computing
Self computing
Which of the following involves practices and technologies to minimize the environmental effects of manufacturing and managing computing devices?
Cloud computing
Green computing
Autonomic computing
On-demand computing
