Computer Applications Vocabulary Flashcards

The Information Processing Cycle

• The information processing cycle consists of four main stages:
  • Input:
  • Processing:
  • Output:
  • Storage:

Computer

• Definition: A device that accepts input, processes data, and outputs the results.

Hardware

• Definition: The physical devices that make up a computer system. Any part of the computer you can touch is considered hardware.

Software

• Definition: Programs designed to perform specific tasks on a computer.
• Examples:
  • Windows
  • Mac OS
  • iOS

Computer Program

• Definition: A set of instructions that tells the computer how to perform specific tasks.

Data

• Definition: Individual facts or pieces of information.

Backstage View

• Access: Accessed by clicking the File Tab in all Office applications.
• Functions: Used for common tasks such as:
  • Save
  • Open
  • Print
  • Share
  • Change application options

Word Wrap

• Definition: A feature that automatically moves text to the next line when it reaches the right margin.

Show/Hide

• Definition: A feature that displays or hides formatting characters in a document.

Worksheet

• Definition: An electronic ledger used to enter data, typically in spreadsheet programs.

Row

• Definition: A horizontal group of cells in a worksheet.
• Identification: Usually identified by numbers.

Column

• Definition: A vertical group of cells in a worksheet.
• Identification: Usually identified by letters.

Cell

• Definition: The intersection of a column and a row in a worksheet.

Cell Range

• Definition: A contiguous group of cells in a worksheet.

Formula Bar

• Definition: A data entry area located directly below the ribbon and above the worksheet grid.

Name Box

• Definition: Located on the left side of the Formula Bar.
• Function: Displays the address of the selected cell.

Status Bar

• Location: Appears at the bottom of the worksheet grid.
• Function: Displays information such as:
  • The number of selected cells that contain data (count).
  • The average of the selected values.
  • The sum of the selected values.

Cell Reference

• Definition: A cell's address (e.g., A1, B2, C3).

Relative Reference

• Definition: A cell reference that automatically adjusts to the new location when the formula is copied.

Absolute Reference

• Definition: A cell reference whose location remains constant when the formula is copied.

Mixed Reference

• Definition: A cell reference that contains both relative and absolute references, allowing either the row or column to stay constant while the other changes.
• Example: When the row position stays constant with a changing column position.

Vertical

• Definition: Up and Down; north to south.

Horizontal

• Definition: Side to side; east to west.

Folder

• Definition: A container used to store files.

Clipboard

• Definition: A temporary storage area for information that has been copied, cut, or moved.

Insertion Point

• Definition: A blinking vertical line that indicates where text or graphics will be inserted.

Mini Toolbar

• Definition: A small toolbar containing frequently used formatting commands that appears when text or graphics are selected.

Design and Layout Tabs

• Availability: Two additional tabs that appear in Word when a table is active.

Ctrl+A

• Function: A shortcut key that enables you to select everything in a Word document.

Default Line Spacing in Word 2016

• Value: 1.08

File

• Definition: A collection of information stored on a computer under a single name.

Excel Formula

• Rule: All Excel formulas begin with an '=' sign.

Presentation

• Definition: A series of slides, often used for visual communication.

Thumbnail Pane

• Definition: Miniature-sized slides that provide a quick way to navigate between slides in a presentation.

Slide Pane

• Definition: The area in a presentation software where you can modify individual slides.

Note Pane

• Definition: Area in presentation software where you can type notes about the current slide being displayed. These notes are often for the presenter's reference.

Placeholder

• Definition: A container on a slide that holds text or other content (e.g., images, videos).

Output

• Definition: Processed results that a computer provides after performing operations on input data.