Search
Create
Log in
Sign up
Log in
Sign up
Excel Review
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (28)
worksheet
Allows data easily to be summarized and charted
requirements document
Document which includes a needs statement, a source of data, and a summary of calculations
cell
Place to enter data in an Excel worksheet
insertion point
A blinking vertical line that shows where text will appear when you begin typing
AutoCorrect
A feature used to automate the correction of common typing errors.
number
In Excel, a number can contain the characters: 0123456789, +, -, (), /,$, %, E, e
range
A series of two or more adjacent cells in a column or row.
source area
copy area
destination area
the range of cells receiving the copy (paste area)
fill handle
The small green square in the lower right corner of a selected cell
auto fill options button
Allows you to choose whether you want to copy the values from the source area to the destination area with formatting, do so without formatting, or copy only the format.
merging
combining of selected cells
embedded chart
A chart created on the same sheet as the data used in the chart.
legend
identifies the colors assigned to each bar in the chart
AutoCalculate area
status bar that displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet
function
A prewritten formula that makes it easy to perform common calculations
ALT + ENTER
Starts a new line in the same cell.
order of operations
The rules Excel follows to calculate any formula that contains two or more operators.
point mode
allows you to select cells for use in a formula by using the mouse
AVERAGE function
An Excel function that adds a group of values, and then divides the result by the number of values in the group.
MAX function
displays the highest value in a range
MIN function
A function that determines the minimum value in a range of cells.
range finder
checks which cells are referenced in the formula assigned to the active cell
theme
predefined set of colors, fonts, chart styles, cells styles, and fill effects
accounting number format
the Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. Dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.
flash fill
A new feature in Excel that is similar to AutoFill.
When Excel recognizes a pattern based on other information in
your workbook, it uses the pattern to enter data into several cells
at once.
indirect circular reference
occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell
best fit
The width of the column will increase or decrease so the widest entry will fit
;