Microsoft Excel 2013 Chapter 2 – Flashcards
Unlock all answers in this set
Unlock answersquestion
addition
answer
Arithmetic operator that adds contents of cells
question
Auto Fill Options
answer
Button that gives options for how to fill cells following a fill operation
question
AVERAGE function
answer
Sums numbers then divides by the number of values
question
best fit
answer
The width of the column will increase or decrease so the widest entry will fit
question
circular reference
answer
Formula in a cell that contains a reference back to itself
question
cooler colors
answer
Colors like blue, green, and violet that tend to pull away from a reader
question
debugging
answer
The process of finding and correcting errors
question
destination area
answer
Cell, or range, to which data or formulas are being copied
question
division
answer
Arithmetic operator that divides contents of cells
question
equal sign
answer
Used to indicate the start a formula
question
exponentiation
answer
Arithmetic operator that raises to a power
question
fill handle
answer
Small rectangle in lower-right corner of a cell that is used to copy formulas
question
fixed dollar sign
answer
Displays a dollar sign in the far left of the cell
question
floating dollar sign
answer
Dollar sign that appears immediately to the left of the first digit
question
footer
answer
Text and graphics that print at the bottom of each page
question
formula
answer
Can be assigned to a cell and will display calculated result
question
formulas version
answer
Shows the actual formulas you have entered, rather than the resulting values
question
function
answer
Prewritten formula built into Excel
question
header
answer
Text and graphics that print at the top of each page
question
hiding cells
answer
Technique used to hide data that is sensitive or not relevant
question
Insert Options
answer
Lists formatting options following an insertion of cells, rows, or columns
question
margins
answer
Portions of a printed page outside the main body of the printed document
question
MAX function
answer
Displays the highest value for a range of values
question
MIN Function
answer
Displays the lowest value for a range of values
question
multiplication
answer
Arithmetic operator that multiplies
question
negation
answer
Arithmetic operator that makes a number negative
question
normal view
answer
Default view in Excel
question
Paste Options
answer
Specifies how moved or pasted items should appear
question
percentage
answer
Arithmetic operator that multiplies by 0.01
question
pixel
answer
Dot on screen that contains color
question
point mode
answer
Selecting cells for use in a formula by using your finger or the pointer
question
Range Finder
answer
Used to find which cells are referenced in a formula
question
source area
answer
Cell, or range, from which data or formulas are being copied
question
spell checker
answer
Used to check worksheet for spelling errors
question
subtraction
answer
Arithmetic operator that subtracts contents of cells
question
Trace Error button
answer
Lists error-checking options following an invalid formula
question
values version
answer
Shows results of the formulas, rather than the actual formulas
question
warmer colors
answer
Colors like red and orange that tend to reach toward a reader
