Computer Fundamentals Quiz

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

Questions and Answers

Which of the following is a function of a firewall?

  • Translate domain names into IP addresses
  • Speed up internet connection
  • Store backup copies of data
  • Prevent unauthorized access to a network (correct)

What does the term 'bandwidth' refer to in networking?

  • The amount of memory a computer uses for processing
  • The size of data packets transferred over a network
  • The physical distance between devices
  • The maximum data transfer rate of a network connection (correct)

What is the primary purpose of a database management system (DBMS)?

  • To manage user interfaces
  • To store and retrieve data efficiently (correct)
  • To execute algorithms
  • To enhance the security of a network

What is the primary function of an antivirus program?

<p>To detect and remove malware (B)</p> Signup and view all the answers

Which of the following best describes cloud computing?

<p>Using remote servers to store and manage data (A)</p> Signup and view all the answers

Which of these is NOT a computer hardware component?

<p>Operating System (A)</p> Signup and view all the answers

What is the binary equivalent of the hexadecimal number 7BD?

<p>0111111101011101 (B)</p> Signup and view all the answers

What is the smallest measurement of memory?

<p>Bit (D)</p> Signup and view all the answers

Which file extension is commonly used for audio files?

<p>.mp3 (B)</p> Signup and view all the answers

What is the shortcut key for Copy in most applications?

<p>CTRL + C (D)</p> Signup and view all the answers

Which of the following is a spreadsheet software?

<p>Microsoft Excel (D)</p> Signup and view all the answers

How many bits are in a byte?

<p>8 (A)</p> Signup and view all the answers

What does the 'C$5' in Excel represent?

<p>Absolute address (A)</p> Signup and view all the answers

Which HTML tag is used to create a hyperlink?

<p><a> (D)</p> Signup and view all the answers

What is the decimal equivalent of the binary number 101011?

<p>43 (C)</p> Signup and view all the answers

Which Microsoft Excel function would you use to filter text starting with the letter 'a'?

<p>FILTER (A)</p> Signup and view all the answers

What is the purpose of the
tag in HTML?

<p>Create a line break (D)</p> Signup and view all the answers

In MS Word, line spacing is configured in which menu?

<p>Paragraph (D)</p> Signup and view all the answers

Which tag is used for creating an unnumbered list in HTML?

<ul> (D) Signup and view all the answers

Which of the following file formats is not valid for MS Excel?

<p>.docx (B)</p> Signup and view all the answers

What is the function of a database?

<p>To store and manage data (C)</p> Signup and view all the answers

Which of the following is not an application of Google Docs?

<p>Editing images (D)</p> Signup and view all the answers

What does CPU stand for?

<p>Central Processing Unit (C)</p> Signup and view all the answers

Which protocol is known for application layer data transmission?

<p>SNA (A)</p> Signup and view all the answers

What is the primary purpose of an operating system?

<p>To manage hardware and software resources (A)</p> Signup and view all the answers

Which programming language is commonly associated with web development.

<p>HTML (C)</p> Signup and view all the answers

Flashcards

What is a monitor?

A device that displays visual information, often from a computer.

What is a microphone?

A device that captures sound and converts it into an electronic signal, which can be processed by a computer.

What is a bit?

The smallest unit of information in a computer.

What is a byte?

A group of 8 bits.

Signup and view all the flashcards

What is presentation software?

Software that allows you to create and edit presentations with slides, images, and text.

Signup and view all the flashcards

What is spreadsheet software?

Software that allows you to create, edit, and manage spreadsheets with rows and columns.

Signup and view all the flashcards

What is computer hardware?

The physical components of a computer system, such as the keyboard, mouse, monitor, and central processing unit (CPU).

Signup and view all the flashcards

What is computer software?

The set of instructions that tell the computer what to do. It includes operating systems, applications, and programs.

Signup and view all the flashcards

What is malware?

Malware is a program that can damage or steal data from your computer without your knowledge. It could be a virus, worm, trojan horse, or spyware.

Signup and view all the flashcards

What does a firewall do?

A firewall protects your computer or network from unauthorized access or malicious attacks. It acts as a gatekeeper, controlling incoming and outgoing traffic.

Signup and view all the flashcards

What is a URL?

A URL (Uniform Resource Locator) is the address of a web page. It tells your browser where to find the information you're looking for.

Signup and view all the flashcards

What is cloud computing?

Cloud computing is a way of accessing and using computer resources like servers, storage, and software over the internet. You don't need to buy or maintain your own hardware, it's all managed remotely.

Signup and view all the flashcards

What is the primary function of a web browser?

The primary function of a web browser is to access and display web pages. It allows you to navigate the internet, view web content, and interact with websites.

Signup and view all the flashcards

What kind of address is C$1?

A cell address in a spreadsheet program, like Microsoft Excel. It combines a column letter and a row number, like A1 or C$1.

Signup and view all the flashcards

How do you multiply values in Excel?

An operator used in Excel to multiply values. It is placed between the cells you want to multiply together.

Signup and view all the flashcards

What does C$1 mean?

A formula in Excel where the row reference is absolute, meaning it won't change when the formula is copied to other cells. The '$' symbol signifies an absolute reference.

Signup and view all the flashcards

What is the formula to calculate the total of cells A1:A5?

A formula in Excel that calculates the sum of a range of cells. For example, =SUM(A1:A5) will add the values from cells A1 to A5.

Signup and view all the flashcards

Write an Excel formula that checks if E10 is greater than 74 and returns "PASSED" or "FAILED".

A formula in Excel that checks a condition and returns a specific value based on the outcome. Example, =IF(E10>74, "PASSED", "FAILED")

Signup and view all the flashcards

What is the E-Government portal of Kazakhstan?

A system that provides online access to government services, information, and resources for citizens. It aims to make government more accessible and efficient.

Signup and view all the flashcards

What does HTML stand for?

Hypertext Markup Language. It is a language used for creating webpages, defining their structure and content.

Signup and view all the flashcards

How do you specify the background color of a document in HTML?

A tag in HTML used to specify the background color of a webpage. It attributes a color to the 'body' of the document.

Signup and view all the flashcards

How do you identify the headers of a paragraph in HTML?

Tags in HTML that identify headings in a document. They typically range from '

' (biggest) to '

' (smallest).

Signup and view all the flashcards

How do you start a new paragraph in HTML?

A tag in HTML that designates the start of a new paragraph. It adds a clear space between paragraphs for improved readability.

Signup and view all the flashcards

What are the tags to make a table in HTML?

A set of tags in HTML used to create table structures. They allow you to organize data into rows and columns.

Signup and view all the flashcards

What tags are required to set the title of the HTML document?

A set of tags in HTML used to define the title of a webpage. It appears on the browser tab and is used for search engine optimization.

Signup and view all the flashcards

What application layer protocol is used for data transmission?

A layer in the TCP/IP model that handles the communication between applications on different computers. It allows applications to communicate independently of the underlying network.

Signup and view all the flashcards

What is the standardized markup language for documents on the world wide web?

A set of rules that define the format and presentation of webpages. It's used by web browsers to display a webpage correctly.

Signup and view all the flashcards

What is the technology that describes the appearance of a document using markup language?

A set of tags in HTML that define the style and appearance of elements within a webpage. It's used to control things like font size, color, and formatting.

Signup and view all the flashcards

Study Notes

Computer Fundamentals