MRS C'S CBA UNITS 1, 2, & 3
Order by
93 terms
Terms | 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 |
| logon | action of gaining access to a computer or a network by entering a username and password |
| 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.