UGRD-ITE6101-2417T
Prelim Quiz 1
Stanford Research Institute brought about ERMA, Electronic Recording Machine
Accounting project, which dealt with the automation of the process of bookkeeping in
banking. True
A computer is built to carry out instructions that are written in a very simple type of
language called? Machine Language
It is the year when the development of Arpanet began with the financial backing of the
department of defense.
1969
It is the year when the general electric corporation delivered its ERMA computing system
to the Bank of America in California. 1959
It a number is made up of just two possible digits, zero and one.
Binary
A Vacuum tube is a device used to amplify, switch, otherwise modify, or create an
electrical signal by controlling the movement of electrons in a low-pressure space. True
It is the year when Atanasoff and Berry came up with ABC prototype.
1939
Semiconductors are used in almost all electronic equipment in use today and have
revolutionized the world of electronics. False
It is known as a complex system consisting of many different components.
Microcomputer
UGRD-ITE6101-2417T
Prelim Lab Quiz 1
The abacus, also called a counting mechanism, is a calculating tool used primarily in
parts of Asia for performing arithmetic processes. True
It is the year when John V. Atanasoff devised the first digital electronic computer.
1937
A Vacuum tube is a device used to amplify, switch, otherwise modify, or create an
electrical signal by controlling the movement of electrons in a low-pressure space. True
It is the year when the general electric corporation delivered its ERMA computing system
to the Bank of America in California.
1959
Prelim Quiz 2
The given binary number: 1101111 if converted to hexadecimal is equal to? 6F
The given binary number: 011011111 if converted to octal is equal to? 337
The given decimal number: 26 if converted to binary is equal to? 11010
8 raised to 2 is equal to 64 True
The conversion of 27 octal to decimal is 23. True
It is the fundamental system of a computer based system.
binary numeral system
True 2 raised to 0 is equal to 1
The given decimal number: 55 if converted to octal is equal to?
65
The conversion of 71 octal to binary is 111001. True
2 raised to 4 is equal to 8 False
The conversion of 53 hexadecimal to binary is 1100101. False
A number system with fifteen possible values.
Binary
The given binary number: 110110 if converted to octal is equal to? 66
The conversion of 87 hexadecimal to binary is 11100001. False
The given decimal number: 55 if converted to octal is equal to? 67
UGRD-ITE6101 Computing Fundamentals EXAM
A bit is
A single binary digit
What is the decimal equivalent of the octal number 25? 21
Which part of the computer is responsible for performing calculations?
Control Unit
To convert binary to octal, you group binary digits into: Threes
Which binary digit indicates "off"? 0
The binary representation of the decimal number 5 is: 0101
What type of data can computers manipulate?
Words, numbers, images, and sounds
What is the primary function of a computer? To execute programs
Which memory type cannot be modified? ROM
The binary numeral system is based on which radix? 2
Which of the following is NOT a use of computers? Underwater basket weaving
What is a 'number system'? A set of numbers with operations
Which type of software helps in writing letters and reports? Word processing
Which device uses magnetic storage? Hard disk drive
Which computer was known for being able to store and save programs?
ENIAC
What type of computer is primarily used for personal tasks? Mainframe
In which generation were integrated circuits developed? Fourth generation
Which of the following is an example of a secondary storage device? Hard disk
What does MSB stand for? Most Significant Bit
Which of the following is a characteristic of third-generation computers?
Use of integrated circuits
Which of the following is NOT a component of a computer? Touchpad
What was the first minicomputer launched by DEC?
PDP-8
What does IC stand for in the context of computers? Integrated Circuit
Which component of the computer is referred to as its "brain"? Processor
The primary function of the ALU is to: Perform arithmetic and logic operations
The octal number 7 is equivalent to which binary number?
111
What does LSB stand for? Least Significant Bit
ted in binary as:
100
The base of the binary number system is:
2
In binary, the number 1010 represents which decimal value? 10
The CPU is also known as: Central Processing Unit
Which of the following is considered a logical operation? Comparison
To convert hexadecimal to decimal, you multiply each digit by: 16
Which operation is used to convert from decimal to octal? Division by 8
The octal number 10 is equivalent to which decimal number? 8
The octal system is based on which radix? 8
RAM is a type of:
Temporary memory
Which of the following is the hexadecimal representation of decimal 15?
F
Which of the following operations can computers NOT perform? Creative thinking
What technology significantly reduced the size of computers during the second
generation? Transistors
The first generation of computers used which of the following? Vacuum tubes
What is the main focus of the fifth generation of computers? Artificial Intelligence
Which numeral system is primarily used by computers?
Binary
The hexadecimal representation of the decimal number 10 is: A
In the octal system, the highest single digit is: 7
The conversion of 255 from decimal to binary results in: 11111111
In what decade did the evolution of computers begin? 1930s
The base of the decimal system is: 10
How do you convert decimal to binary?
Divide by 2
The binary number 1001 is equal to which decimal number?
9
The decimal system uses how many digits? 10
Which of the following is a function of the memory? Storing data and programs
What is the binary equivalent of the decimal number 8?
1000
The binary number 1101 is equivalent to which decimal number? 13
Which of the following is considered the first mechanical adding machine? Abacus
What is a punch card?A type of storage
The hexadecimal equivalent of binary 1110 is: E
Which of the following is NOT a base in number systems?
Quintary
The octal equivalent of the binary number 101010 is: 42
What does the acronym "ALU" stand for in computing? Arithmetic Logic Unit
In the hexadecimal system, what does "A" represent? 10
What are the two main types of memory in a computer? RAM and ROM
What is the purpose of input devices? To process data
Computers are subject to breakdown due to:
Fluctuations in electric current
How many possible combinations can a byte represent?
256
Artificial Intelligence focuses on:Mimicking human intelligence
What does the Control Unit do?
Directs the operations of the computer
Which component is responsible for executing machine language instructions?
Processor
Which of the following is a task that a computer can perform? Understand context
The binary number 1011011 is equivalent to which decimal value? 91
The process of grouping binary digits for conversion is called:
Padding
The binary number 1110 represents which decimal value?14
Computers can perform operations at:High speed
Which component connects the processor to other hardware?Motherboard
A printer is an example of:Output device
What is the name of the first electronic computer?ENIAC
256 The value of 16^2 in hexadecimal is:
The conversion process of binary to decimal includes:Subtracting
The PDP-8 was significant because it was the first:
Microcomputer
Which of the following operations is used in decimal to binary conversion?
Division
To convert binary to hexadecimal, you group the digits into:4
What is an essential requirement for a computer to produce accurate results?Correct
input data
Which of the following is NOT a valid hexadecimal digit?G
The most common input device is: Keyboard
What is the main advantage of using computers in science and research?They speed up
calculations and simulations
The binary equivalent of the octal number 17 is:
1111
To convert hexadecimal to octal, you first convert to
Decimal
What is one limitation of computers?They cannot think independently
A CD-ROM is classified as:Optical storage
How do you convert octal to binary?Replace each digit with its binary equivalent
2 How many digits are in the binary system?
The primary memory of a computer includes:RAM and ROM
Who invented the logarithm?
John Napier
What does the term "bit" refer to?A binary digit
Which of the following is used to convert decimal to hexadecimal?Divide by 16
The highest number in the octal system is:7
Which numeral system uses a base of 16?Hexadecimal
What is the primary purpose of storage devices?
To hold data permanently
The decimal number 4 is represented in binary as:
100
What is the binary equivalent of the hexadecimal number 1F? 111110
UGRD-ITE6101-2417T
Midterm Quiz 1
One single sentence is known as a paragraph. False
This refers to the characteristics of the letters, symbols, and punctuation marks in your
document.
Font
Refers to the orientation of the lines of a paragraph with respect to the margins.
Alignment
In which menu bar you can find the FONT setting in Microsoft word?
Home
It is an application that provides extensive tools for creating all kinds of text-based
documents.Word Processing Software
Templates are designed documents that are blank except for preset margins, fonts,
paragraphs formats, headings, rulers, graphics, header, footers.False
When you select text, it changes the color-becoming highlighted True
Document dimension is also determined by the orientation of the paper. True
Which formatting toolbar is used to change the upper case into lower case.
Paragraph are line of text that run along the top and bottom of every page.False
The amount of space between each line of the text in a paragraph. Line Spacing
This is a line that is drawn on one or more side of paragraph border
Document are also useful in arranging images Tables
False
It is consists of pattern or color that is displayed as a background of the text in a
paragraph. Shading
Which formatting toolbar is used a conditional formatting in excel file?
You can add new sheets to a workbook file or delete worksheets you no longer need.
True
Which formatting toolbar is used to add color to a selected column?
These are necessary part of most worksheets Dates
You can insert or delete rows and column TRUE
This find values for one or more cells that make the results of a formula equal to a value
you specify.Goal seeking
Worksheet can be collected into groups called?Workbook
This is the process of using spreadsheet to test how alternative scenarios affect
numeric results.Analysis
You can manually edit any part of a formula or a function, simply by selecting its cell and
making you changes in the formula bar.TRUE
Spreadsheet software has no ability to generate charts based on numeric data False
Which formatting toolbar is used center the text along the cell?
Which formatting toolbar is used merge the 1st column to the second column?
Which menu bar can you find the Charts?Insert
Numbers cannot be shown with or without commas, decimal points. False
The combination of the column letter and row number.Cell Address
Value This is any number you enter or number that results from a computation.
Which formatting toolbar is used change the alignment of the text to vertical, horizontal
etc.
It is easier to perform calculations on the results even if not sorted. False
Midterm Examination
Why is using "Styles" important in word processing?It helps maintain consistent
formatting throughout the document
In evaluating the usability of spreadsheet formulas for team collaboration, which aspect
is most critical?d.
The complexity of the formulasHow would you protect sensitive data in a spreadsheet
while allowing others to view it?
What formula would you use to calculate the total expenses if the values are in cells I1
to I10? =SUM(I1)
If you apply a formula that calculates the average but includes blank cells in the range,
how will this affect the result?
It will return an error
How can you create a pie chart to visualize the distribution of expenses in your
spreadsheet? Select the data range and choose Insert > Chart > Pie Chart
What would be the best approach to evaluate whether a formula is yielding correct
results? Cross-check the formula’s output against manual calculations
When analyzing sales data, what could be the consequence of not updating your data
regularly?
It may lead to outdated conclusions and poor decision-making
If you need to ensure that certain cells in a budget spreadsheet are always visible while
scrolling, what feature should you use?
Freeze Panes
What is the purpose of the “Mail Merge” function in word processing? Combining a
template with data for personalized documents
Which tool is useful for quickly checking the word count of a document?Word Count
How can ICT be used to enhance customer service in an organization?
Use automated chatbots and CRM systems
If you need to find and replace all instances of "2023" with "2024" in your spreadsheet,
what feature should you use?Find and Replace
How would you protect sensitive data in a spreadsheet while allowing others to view it?
Use password protection for the file
How can the "Table of Contents" feature enhance a large document?It automatically
updates page numbers as content changes
Which of the following functions is used to sum a range of cells in a spreadsheet? SUM
What could be the consequence of failing to update a formula after modifying data in
referenced cells?
The results may become outdated or incorrect
What is the function of the "Filter" feature in a spreadsheet?
To display only the data that meets certain criteria
How does ICT contribute to organizational efficiency? Provides real-time data access
and automation
How would you evaluate the importance of backing up spreadsheet data?
Regular backups protect against data loss due to errors or system failures
If you want to find the average of values in cells B1 to B10, what formula should you
apply?=AVERAGE(B1
In evaluating the benefits of using pivot tables, what is the most significant advantage?
They allow for dynamic data summarization and easier data manipulation
Which of the following technologies is part of ICT infrastructure?
Internet networks and servers
If you want to quickly analyze sales data for a specific product across multiple months,
what would you do?
Create a pivot table for detailed analysis
Which feature allows you to align text evenly on both the left and right margins?
Justify Alignment
Which skill is essential for professionals in an ICT-driven environment?
Proficiency in digital tools and communication technologies
Which of the following features allows you to create a visual representation of
data?Charting
What method would you use to calculate the total expenses from different categories in
your budget spreadsheet?
Use the SUM function with a range of cells
If you need to count the number of entries in column D that are not empty, which formula
would you apply?=COUNTA(D
If you want to concatenate the text in cells G1 and G2, which formula would you use?
=CONCATENATE(G1, G2)
What would be the best approach to consolidate data from multiple sheets into one
summary sheet?
Use the Consolidate feature or functions like SUMIF
In analyzing the effectiveness of your spreadsheet formulas, why is it important to check
for circular references?
They can lead to errors and prevent the formula from calculating correctly
How does the presence of blank rows or columns in a dataset affect data analysis?
It can disrupt sorting and filtering processes
How would you apply ICT tools to improve team collaboration in a project?
Use video conferencing and shared cloud platforms
If you notice discrepancies in your data analysis results, what should be your first course
of action?Review formulas and data entries for errors
When assessing the risk of errors in formulas, what evaluation method is most
effective?
Manually reviewing each formula for potential issues
If you have a dataset that includes dates and you want to filter it to show only the entries
from the last month, what should you do?Use the Filter feature and select the date
range
How does the "Track Changes" feature assist in document editing?
It records and displays edits made by multiple users
How would applying complex nested formulas impact the analysis of data in a
spreadsheet?It guarantees accurate results
How can you make a document more accessible for visually impaired readers?
Include alt text for images and use clear fonts
How can the use of visual aids, like charts and graphs, enhance the understanding of
data in a spreadsheet?They provide a clear visual representation of trends and
comparisons
Which of the following is a key feature of ICT in modern professions?Enhanced
communication and data sharing
What is the analytical significance of using logical functions (like IF) in your formulas?
They allow for conditional decision-making based on criteria
How does ICT support decision-making in organizations?By providing real-time data
and analytics
Which keyboard shortcut is commonly used to copy text in word processing?
Ctrl + C
How can you effectively compare data from two different years in your spreadsheet?
Create a side-by-side comparison table
When evaluating the efficiency of using formulas in a spreadsheet, what key factor
should be considered?The speed and accuracy of calculations
How do you create a bulleted list in most word processing software?
Click the bullet icon or use a shortcut
Which function would you use to count the number of entries in a range of cells?
COUNT
Which formula would you use to find the average of a range of cells?
AVERAGE
What is the best way to ensure consistent formatting across a long document?
Apply predefined Styles throughout the document
How might using absolute references (e.g., $A$1) versus relative references (e.g., A1)
affect your formula results when copying to other cells?Relative references change
while absolute references remain constant
When evaluating the accuracy of a spreadsheet's data analysis, what should be your
primary focus?
The reliability of the data sources and the formulas applied
What challenge might arise from overusing fonts and colors in a professional
document?
It can create a cluttered and inconsistent appearance
In evaluating different spreadsheet programs, what feature would most enhance user
experience?
Intuitive user interface and help features
How would you evaluate the effectiveness of data validation rules in a
spreadsheet?They prevent incorrect data entry and maintain data integrity
When assessing the impact of formulas on data integrity, what should be your primary
focus?
The accuracy of the data produced by the formulas
What is the primary role of ICT in education and training?
Facilitating online learning and resources
Why is it important to use section breaks in a word-processed document?
To apply different layouts or formatting within the same document
Which feature in word processing software helps correct spelling errors? Spell Checker
What is the purpose of cell references in a spreadsheet?To link data from one cell to
another
When analyzing the use of conditional formulas, what is the primary benefit of
implementing them in a spreadsheet?They automate decision-making based on
specified criteria
How can using "Track Changes" influence collaborative document editing? It enables
users to accept or reject suggested changes
When evaluating the need for advanced formulas in a spreadsheet, what factor should
be considered?The complexity of the data analysis required
In evaluating the necessity of using conditional formatting alongside formulas, what is a
key consideration?If it enhances data interpretation and analysis
What issue might arise if you use inconsistent data formats in a spreadsheet (e.g.,
mixing text and numbers in a column)?
It may lead to incorrect calculations and errors
Which tool is commonly used in ICT for virtual collaboration?Video conferencing
platforms
To find the maximum value in a dataset located in cells E1 to E20, what formula would
you use?=MAX(E1
How would you analyze the impact of using the wrong cell reference in a formula?
It can lead to inaccurate results and misinterpretation of data
To apply a formula that rounds a number in cell H1 to two decimal places, what would
you use?
=ROUND(H1, 2)
How does the "Page Layout" feature support document presentation?
It adjusts margins, orientation, and spacing for better readability
When assessing the collaboration features of a spreadsheet program, which aspect is
most important?
Real-time editing and commenting by multiple users
To calculate the total sales from a range of cells, which formula should you
use?=SUM(A1
How would you evaluate the appropriateness of using a specific formula for a data
analysis task?
By determining if it meets the analytical needs of the task
How can you quickly copy the contents of one cell to adjacent cells?Use the fill handle
How can the effectiveness of a formula be evaluated over time?By checking if it
remains relevant as data changes
To calculate the percentage increase from a value in cell C1 to a value in cell C2, what
formula would you use?
=(C2-C1)/C1
How would you apply conditional formatting to highlight expenses that exceed a budget
limit?
Set rules in Conditional Formatting to change cell color
What is the primary purpose of using a spreadsheet program?To manage and analyze
numerical data
What analytical advantage does a pivot table provide when working with large datasets?
It summarizes and reorganizes data for better insights
How could the use of complex formulas impact the performance of a large
spreadsheet?
It can slow down the spreadsheet and make it harder to manage
Which word processing feature would you use to generate a personalized letter for
multiple recipients?
Mail Merge
What might be a consequence of not using data validation in a spreadsheet?
It may allow invalid or incorrect data to be entered
What is the potential drawback of relying solely on automated functions in a
spreadsheet? .
It may lead to overlooking errors in the underlying data
When assessing the need for training in spreadsheet software for a team, what factor is
most critical?
The team's current proficiency level and the complexity of tasks required
What problem might arise if manual spacing is used to align text instead of tab stops?
The alignment might break when the document is printed or viewed on different
devices
How should the evaluation of formula accuracy be documented for future reference?
By storing it in a different file altogether
Which of the following would you use to highlight cells that meet a certain condition?
Conditional Formatting
When would you use the "Header and Footer" feature?To add text at the top or bottom of
each page
What does the "Freeze Panes" feature do in a spreadsheet?
Keeps specific rows or columns visible while scrolling
If a formula returns a #DIV/0! error, what does this indicate?The formula is dividing by
zero
To determine the current date in a spreadsheet, which formula should you use?
=TODAY()
In evaluating the effectiveness of charts in a spreadsheet, what should be your primary
consideration?
The ability of the chart to convey data insights clearly and accurately
How can you apply a formula to determine the number of times a specific item appears
in a list in cells F1 to F50?COUNTIF(F1, "item")
How can the "Find and Replace" feature improve efficiency?By locating specific words
and replacing them instantly
When applying a formula to calculate cumulative totals across multiple sheets, what
should you ensure for accurate results?
Ensure all referenced sheets are consistently formatted and named
How would you evaluate the impact of using complex nested formulas on a
spreadsheet's usability?
They can make it harder for users to understand and troubleshoot errors
Which ICT solution would you implement to secure sensitive company data?
Use encrypted cloud storage and firewalls
How would you assess the effectiveness of using a spreadsheet for tracking project
budgets?
It provides real-time data and allows for easy adjustments
Which feature allows you to track all changes made to a document?
Track Changes
How can over-complicating a spreadsheet with too many formulas affect its usability?
It can confuse users and increase the risk of errors
UGRD-ITE6101-2417T
Final Quiz 1
The predecessor of HTML is also known as ____ CERN
What version of HTML was developed in the year 2005? HTML 5
CERN is a European Organization for Nuclear Research True
HTML 2.0 was completed in what year? 1995
In what year does W3C maintained the specification of HTML? 1995
ATOM is a powerful text editor that can be used by any platform True
The Hypertext Markup language is not the standard language used on web for developing websites
True false
Websites include links to other sites in the form of Hypertext
Back-up is used to format the appearance of your website False
HTML file can be save as .html or .htm True
UGRD-ITE6101-2417T
Final Lab Quiz 1
In 1989, Berners-Lee proposed another kind of system called _______?
HTML
The Hypertext Markup language is not the standard language used on web for developing websites
False
This is a mark-up language used to create webpages and/or websitesHTML
HTML files are viewable in _____? Internet Browser
Websites include links to other sites in the form of Hypertext
UGRD-ITE6101-2417T
Final Quiz 2
Border is also known as values. False
This allows you to select element(s) where an exact property will be applied
Class selector
CSS allows you to apply style to many selectors twice. False
This is used to separate one selector to the other selector. comma (,)
Font-size property allows you to change the uppercase display of text or use a font’s
default setting. False
This selector is used to specify context Contextual selector
2px solid A#99AAA is also known as Attribute. False
Using an image as a background can also be done through CSS True
A CSS is composed of style rules that are understood by a web browser and then applied
to the corresponding elements within your document. False True
2EM in CSS is equivalent to 13pt False
UGRD-ITE6101-2417T
Final Lab Quiz 2
This is used to control the visual appearance of the html content. CSS
1em in CSS is equal to 12pt. True
This property is used to control how the image will behave in the background upon
scrolling.
Background-attachment
UGRD-ITE6101 Computing Fundamentals
The NSFpermit users to conduct private business over the systemFalse
Pre-Formatted Text is denoted by what tags? <PRE></PRE>
Each property declared in CSS must be terminated by a
semi-colon (;)
The ARPANET discontinued in 1994. False
The W3C Stands for World Wide Web Consortium
This is a document formatted with Hypertext Markup Language (HTML)
web page
Programmers use HTML tags to design and create websites tRUE
The HTML tags document was released in what year?1991
You cannot create slides from scratchFalse
The text in spreadsheet is also known as Labels Values
This is often used by professionals in doing computations Spreadsheet Application
A browser that is based on Internet Explorer's Trident Engine and is a robust and
powerful browser.
Built in paint tools also enable you to draw simple graphics and add them to your slides
True
An ID in CSS is also known as Selector
What is the conversion of 11011 (base 2) if to be converted to decimal
27
A browser that is based on Internet Explorer's Trident Engine and is a robust and
powerful browser SlimBrowser
What is the conversion of 43 (base 10) if to be converted to octal? 53
Attribute are used to format the appearance of your webpage False
Which of the following menu bar in spreadsheet application allow the use to add a chart.
INSERT
This is one of the problems that an ICT professional may encounter
Computer Viruses
Which of the following is not included in formatting the slides Adding charts based on
data
HTML documents can be a document file that contains two parts, the web content and
tags True false
This is the process of combining a form letter with the contents of database Mail merge
To add an audio file in the document which menu bar should a user click
INSERT
This version of HTML was the first to be set as the standard for future HTML
implementations HTML 2.0
The future of computing do not depends on both technical and ethical excellence False
Contents are retained in storage when the computer is turned-off.c True
Charts is spreadsheet is generated based on Data
A Popular Browser by Internet giant Google is known as Google Chrome True
Which of the following is not included in the basic design principles
Low voice
Placing the style="" attribute inside an HTML tag is what type of CSS Style Inline
By the mid of 1990 interest in the internet expands dramatically. True
This is a collection of information located on a server connected to the World Wide Web.
Website
CERN is a European Organization for Nuclear Research TRUE
Every Web server has an IP address TRUE
This is used to identify the font family, the boldness of font, and even the font style.CSS
Font
It is a special link which brings you from one page to another page on the web.Hyperlink
Font-size property is used to increase or decrease the size of a font.True
This property is used to change the face of a font. font-family
Font-variant property is used to create a small-caps effect. True
Which of the following is not a professional or an advanced text editor? Microsoft Word
A strong emphasized text is denoted by <B></B> False
What is the conversion of 43 (base 8) if to be converted to octal?
23
A collection of networked network is describe as being Inter-networked
It is a method by which you move around on the web Hypertext
This property is used to assign a background color to an element background-image
This is used to capitalize, uppercase, lowercase the text text-transform
AInternet backbone is the central structure that connects other elements of the network.
False
What is the current version of CSS?CSS 3
The NSF created a higher capacity network called?NSFNET
UGRD-IE6101 Computing Fundamentals
Final Examination
Final Lab Exam
This is used to put underline, overline, line-through or blink. text-decoration
This property is used to make a font italic or oblique.
Font-style
Text in Citation is denoted by what tags <CITE ></CITE>
Every website has no specific web address on the WWW False
