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

Questions and Answers

A light sensitive device that converts drawing, printed text or other images into digital form is

  • Keyboard
  • Scanner (correct)
  • Plotter
  • OMR

Which protocol provides e-mail facility among different hosts?

  • SNMP
  • SMTP (correct)
  • FTP
  • TELNET

First generation of computer was based on which technology?

  • Vacuum Tube (correct)
  • Transistor
  • BLSI
  • VLSI

Which of the following memory is non-volatile?

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

GUI stands for

<p>Graphical User Interface (A)</p> Signup and view all the answers

Any data or instruction entered into the memory of a computer is considered as

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

Microsoft Word is an example of

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

Graphical pictures that represent an object like file, folder etc are:

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

When was the first e-mail sent?

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

Kilobyte also referred to as KB, is equal to:

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

What do Excel formulas start with?

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

What is an Excel feature that displays only the data in column (s) according to specified criteria?

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

What is the default file extension used by Excel 2016 and later versions?

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

What functionality does the 'Freeze Panes' feature provide in Excel?

<p>Locking rows/columns (C)</p> Signup and view all the answers

In Excel, which function returns the current date and time?

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

What is the function to convert text to uppercase in Excel?

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

What is a macro in Excel?

<p>An automated set of commands (B)</p> Signup and view all the answers

Where does the result display when a formula is entered in Excel?

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

Which tab in Excel is used when importing, sorting and filtering the data placed into a worksheet's data list?

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

What is the process of deleting all the data on the hard drive?

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

What is the purpose of an expansion slot in a motherboard?

<p>To insert the additional peripherals (C)</p> Signup and view all the answers

What is the capacity of a typical DVD?

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

UNIVAC is

<p>Universal Automatic Computer (D)</p> Signup and view all the answers

Properly arranged data is called

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

The brain of any computer system is

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

Flashcards

What is a scanner?

A device that converts images, drawings, or printed text into digital form.

How are emails sent between different computers?

SMTP (Simple Mail Transfer Protocol) allows email communication between different computer systems.

What technology powered first generation computers?

The first generation of computers used vacuum tubes as their primary electronic components.

What kind of memory keeps data even without power?

ROM (Read-Only Memory) retains data even when the power is off.

Signup and view all the flashcards

What does GUI stand for?

GUI stands for Graphical User Interface. It's a visual way to interact with a computer using icons, windows, and menus.

Signup and view all the flashcards

Anything you enter into a computer is called what?

Data or instructions entered into a computer's memory is called input.

Signup and view all the flashcards

What is Microsoft Word?

Microsoft Word is a word processing application used for creating and editing documents.

Signup and view all the flashcards

What are icons in computing?

Icons are small pictures that represent objects like files, folders, or programs in a graphical user interface.

Signup and view all the flashcards

When was the first email sent?

The first email was sent in 1971.

Signup and view all the flashcards

How many bytes are in a kilobyte?

A kilobyte, or KB, is equal to 1024 bytes.

Signup and view all the flashcards

What does the ">" sign indicate?

