## MRS C'S CBA UNITS 1, 2, & 3

##### Created by:

mistyc89  on February 20, 2012

##### Classes:
Pop out
Last Message: 15 months ago

# MRS C'S CBA UNITS 1, 2, & 3

 Absolute cell referencecell reference that does not adjust to the new cell location when copied or moved
1/93

Order by

#### Definitions

Absolute cell reference cell reference that does not adjust to the new cell location when copied or moved
Active cell a selected worksheet cell that is ready for data entry
Alignment the position of data within a cell
Argument value, cell reference, range, or text that acts as an operand in a function formula
Ascending sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
Autosum a function that automatically adds the values in the cells directly above or to the left of the active cell
Average returns the average (arithmetic means) of its arguments
Cell the space formed by the intersection of a row and a column; the basic unit of a worksheet
Cell reference a unique identifier for a cell which is formed by combining the cell's column letter and row number
Chart/graph a graphic representation of values and their relationships: pie, line, column, bar, scattered
Column a vertical group of cells in a worksheet identified by letters
Column chart a chart that uses bars of varying height to illustrate values in a worksheet
Count returns the number of cells in a range that contains numbers
Descending sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliest
Fill to copy a cell's contents and/or formatting into an adjacent cell or range
Format arranging the shape, size, type, and general makeup of a cell or group of cells
Formula an equation that calculates a new value using values currently on a worksheet
Freeze keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
Function a prewritten formula that makes it easy to perform common calculations
Label alphanumeric text that will not be used in calculations
Line chart a chart that uses points connected by a line to illustrate values in a worksheet
Max returns the largest value in a set of values
Min returns the smallest value in a set of values
Mixed cell reference a cell reference that contains both relative and absolute references
Operand a number or cell reference used in a formula
Operator a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
Order of Operations the mathematical rules used for calculating the value of a formula
Pie chart a chart that shows the relationship of a part to a whole
Range selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon
Relative cell reference cell reference that adjust to a new location when copied or moved
Row a horizontal group of cells in a worksheet identified by numbers
Sort to arrange a list of words or numbers in ascending or descending order
Spreadsheet a grid of rows and columns containing numbers, text, and formulas used to perform calculations
Sum adds all the numbers in a range of cells
Value numeric characters that can be used in a calculation
What-if analysis process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
Workbook a collection of related worksheets
Worksheet the workspace made up of columns and rows where data is entered to create an electronic spreadsheet
Alignment how the eges of a line, paragraph, object, or table are positioned horizontally and vertically between the margins or on a page
Ascending sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest
Automatic Page Break a feature that automatically generates a new page, allowing text to flow to the next page when space runs out on the previous one; also known as a Soft Page Break
Borders lines around the edge(s) of text, a page, a cell, or a table
Bullets and Numbering a feature in a word processing application that allows the user to create outlines or itemized lists with either icons or numbers
Clip Art a feature that includes pre-made illustrations, drawings, pictures, and other graphics that can be inserted into a document
Column one of two or more vertical sections of printed material on a page; usually separated by margins
Copy and Paste a feature that allows a user to select text or a graphic, duplicate it and place it in another location within a document
Cut and Paste a feature that allows a user to select text or a graphic, remove it from its current location and place it in another location within a document
Descending sort order arranging text or numbers from Z to A, largest to smallests, or latest to earliest
Desktop Publishing through the use of a personal computer, combining text and graphics to produce high-quality documents, such as newsletters, flyers, brochures, etc.
Drag and Drop a feature that allows a user to select text using a mouse or pointing device, and quickly move (drag) it to a different location
Edit to make changes by adding, deleting, or modifying text, graphics, or other items in a document
Find and Replace a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it with new text, symbols or formatting
Font the size, style, and design of text
Footer text appearing at the bottom of each page, separate from the main body of a text
Format in word processing, to utilize features that enhance the appearance and overall layout of text, graphics, tables within a document
Graphics drawings, pictures, or other illustrations inserted in a document to either explain data or enhance the appearance of text on a page
Hard Return a break in a line or a paragraph that is forced by the user when the return key is pressed, creating a new paragraph
Header text appearing at the top of each page, separate from the main body of text
Indent to move text horizontally away from the left or right margin, setting it apart from surrounding text
Landscape Orientation a page layout in which documents are printed across the length of a page, making the page wider than it is tall
Line Spacing the amount of space between lines of text
Manual Page Break a page break the end user forces into a document, creating a new page at a specific location; also known as a Hard Page Break
Margins the white space surrounding the content of a page at the top, bottom, left and right sides, defining where a line of text begins and ends
Print Preview a feature that allows the user to view a document onscreen and make necessary formatting changes prior to printing it
Point Size the measurement, or size of a font (text); each point is approximately 1/72 of an inch
Portrait Orientation a page layout in which documents are printed across the width of a page, making the page taller than it is wide
Shading/Fill the background color of a cell, table, or page
Sort to arrange a list alphabetically (text) or numerically (numbers), in ascending or descending order
Spell Check a feature used to automatically locate and correct spelling errors
Tab Stop a formatting feature that allows the user to control where a line of text will be entered and how the text will be aligned; so that when the proper key is pressed, the insertion point will move to that location
Table a set of data arranged in a grid of rows and columns
Template a feature that includes pre-made documents that allow the user to fill-in-the blanks to create new documents, such as calendars, invoices, reports, resumes, etc.; enhances user's efficiency and creativity
Thesaurus a feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing
View a feature that allows the user to view the current page of a document onscreen in a different ways
Word Processing the use of software application to create, edit, format, print and save text-based documents, such as letters, reports, and memos
Word Wrap also called a soft return; a feature that automatically moves text to the next line when the previous line is full without the user pressing
the enter key
Word/Text Art text created as a graphic image
Wrap Text a feature that allows text to be included with pictures, shapes, or tables without covering or hiding under the image, giving the user control
over how the text is position
application software computer software created to allow the user to perform a specific job or task
CPU (central processing unit ) the principal computer chip that contains several processing components, which determines the computer's operating speed; the "brain" of a computer
file management program on a computer that allows the user to create, edit, view, print, rename, copy, or delete files, folders, or an entire file
system
file type an extension at the end of a file name, indicating which application was used to create a document
input device used to enter data into a computer; such as a keyboard, microphone, scanner, flash drive, or mouse
memory computer chips that store data and programs while the computer is working; often called RAM
operating system system software that acts as a "go-between"
output device allows the user to view or listen to the data a computer processes such as a monitor, printer, headphones, or speakers
peripheral additional hardware that isn't necessary for a computer to function, but does enhance how the computer can be used
save storing data for later use
save as allows the user to change the attributes of a file (such as location, file name, or file type) before saving it
storage device external hardware used to store and retrieve data, such as a disk drive, CD/DVD drive, flash drive, or tape drive
system software responsible for the general operation of a computer system, including the operation of hardware, running application software, and file management
system unit computer case that contains the CPU, power supply, memory, and storage

### First Time Here?

Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.

### Set Champions

##### Scatter Champion

21.5 secs by Mr_Hunter22