Computer Fundamentals, Operating Systems, Networks, and Excel Vocabulary

A set of vocabulary flashcards covering computer concepts, networking basics, operating systems, and Microsoft Excel functions from the lecture notes.

Disk Defragmentation Tool

A software utility used periodically on an HDD hard drive to reorganize scattered data blocks and increase data access speed.

LAN (Local Area Network)

A system of transmission media and independent computing devices connected within a localized scope such as a room, floor, or building.

Computer Virus

A human-made computer program capable of hiding, spreading automatically, and destroying computer software products.

Macro Virus

A type of computer virus that infects document files like Word and Excel containing macros.

Computer Network Architecture

The structure defining the connection topology between computers as well as the functional elements and protocols constituting the network.

Control Panel

A Windows system application used to install or change system hardware and software configuration settings.

Windows Explorer

A Windows tool that allows users to view and manage computer storage as a hierarchical directory tree structure.

Operating System

Fundamental system software that is loaded into RAM during boot up for the computer to function.

Shortcut

A pointer or link file in Windows created to allow quick access to an executable file or target object.

Error

A display state in Microsoft Excel indicating that column width is insufficient to display the formatted numeric value.

VALUE! Error

An error in Microsoft Excel indicating that data used in a formula has an incorrect data type, such as performing arithmetic on text strings.

NAME? Error

An error in Microsoft Excel indicating that a function name is misspelled or unassigned.

DIV/0! Error

An error in Microsoft Excel that occurs when a formula attempts to divide a value by zero.

INT Function

An Excel function that rounds a numeric value down to the nearest integer.

MOD Function

An Excel function that calculates and returns the remainder of a number divided by a divisor.

DMAX Function

A database function in Microsoft Excel used to find the maximum value in a designated field across a database table matching specified criteria.

COUNTIF Function

An Excel function used to count the number of cells within a specified range that satisfy a given condition.

SUMIF Function

An Excel function that sums values in a specified sum range for cells meeting a given condition.

Subtotals Command

An Excel data tool used to calculate summary values by group, which requires data to be pre-sorted by the group key field.

DGET Function

A database function in Microsoft Excel used to extract a single record field from a database table meeting specified criteria.

Excel Cell References

Cell address types in Excel including Relative (such as $C6$), Absolute (such as $\$D\$7$), and Mixed (such as $\$A1$ and $B\$5$).

REF! Error

An error in Microsoft Excel indicating an invalid or missing cell reference.

N/A Error

An error in Microsoft Excel indicating that a value or data lookup result is not available.

LEFT Function

An Excel text function used to extract a specified number of characters starting from the left side of a text string.

RIGHT Function

An Excel text function used to extract a specified number of characters starting from the right side of a text string.

VALUE Function

An Excel function that converts a text string representing a number into a numeric value.