Shared Flashcard Set

Details

Excel Terms 1
Excel Terms 1
25
Computer Science
10th Grade
02/11/2013
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
Workbook:
 Definition
An Excel file with one or more worksheets.
Term
Worksheet:
 Definition
The work area for entering and calculating data made up of columns and rows separated by gridlines. Also called a spreadsheet.
Term
Cell:
 Definition
The intersection of a column and a row on a worksheet. You enter data into these to create a worksheet.
Term
Active Cell:
 Definition
Contains the cell pointer and has a dark outline around the cell.
Term
Formula Bar:
 Definition
As you enter data into a cell, it simultaneously appears above the worksheet in this bar.
Term
Cell Reference:
 Definition
The location of a cell in a worksheet as identified by its column letter and row number
Term
Scroll:
 Definition
A way to view locations on the worksheet without changing the active cell.
Term
Sheet Tabs:
 Definition
Tabs that appear at the bottom of the workbook window, which display the name of each worksheet.
Term
Template:
 Definition
A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets.
Term
Label:
 Definition
Text in the first row or column of a worksheet that identifies the type of data contained there.
Term
Value:
 Definition
A number entered in the worksheet.
Term
Numeric label:
 Definition
A number entered in the worksheet as a label, not as a value – such as the year 2005 used as a column label.
Term
Label prefix:
 Definition
An apostrophe (‘) used to indicate that a number is a label and not a value.
Term
Range:
 Definition
A block of cells in an Excel worksheet
Term
Contiguous Range:
 Definition
A block of adjacent cells in a worksheet
Term
Noncontiguous Range:
 Definition
Cells in a worksheet that act as a block, but are not necessarily adjacent to each other.
Term
Fill:
 Definition
A color that fills a cell, appearing behind the data.
Term
Merge:
 Definition
To combine multiple adjacent cells together to create one large cell.
Term
Clipboard:
 Definition
A feature of Windows that holds data or graphics that you have cut or copied and are ready to be pasted into any document.
Term
Fill Handle:
 Definition
Dragging this, located in the lower-right corner of the active cell, will copy cell contents, formatting, or a formula to adjacent cells.
Term
Format Painter:
 Definition
A button on the Home tab that allows you to copy formatting from a selected object or cell and apply it to another object or cell.
Term
Cut:
 Definition
The command used to remove data from a cell or range of cells and place it on the clipboard.
Term
Paste:
 Definition
The command used to place data from the Clipboard to a location on the worksheet.
Term
Drag-and-drop Feature:
 Definition
A method used to move or copy the contents of a range of cells by dragging the border of a selection from one location in a worksheet and dropping it in another location.
Term
Active sheet tab:
 Definition
The selected worksheet; the tab name is bold.
Supporting users have an ad free experience!