Excel 1 -U1&U2 Flashcards
increase comprehension and application of technical vocabulary
outlined by a bold rectangle; information is entered here
active cell
intersection of a row and column
cell
starts at the top of the sheet and goes to the bottom of the sheet; identified by a letter
column
indicates the current cell that is active; can change the location of active cell by typing here
Name Box
starts at the left edge of the sheet and goes to the right edge of the sheet; identified by a number
row
spreadsheet file; contains many sheets or pages
workbook
one sheet or page in a file; where information is entered
worksheet
default view–how worksheet opens up
Normal view
automatically divides worksheet into pages
Page Layout view
see an overview of worksheet; helps separate worksheet into different pages
Page Break view
Click the column heading (Letter name); selects the entire column
Selecting a column
Click the row heading (number name); selects the entire row
Selecting a row
select multiple cells with mouse
Click and drag method
select multiple cells by clicking first cell, hold shift button and click last cell
Shift key method
select multiple cells by clicking on first cell, hold control key, click on cells you want to select
Control key method
keyboard shortcut for Copy
Ctrl + C
keyboard shortcut for Bold
Ctrl + B
keyboard shortcut for Italics
Ctrl + I
keyboard shortcut for Paste
Ctrl + V
keyboard shortcut for Cut
Ctrl + X
keyboard shortcut for Undo
Ctrl + Z
how text is positioned in cell; left, center, right
alignment
forces text too wide for cell to fit inside cell and be readable
wrap text
information contained in a cell
cell content
pieces of info that describe appearance of cell content; examples–font size, font color
format attributes
line between rows or columns; mouse changes to line with 2 arrows
boundary
left to right measurement of column
column width
top to bottom measurement of row
row height
blinking cursor inside cell; changes can be made to cell content
edit mode
deletes format from selected cell
Clear Formats
deletes cell content
Clear Contents
deletes content and format; button looks like an eraser
Clear All
insert
add
delete
remove
cancels the current command
Escape button
equation that is entered into a cell
equation
first character in a cell that tells Excel there is a calculation, formula or function to perform
equal sign, =
values or data used in a formula; numbers
operands
symbols used to tell what type of calculation to perform
operators
uses the cell name (A2) in the formula; tells Excel to use the value in the cell in the formula/function
cell reference
predefined formula
function
cell information to be used in function calculation; contained in parentheses
arguments
adds all values in a range of cells
SUM function
sums cells in a range then dividing by number of cells in the range
AVERAGE function
counts the cells with numerical values in a range of cells; blank cells are ignored
COUNT function
finds the largest value in a range of cells
MAX function
finds the smallest value in a range of cells
MIN function
