Podcast
Questions and Answers
Which of the following is a function of a firewall?
Which of the following is a function of a firewall?
What does the term 'bandwidth' refer to in networking?
What does the term 'bandwidth' refer to in networking?
What is the primary purpose of a database management system (DBMS)?
What is the primary purpose of a database management system (DBMS)?
What is the primary function of an antivirus program?
What is the primary function of an antivirus program?
Signup and view all the answers
Which of the following best describes cloud computing?
Which of the following best describes cloud computing?
Signup and view all the answers
Which of these is NOT a computer hardware component?
Which of these is NOT a computer hardware component?
Signup and view all the answers
What is the binary equivalent of the hexadecimal number 7BD?
What is the binary equivalent of the hexadecimal number 7BD?
Signup and view all the answers
What is the smallest measurement of memory?
What is the smallest measurement of memory?
Signup and view all the answers
Which file extension is commonly used for audio files?
Which file extension is commonly used for audio files?
Signup and view all the answers
What is the shortcut key for Copy in most applications?
What is the shortcut key for Copy in most applications?
Signup and view all the answers
Which of the following is a spreadsheet software?
Which of the following is a spreadsheet software?
Signup and view all the answers
How many bits are in a byte?
How many bits are in a byte?
Signup and view all the answers
What does the 'C$5' in Excel represent?
What does the 'C$5' in Excel represent?
Signup and view all the answers
Which HTML tag is used to create a hyperlink?
Which HTML tag is used to create a hyperlink?
Signup and view all the answers
What is the decimal equivalent of the binary number 101011?
What is the decimal equivalent of the binary number 101011?
Signup and view all the answers
Which Microsoft Excel function would you use to filter text starting with the letter 'a'?
Which Microsoft Excel function would you use to filter text starting with the letter 'a'?
Signup and view all the answers
What is the purpose of the
tag in HTML?
What is the purpose of the
tag in HTML?
Signup and view all the answers
In MS Word, line spacing is configured in which menu?
In MS Word, line spacing is configured in which menu?
Signup and view all the answers
Which tag is used for creating an unnumbered list in HTML?
Which tag is used for creating an unnumbered list in HTML?
Signup and view all the answers
Which of the following file formats is not valid for MS Excel?
Which of the following file formats is not valid for MS Excel?
Signup and view all the answers
What is the function of a database?
What is the function of a database?
Signup and view all the answers
Which of the following is not an application of Google Docs?
Which of the following is not an application of Google Docs?
Signup and view all the answers
What does CPU stand for?
What does CPU stand for?
Signup and view all the answers
Which protocol is known for application layer data transmission?
Which protocol is known for application layer data transmission?
Signup and view all the answers
What is the primary purpose of an operating system?
What is the primary purpose of an operating system?
Signup and view all the answers
Which programming language is commonly associated with web development.
Which programming language is commonly associated with web development.
Signup and view all the answers
Study Notes
Computer Fundamentals
- Monitors display information.
- Microphones are input devices.
- Octal 13 is binary 1101.
- Audio file extensions include .wav, .mp3, .ogg.
- Software for slideshows includes PowerPoint, Prezi.
- Search engines like Google, Bing, DuckDuckGo are used to find information online.
- Presentation graphics can include charts, graphs, images, text.
- Microsoft Excel is a popular spreadsheet editor.
- Microsoft Word, Google Docs are used to create text-based documents.
- The OFF state in computer switches is represented by the number 0.
- Computer software are programs that tell the hardware what to do.
- Computer hardware consists of physical components like the CPU, monitor, keyboard.
- A terabyte (TB) is a unit of storage equal to 1024 gigabytes.
- A kilobyte (KB) is a unit of storage equal to 1024 bytes.
- The shortcut key for bold is Ctrl + B.
- The smallest measurement of memory is a bit.
- The shortcut key for copy is Ctrl + C.
- The shortcut key for undo is Ctrl + Z.
- The shortcut key for cut is Ctrl + X.
- A byte is 8 bits.
- A valid email address follows a specific format (e.g., [email protected]).
- Hexadecimal 16 is decimal 22.
- Cut/copied items can be pasted into a document.
- The shortcut key for paste is Ctrl + V.
- Times New Roman, Comic Sans, and Calibri are font types.
- A cut command removes data from its current location and moves it to the clipboard.
- Examples of current computer science topics include artificial intelligence, cybersecurity, data science.
- Binary digits are 0 and 1.
- Hexadecimal 74A is binary 111101001010.
- Spreadsheets like Excel are used for organized data analysis and calculations.
- Hexadecimal 7BD is binary 111101101101.
- The ON state in computer switches is represented by the number 1.
- The "$" symbol in Excel represents an absolute cell reference.
- To make a cell address absolute, use dollar signs ($) before the column and row. (e.g., $A$1)
- The "Master function" in Excel refers to a built-in function for a group of tasks. There is no universal "Master function" button.
- Example of a valid cell address: A1, B5, C10.
- The function MIN() returns the smallest value in a range of cells.
- The function MAX() returns the largest value in a range of cells.
- The function AVERAGE() returns the average of values in a range of cells.
- Before a formula, select the cell and input the "equal (=)" symbol.
- Example of a wrong Excel expression: (Error).
- Example of a correct expression in Excel (e.g., A1 + A2 + A3).
- If A1=500 and A2=450, and autofill is used down to A3, A3 will show 400.
- If A1=300 and A2=350, and autofill is used down to A3, A3 will show 400.
- Yes, a cell can be transferred from a horizontal position to a vertical position using drag and drop.
- $C$1 is an absolute cell reference, meaning the column and row are fixed.
- C$1 is a mixed cell reference with the column fixed and the row variable.
- $C1 is a mixed cell reference, meaning the column is variable and the row is fixed.
- C1 is a relative cell reference.
-
in Excel usually means the cell isn't wide enough to display the data.
- To multiply items in Excel, use the asterisk (*) symbol.
- Incorrect formula to get the total of A1, A2, A3, A4, A5: (Error)
- A correct formula to check if the mark in E10 is above 74: =IF(E10>74,"PASSED","FAILED")
- Kazakhstan's E-Government portal (details unavailable).
- EDS stands for Electronic Digital Signature (or similar).
- HTML stands for HyperText Markup Language.
- To set yellow background and blue text in HTML, use specific tags.
- To set an image background and red text in HTML, use specific tags
- Numbered and unordered lists are identified by specific HTML tags.
- Italic and Bold text are identified using HTML tags.
- Headers are identified using HTML headings tags (
to
).
- New paragraphs are identified by the
tag.
- Hypelinks in HTML are identified by .
- HTML code elements are tags.
- Flowcharts are diagrammatic tools to visualize workflows.
- A web page is an HTML file.
- A URL is a Uniform Resource Locator that identifies a resource on the Web.
- Tags for an HTML table include
,
, . - Tags for a window title include
. - HTTP or HTTPS is an application layer protocol for data transmission on the Internet.
- HTML is a standardized markup language for documents on the World Wide Web.
- CSS (Cascading Style Sheets) is a technology for describing the appearance of a document.
- E-government is the integrated mechanism of interaction between the state and citizens with each other with informational technologies.
- PowerPoint is presentation software.
- PowerPoint is used for creating presentations, slideshows.
- Wi-Fi was introduced in the 3G mobile generation.
- Android is a type of mobile operating system.
- Google provides a specified amount of free space (details unavailable).
- Hexadecimal 3D is binary 00111101.
- Binary 100101 is decimal 37.
- Octal 106 is binary 10000110.
- Octal 73 is binary 111011.
- Binary 1010100 is decimal 84.
- Hexadecimal D8 is binary 11011000.
- Octal 10011.1101 is decimal 43. + decimal equivalent of .890625 =43.890625
- Binary 101011 is decimal 43.
- HTML file type is typically .html or .htm.
- HTML document format follows HTML syntax.
- Video creation software examples include Adobe Premiere Pro, Final Cut Pro.
- Excel's filter function displays records matching specific criteria.
- Find names containing "m" using the names filter.
- The
<body>
tag, within and tags, can use thebgcolor
attribute to set the background color of a document.- A numbered list in HTML starts with
<ol>
(ordered list), and each list item is<li>
(list item).- HTML unnumbered list is started by
<ul>
and contains<li>
items.- HTML header tags are
to
, where
<h1>
is largest and<h6>
is smallest heading.- Paragraphs in HTML are marked by the
<p>
tag.- Insert hyperlink with
<a>
tag that includes attributes to point to the specific document (e.g, link ).- HTML code elements are tags..
- A website is a collection of web pages.
- A URL identifies a resource on the internet.
- Word documents (.docx) are suitable Microsoft Word formats
- Excel worksheets/files (.xlsx).
- Line spacing is a feature within Microsoft Word's Paragraph settings.
- Arial, Cambria, Verdana, Times New Roman are font names.
- Files from non-document formats (e.g., images, spreadsheets) can't typically be added to Word documents by Special Paste options.
- There are limitations to Special Paste Options
- Page numbers can be inserted in headers/footers in Microsoft Word.
- Borders/shapes in Microsoft Word can be removed/hidden by changing the stroke color to none or similar method.
- Google Docs is like a word editor
- Google Sheets is similar to Microsoft Excel.
- Google Slides is similar to Microsoft PowerPoint
- Google Docs allows inserting images from the internet / files on a computer.
- To add text boxes or shapes, use the drawing tools in the software.
- The telegraph was invented in the 1830s,
- The telephone was invented in the 1870s.
- The World Wide Web was introduced in the 1980s.
- IBM announced its Systems Networks Architecture (SNA) in the 1970s.
- Electronic transmission of signals is part of communications.
- Sharing hardware, programs, and databases across an organization is network sharing.
- Internet networking technologies provide varied platforms.
- ARPANET, the predecessor to the Internet, appeared in 1969.
- The first email program was created in the 1970s.
- ARPANET ended in the 1990s.
- There are several computer generations.
- The third generation of computers involved integrated circuits (ICs) as basic components.
- First-generation computers used vacuum tubes.
- Transistorized computer circuits were introduced in the 1950s.
- Integrated Circuits were introduced in the 1960s.
- A monitor connects to the computer through a cable.
- Calculators can aid in numerical calculations.
- The first computer was developed at a certain time (details unavailable).
- Computers understand binary (0 and 1) language.
- Text editor file extensions include .txt, .rtf, .md.
- ICT stands for Information and Communications Technology.
- The primary function of an operating system (OS) is to manage computer hardware and software.
- Hardware is a physical part of the computer system.
- The primary goal of databases is to store and organize data.
- CPU stands for Central Processing Unit.
- Cloud storage is an example of storage on the internet.
- WiFi stands for Wireless Fidelity.
- Firewalls protect computer networks from unauthorized access.
- A URL is a web address.
- Malware is harmful software for a computer system.
- Windows, macOS, Linux are examples of Operating Systems.
- A router directs network traffic.
- DNS stands for Domain Name System.
- A type of memory is RAM (Random Access Memory).
- A web browser displays web pages.
- Cloud computing is internet based computing.
- Google is an example of a search engine.
- Programming language example: JavaScript.
- RAM stores data temporarily while the computer is on.
- A domain name is a website address.
- HTML stands for HyperText Markup Language.
- Antivirus software prevents computer viruses.
- A VPN creates a secure connection over a public network.
- A modem converts data between the computer and the internet.
- Microsoft Word is an example of software.
- Cookies are data files stored on your computer by websites you visit.
- IoT stands for Internet of Things.
- A URL shortener makes URLs shorter.
- A DBMS handles data stored in a database.
- E-commerce is electronic business transactions.
- RAM is volatile, ROM is non-volatile memory.
- An algorithm is a set of steps to solve a problem.
- A function that doesn't belong to a network is (example, data destruction),
- Bandwidth is the transfer rate of data over a network.
- Encryption is the process of converting data into a secure format.
- Spreadsheets are used for calculations and data analysis.
- A blog is an online journal.
- The motherboard is the main circuit board of a computer.
- SEO is a method to improve website ranking on search engines.
- Online transaction examples include online banking, online shopping.
- Big data refers to exceptionally large and complex data sets.
- System analysts design and improve computer systems.
- Bluetooth is used to connect devices wirelessly.
- Programming languages examples such as Python, Java, C,
- The cloud in cloud computing is the internet.
- Static websites have fixed content, dynamic websites change based on user interactions.
- A search engine finds information on the internet.
- Backups are for data recovery, protecting data from loss.
- A printer outputs data as hard copy
- Computer viruses are harmful software designed to disrupt or damage a computer.
HTML Tags (Examples)
-
<html>
- Start of an HTML document. -
<body>
- Contains the visible page content. -
<h1>
to<h6>
- Headings (largest to smallest). -
<p>
- Paragraph. -
<br>
- Line break. -
<a>
- Hyperlink. -
<img>
- Image. -
<ul>
- Unordered list. -
<ol>
- Ordered list. -
<li>
- List item. -
<b>
,<strong>
- Bold text. -
<i>
,<em>
- Italic text.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge on the basics of computer fundamentals, including hardware, software, and data storage. This quiz covers key concepts such as input and output devices, file formats, and essential software applications. Perfect for beginners looking to solidify their understanding of computer science concepts.
More Like This
- Tags for a window title include