Shared Flashcard Set

Details

Microsoft Excel Set 2
Concepts and Vocabulary for Excel
30
Computer Science
Not Applicable
04/12/2011

Additional Computer Science Flashcards

 


 

Cards

Term
Sheet tab scrolling buttons
Definition
display sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided
Term
sheet tabs
Definition
identify the worksheets in a workbook
Term
vertical window split box
Definition
splits the worksheet into two vertical views of the same worksheet
Term

False

 

When you save a workbook, the worksheets are contained within it and don't have separate file names

Definition
T or F:  Worksheets contained within a workbook are saved with separate file names.
Term
range
Definition
two or more cells on a worksheet that are adjacent or nonadjacent
Term
data
Definition
text or numbers in a cell
Term
active cell
Definition
the cell ready to receive data or be affected by the next Excel command
Term
cell reference number
Definition
intersecting column letter and row number
Term
cell address
Definition
another name for cell reference number
Term
All cells between B2 and C5 are selected
Definition
What does this mean:  B2:C5?
Term
colon
Definition
punctuation mark between two cell references that indicates all the cells between the two cell references are in a range
Term
row
Definition
horizontal group of cells in a worksheet
Term
row heading
Definition
unique number that identifies each row
Term
column
Definition
vertical group of cells in a worksheet
Term
column heading
Definition
unique letter identifies each column
Term
nonadjacent
Definition
not next to each other
Term
adjacent
Definition
next to each other
Term
control
Definition
If you want to select a range of cells that are not adjacent, then use the ___ key
Term
There are two nonadjacent ranges--C3 to C5 and E3 to E5
Definition
What does this mean: C3:C5,E3:E5
Term
cell content
Definition
anything typed into a cell
Term
value, formula
Definition
Cell content is either a _____ or a _____.
Term
value
Definition
numbers, text, dates, or times of the day that you type into a cell
Term
True
Definition
T or F: A constant value and a value are the same thing
Term
formula
Definition
an equation that performs mathematical calculations on values in your worksheet
Term
edit
Definition
to change
Term
left alignment
Definition
characters align at the left edge of the cell
Term
True
Definition
T or F:  AutoComplete only assists with alphbetic values and not numeric ones
Term
fill handle
Definition
small black square in the lower right corner of a selected cell
Term
Auto fill
Definition
a feature in Excel that can generate a series of values into adjacent cells based on the values of other cells
Term
series
Definition
a group of things that come one after another in succession
Supporting users have an ad free experience!