The greater than sign (">) is a comparison operator used to check if one value is greater than another.

Signup and view all the flashcards

What is the intersection of a row and a column in a spreadsheet?

The point where a row and a column intersect in a spreadsheet is called a cell.

Signup and view all the flashcards

How do you start formulas in Excel?

Excel formulas begin with an equal sign (=).

Signup and view all the flashcards

What does the AutoFilter feature do in Excel?

The AutoFilter feature in Excel allows you to display only data that meets specified criteria.

Signup and view all the flashcards

What is not an Excel function?

The SUM function is the most commonly used function in Excel, but others include AVERAGE, MAX, MIN, and COUNT.

Signup and view all the flashcards

What is the file extension for Excel 2016 and newer?

The default file extension used by Excel 2016 and later versions is .xlsx.

Signup and view all the flashcards

What does Freeze Panes do in Excel?

The "Freeze Panes" feature in Excel keeps certain rows or columns visible while scrolling through the rest of the worksheet.

Signup and view all the flashcards

What function shows the current date and time in Excel?

The NOW() function in Excel returns the current date and time.

Signup and view all the flashcards

How do you convert text to uppercase in Excel?

The UPPER() function in Excel converts text to uppercase.

Signup and view all the flashcards

What is a macro in Excel?

A macro in Excel is a sequence of recorded actions or commands used to automate repetitive tasks.

Signup and view all the flashcards

Where does the result of an Excel formula appear?

The result of a formula entered in Excel is displayed in the same cell where the formula is entered.

Signup and view all the flashcards

What tab in Excel is used for managing data?

The Data tab in Excel allows you to import, sort, and filter data in a worksheet's data list.

Signup and view all the flashcards

What does formatting a hard drive do?

Formatting a hard drive means deleting all the data on it.

Signup and view all the flashcards

Why are there expansion slots on a motherboard?

An expansion slot on a motherboard allows you to add additional boards like graphics cards, sound cards, or network cards.

Signup and view all the flashcards

How much storage does a DVD usually have?

A typical DVD has a storage capacity of around 4.7 GB.

Signup and view all the flashcards

What is UNIVAC?

UNIVAC (Universal Automatic Computer) was one of the first commercial computers.

Signup and view all the flashcards

What is properly arranged data called?

Data arranged in a meaningful and organized way is called information.

Signup and view all the flashcards

What is the brain of a computer called?

The central processing unit (CPU) is the brain of a computer system. It processes instructions and performs calculations.

Signup and view all the flashcards

What technology characterizes the fifth generation of computers?

The fifth generation of computers uses artificial intelligence concepts for tasks like natural language processing and machine learning.

Signup and view all the flashcards

What does TCP stand for?

TCP stands for Transmission Control Protocol. It's a fundamental protocol used for reliable data transmission over the internet.

Signup and view all the flashcards

Study Notes

Light Sensitive Device for Digital Conversion

  • Scanner is a light-sensitive device used to convert images (printed text, drawings) into digital form.

Email Protocol

  • SMTP (Simple Mail Transfer Protocol) facilitates email communication between different hosts.

First Generation Computer Technology

  • First-generation computers utilized vacuum tubes.

Non-Volatile Memory

  • ROM (Read-Only Memory) is non-volatile memory, retaining data even when power is off.

GUI (Graphical User Interface)

  • GUI stands for Graphical User Interface.

Data in Computer Memory

  • Data or instructions entered into a computer's memory are considered input.

Example of Application Software

  • Microsoft Word is an example of application software.

Graphical Representations

  • Icons represent objects like files and folders.

First Email Sent

  • The first email was sent in 1971.

Kilobyte Equivalence

  • 1 kilobyte (KB) is equal to 1024 bytes.

Arithmetic/Conditional Operators

  • The greater than sign (>) is a conditional operator.

Worksheet Intersection

  • The intersection of a row and column in a worksheet is called a cell.

Excel Formula Start

  • Excel formulas begin with the equal sign (=).

Excel Data Filtering

  • Filtering in Excel displays data based on specific criteria.

Default Excel File Extension

  • The standard file extension for Excel 2016 and later versions is .xlsx.

Freeze Panes Feature

  • The Freeze Panes feature in Excel locks rows or columns, maintaining their visibility as the worksheet is scrolled.

Current Date and Time Function

  • In Excel, the NOW() function returns the current date and time.

Text to Uppercase Conversion

  • UPPER() is the function in Excel used to convert text to uppercase.

Macros in Excel

  • A macro is an automated set of commands in Excel.

Formula Result Display Location

  • The result of a formula in Excel is displayed in the formula bar.

Data Worksheet Tab

  • Data-related tasks in Excel are performed using the Data tab.

Hard Drive Data Deletion

  • Formatting is the process of deleting all data from a hard drive.

Motherboard Expansion Slots

  • Expansion slots allow for the addition of peripherals or components.

DVD Capacity

  • A typical DVD has a capacity of 4.7GB.

UNIVAC Meaning

  • UNIVAC stands for Universal Automatic Computer.

Properly Arranged Data

  • Information in a structured format is referred to as data.

Computer Brain

  • The central processing unit (CPU) is the controlling unit of a computer system.

Computer Generation and AI

  • Fifth-generation computers incorporate artificial intelligence concepts.

TCP Meaning

  • TCP stands for Transmission Control Protocol.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Related Documents

Computer Science Quiz PDF

More Like This

Technology in Electric Mail
12 questions

Technology in Electric Mail

GuiltlessLeprechaun avatar
GuiltlessLeprechaun
Computer Basics Quiz
22 questions

Computer Basics Quiz

HarmoniousWonder avatar
HarmoniousWonder
Email and Technology Terminology Quiz
5 questions
Computer Communication Quiz
16 questions
Use Quizgecko on...
Browser
Browser