-
Auto Complete
feather that assists in your typing by suggesting words of phrases or fills in the remaining characters for you.
-
Font
set of characters with the same design and shape
-
Insertion point
blinking vertical line that indicates where text or graphics will be inserted
-
Office button
large button to the left of the quick access toolbar that displays a list of commands that you can do with a workbook such as opening, saving, printing, and sharing.
-
Selecting text
highlighting text so that it can be formatted, deleted, copied, or moved.
-
Title bar
In the Word window, the location of the minimize, maximize, and close buttons.
-
Wordwrap
feature that moves text from the right edge of a paragraph to the beginning of the next line as necessary to fit within the margins.
-
Absolute cell reference
cell reference that regers to cells by their fixed position in a worksheet. an absolute cell reference remains the same when the formula is copied.
-
Active cell
the cell surrounded by the black border, ready to receive data or be affected by the next cell command.
-
Auto fill
An Excel feature that extends values into adjacent cells based on the values of selected cells.
-
Auto correct
feature that assists in your typing by automatically correcting and formatting some text as you type.
-
Auto sum
another term for the sum function.
-
Cell
small box formed by the intersection of a column and a row.
-
Chart
graphic representation of data in a worksheet
-
Column
vertical group of cells in a worksheet
-
Fill handle
small black square in the lower right corner of a selected cell
-
Formula
an equation that performs mathematical calculations on values in a worksheet
-
Landscape orientation
page orientation in which the printed page is wider than it is tall.
-
Portrait orientation
page orientation in which the printed page is taller than it is wide.
-
Relative cell reference
In a formula, the address of a cell based on the realtive position of the cell that contains the formula and the cell referred to.
-
Spreadsheet
Another name for a worksheet.
-
Workbook
An Excel file that contains one or more worksheets.
-
Worksheet
The primary document that you use in Excel to store and work with data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.
-
AutoNumber
An Access feature that sequentially numbers entered records creating a unique number for each record
-
Database
An organized collection of facts about people, events, things, or ideas related to a particular topic or purpose.
-
Datasheet view
The Access view that displays an object organized in a format of columns and rows similar to an Excel spreadsheet.
-
DBMS
An acronym for database management system.
-
Design view
The detailed sturctured view of a form or report, and the view in which some tasks must be performed, only the controls and not the data are visible in this view.
-
Field
A category that describes each piece of data stored in a table.
-
Primary key
The field that uniquely identifies a record in a table such as a student ID number.
-
Query
A database object that retrieves specific data from one or more tables and then displays the specified data in datasheet view.
-
Record
All of the categories of data pertaining to one person, place, thing, or idea.
-
Report
A database object that summarizes the fields and records from a table, or from a query, in an easy to read format suitable for printing and publication.
-
Table
The Access object that stores your data organized in an arrangement of columns and rows.
-
Layout
The placement and arrangement of text and graphics on a slide
-
Notes pages
Printouts that contain the slide image in the top half of the page and the speakers notes in the lower half of the page.
-
Presentation graphics software
A program used to effectively present information to an audience.
-
Slide handouts
Printed images of more than one slide on a sheet of paper.
-
Slide sorter view
A view useful for rearranging slides in which all of the slides in the presentation display as thumbnails.
-
Show/Hide button
button that represents the command to reveal non-printing characters.
-
Formatting
The process of setting the overall appearance of the text within the document.
-
Quick Access Toolbar
toolbar above the ribbon and to the right of the Office button that can be customized by adding frequently used buttons.
-
Before text can be edited, changed, formatted, copied, or moved, it must first be ___________.
Selected
-
Word processing program
allows you to type, edit, move, and delete text or change the appearance of text.
-
Ribbon
user interface in Office 2007 that groups the commands for performing related tasks on tabs across the upper portion of the program window.
-
View options
Buttons on the right side of the status bar for viewing in Normal, Page Layout View, or Page Break Preview, also displays controls for zoom out and zoom in.
-
Column headings
The letters at the top of an Excel worksheet that disignate the columns.
-
Range
Two or more selected cells on a worksheet that are adjacent or non-adjacent, and treated by Excel as a single unit for the purpose of editing.
-
Constant value
Numbers, text, dates, or timeof day that you type into a cell.
-
Relative cell reference
In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.
-
Microprocessor
Chip that contains the CPU.
-
Wi-Fi
802.11 standard, wireless fidelity
-
Hard Drive
Holds all permanently stored programs and data and is located inside the system unit.
-
Memory
component inside the system unit that holds or stores instructions or data that the CPU processes.
-
Storage devices
devices such as hard disk drives, floppy drives and CD drives used for storing data and information.
-
CPU
part of the system unit that is responsible for data processing. The "brains" of the computer.
-
ALU
part of the CPU that performs all mathematical and logical calculations.
-
Peripheral devices
Devices such as monitors, printers, and keyboards that connect to the system unit through ports.
-
Application software
programs that allow the user to perform specific tasks such as word processing or playing games.
-
Operating system
System software that controls the way in which the computer system functions, including the management of hardware, peripherals, and software.
-
System software
set of programs that enables the a computers hardware and application software to work together. Includes operating system and utility programs.
-
Hardware
Any part of the computer you can physically touch.
-
Motherboard
computers main circuit board that contains the CPU, system memory, and expansion slots.
-
USB port
port to connect peripherals to the computer. Version 2.0 has a throughput of 480Mbps.
-
DSL
connects your computer to the internet using phone lines to provide high bandwidth throughput.
-
MS-DOS
single user, single task operating system created by Microsoft. First widely used operating system installed on personal computers.
-
Microsoft Windows
The most popular operating system for desktop computers.
-
Anti-virus software
designed to detect viruses and protect a computer and files from harm.
-
Router
Device that route packets of data between two or more networks.
-
Cache memory
small blocks of memory located on or next to the CPU that holds recently or frequently used instructions or data that the CPU accesses the most.
-
Software
set of computer programs or instructions that tells the computer what to do and enables it to perform different tasks.
-
Byte
8 binary digits or 8 bits
-
Megabyte
about a million bytes
-
Kilobyte
about a thousand bytes
-
ROM
set of memory chips on the motherboard that stores data and instructions that cannot be changed or erased. It holds all the instructions the computer needs to start up.
-
RAM
The computers temporary storage space or short-term memory. Located on the motherboard and capacity is measured in MBs or GBs.
-
CD ROM
portable, read only optical storage device.
-
CD RW disc
portable optical storage device that can be written and rewritten to many times.
-
DVD disc
optical storage device similar to a CD but the capacity is much greater.
-
Modem card
device that provides the computer with a connection to the internet using conventional phone lines.
-
Network
A group of two or more computers (or nodes) that are configured to share information or resources such as printers, files, and databases.
-
Unix
Operating system originally conceived in 1969 by Ken Thompson and Dennis Ritchie of AT&T's Bell Labs. Open source.
-
Virus
computer program that attaches itself to another program and attempts to spread itself to other computers when files are exchanged.
-
Firewall
Software or hardware designed to protect computers from unauthorized access by closing logical ports.
-
Bus
group of electrical pathways inside a computer that provide communications between various parts of the computer and CPU and main memory.
-
Gigabyte
about a billion bytes
-
For what would you use a word processor at work?
letters, memos, and documents
-
For what would you use a word processor at home?
Reports, papers, and letters.
-
For what would you use an electronic spreadsheet at work?
accounting, budgets, make charts
-
For what would you use an electronic spreadsheet at home?
lab reports, budgets, make charts
-
For what would you use a presentation program at work?
presentations for clients, co-workers, meetings
-
For what would you use presentation programs at home?
Presentations for class, club meetings, friends
-
For what would you use a database management program at work?
Inventory
-
For what would you use a database management program at home?
address book, christmas list, book list
|
|