Computer Skills Practice Flashcards

A comprehensive set of practice questions and answers covering computer fundamentals, networking, Windows 10 operations, and the Microsoft Office 2016 suite based on the provided lecture transcript.

What is a computer?

An electronic digital device that receives data ($Data$), processes it, stores it, and retrieves or displays it to the user as information ($Information$).

What are the three main sections of a Central Processing Unit ($CPU$)?

$A.$ Control Unit ($CU$), $B.$ Arithmetic and Logic Unit ($ALU$), and $C.$ Registers.

In CPU speed measurement, what does one Megahertz ($1\,MHz$) represent?

One million cycles per second.

What is the capacity of a Blue-ray Disc ($BD$)?

It can store up to $128\,GB$ of data.

What characterizes the Random Access Memory ($RAM$)?

It is volatile (temporary) memory whose contents are lost when power is cut off; it allows the processor to read from and write to it.

What is the difference between a Laptop and a Tablet PC according to the notes?

A Laptop weighs between $1.5$ and $4\,kg$ and has a physical keyboard, while a Tablet is a small computer featuring a touch screen ($Touch Screen$).

Define a Local Area Network ($LAN$).

A network that connects a number of computers and devices within a small or limited geographical area, such as a school, office, or home.

What is the speed difference between $G5$ and $G4$ cellular technology?

$G5$ is up to $100$ times faster than $G4$, which is $10$ times faster than $G3$.

What is a 'Hotspot' in networking?

A specific geographical area that provides the possibility of connecting to the Internet wirelessly for free or for a fee using Wi-Fi technology.

What is the function of a Modem?

It is a bridge device that converts analog signals to digital and vice versa to allow data exchange over telephone lines.

In Windows $10$, what is the function of 'Cortana'?

A digital voice assistant that allows users to interact with their device and perform tasks using voice commands.

What is the keyboard shortcut for 'Permanent Deletion' in Windows $10$?

$Shift + Delete$, which deletes the item permanently without storing it in the Recycle Bin.

What does the 'Absolute Reference' mean in Excel?

A cell address in a formula that does not change when the formula is copied or dragged, denoted by the dollar sign symbol (e.g., $\$H\$2$).

How many columns and rows are in an Excel $2016$ worksheet?

There are a maximum of $16,384$ columns (lettered) and $1,048,576$ rows (numbered).

What does the Excel error '$\#DIV/0!$' indicate?

A division by zero error.

What is a 'Pivot Table' in Excel?

A flexible, dynamic report generated from a very large database that helps in organizing, summarizing, and analyzing data.

In Microsoft Word $2016$, what is the 'Draft' view?

A view mode that does not show advanced page formatting like page borders, headers, footers, or images.

What is the difference between 'Transitions' and 'Animations' in PowerPoint?

Transitions are movements between slides, while Animations are movements applied to specific objects (text, images, shapes) within a slide.

What are the components of an email address?

A username ($Username$), the symbol ($@$), and the domain name ($Domain\,Name$) which includes the provider and extension (e.g., $.com$).

Define 'Spam' in the context of email.

Unsolicited electronic messages sent to users without their consent, often containing advertisements, promotions, or malicious content.

What is 'Phishing' or 'Scamming' in email?

Sending fake emails from a sender posing as a real person or institution to lure users to malicious websites and steal sensitive personal data like credit card details.

What is a 'Contact Group' in Outlook $2016$?

A collection of email addresses for a specific group of people (e.g., students in a class) that allows sending a message to all members at once without selecting them individually.