Excel – Assignment Writing – Flashcards
160 test answers
Unlock all answers in this set
Unlock answers 160question
is a reference to a cell or range of cells in another workbook.
answer
link
Unlock the answer
question
area in which you can enter data , surrounded by a heavy border.
answer
active cell
Unlock the answer
question
button that allows you to copy values with/without formatting or the format only .
answer
auto fill option
Unlock the answer
question
corrects common mistakes when you complete a text entry in a cell.
answer
auto correct feature
Unlock the answer
question
properties that include system file properties
answer
automatically updated properties
Unlock the answer
question
text that has a darker appearance than normal text
answer
bold
Unlock the answer
question
cancels an entry by tapping or clicking
answer
cancel box
Unlock the answer
question
conveys a visual representation of data
answer
chart
Unlock the answer
question
range of cells receiving the copy
answer
destination area
Unlock the answer
question
details about a file such as the project author , title and subject
answer
document properties
Unlock the answer
question
small black square located in the lower-right corner of the active cell
answer
fill handle
Unlock the answer
question
defines appearance and shape of letters and numbers
answer
font
Unlock the answer
question
defines the color of characters
answer
font color
Unlock the answer
question
specifies the size of characters
answer
font size
Unlock the answer
question
indicates how the characters are emphasized
answer
font style
Unlock the answer
question
how you make a worksheet easier to read and understand
answer
format
Unlock the answer
question
information that exists on a physical medium such as paper
answer
hard copy
Unlock the answer
question
key that selects the cell at the beginning of a row with the active cell
answer
HOME
Unlock the answer
question
excel inserts the character and moves all characters to the right
answer
insert mode
Unlock the answer
question
blinking vertical line that indicates where next character typed will display
answer
insertion point
Unlock the answer
question
chart used to illustrate changes in data over time
answer
line chart
Unlock the answer
question
creating a single cell by combining two or more cells
answer
merging cells
Unlock the answer
question
0,1,2,3,+,_,(),?,.$ , % E , e
answer
number
Unlock the answer
question
excel replaces the character to the right of the insertion point
answer
overtype mode
Unlock the answer
question
key that selects the cell down one worksheet window from the active cell.
answer
PAGE DOWN
Unlock the answer
question
key that selects the cell up one worksheet window from the active cell
answer
PAGE UP
Unlock the answer
question
chart used to show the contribution of each piece of data to the whole
answer
pie chart
Unlock the answer
question
1/72 of an inch
answer
point
Unlock the answer
question
series of two or more adjacent cells in a column or row
answer
range
Unlock the answer
question
each adjusted cell reference
answer
relative reference
Unlock the answer
question
includes a needs statement,source of data , and summary of calculations
answer
requirements documents
Unlock the answer
question
to make a cell active
answer
select
Unlock the answer
question
cell being copied
answer
source area
Unlock the answer
question
Unmergining a cell
answer
splitting
Unlock the answer
question
associated with all Microsoft office files and include author, title, subject.
answer
standard properties
Unlock the answer
question
adds all the numbers in a range of cells
answer
SUM function
Unlock the answer
question
chart used to compare data from three columns in a 3-dimensional manner
answer
surface chart
Unlock the answer
question
any set of characters containing letters, hyphens, or spaces
answer
text
Unlock the answer
question
allows data easily to be summarized and charted
answer
worksheet
Unlock the answer
question
arithmetic operator that adds contents of cells
answer
addition
Unlock the answer
question
button that gives options for how to fill cells following a fill operation
answer
auto fill options
Unlock the answer
question
sums numbers then divides by the number of values
answer
AVERAGE function
Unlock the answer
question
the width of the column will increase or decrease so the widest entry will fit
answer
best fit
Unlock the answer
question
formula in a cell that contains a reference back to itself.
answer
circular reference
Unlock the answer
question
colors like blue,green, and violet that tend to pull away from a reader
answer
cooler colors
Unlock the answer
question
the process of finding and correcting errors
answer
debugging
Unlock the answer
question
arithmetic operator that divides contents of a cell
answer
division
Unlock the answer
question
used to indicate the start a formula
answer
equal sign
Unlock the answer
question
arithmetic operator that raises to a power
answer
exponentiation
Unlock the answer
question
display a dollar sign in the far left of the cell
answer
fixed dollar sign
Unlock the answer
question
dollar sign that appears immediately to the left of the first digit
answer
floating dollar sign
Unlock the answer
question
text and graphics that print at the top of each page
answer
footer
Unlock the answer
question
can be assigned to a cell and will display calculated result
answer
formula
Unlock the answer
question
shows the actual formulas you have entered rather than the resulting values
answer
formulas version
Unlock the answer
question
pre-written formula built into excel
answer
function
Unlock the answer
question
text and graphics that print at the top of each page
answer
header
Unlock the answer
question
technique used to hide data that is sensitive or not relevant
answer
hiding cells
Unlock the answer
question
lists formatting options following an insertion of cells, rows, or columns
answer
insert options
Unlock the answer
question
portions of a printed page outside the main body of the printed document
answer
margins
Unlock the answer
question
displays the highest value for a range of values
answer
MAX function
Unlock the answer
question
Display the lowest value for a range of values
answer
MIN function
Unlock the answer
question
arithmetic operator that multiples
answer
multiplication
Unlock the answer
question
arithmetic operator that makes a number negative
answer
negation
Unlock the answer
question
default view in excel
answer
normal view
Unlock the answer
question
specifies how moved or pasted items should appear
answer
paste options
Unlock the answer
question
arithmetic operator that multiplies by 0.01
answer
percentage
Unlock the answer
question
dot on screen that contains color
answer
pixel
Unlock the answer
question
selecting cells for use in a formula by using your finger or the pointer
answer
point mode
Unlock the answer
question
used to find which cells are referenced in a formula
answer
range finder
Unlock the answer
question
used to check worksheet for spelling errors
answer
spell checker
Unlock the answer
question
arithemetic operator that subtracts contents of cells
answer
subtraction
Unlock the answer
question
lists error-checking options following an invalid formula
answer
trace error button
Unlock the answer
question
shows results of the formulas rather than the actual formula
answer
values version
Unlock the answer
question
colors like red and orange that tend to reach toward a reader
answer
warmer colors
Unlock the answer
question
keeps the same cell reference as it copies a formula from one cell to another
answer
absolute cell reference
Unlock the answer
question
values in cells that you can change to determine new values for formulas
answer
assumptions
Unlock the answer
question
button used to copy contents and format of a source area to the office clipboard
answer
copy button
Unlock the answer
question
auto fill option that fills destination area but does not create a series
answer
copy cells
Unlock the answer
question
shows the date a workbook was created or the time period it represents
answer
date stamp
Unlock the answer
question
button used to move the contents of a cell to the left two spaces
answer
decrease indent
Unlock the answer
question
using touch or the mouse to move or copy cell
answer
drag and drop
Unlock the answer
question
key that can be used in place of the paste button
answer
enter
Unlock the answer
question
auto fill option that fills destination area using format or source area
answer
fill formatting only
Unlock the answer
question
auto fill option that fills destination area with series of months
answer
fill months
Unlock the answer
question
default auto fill option that excel used to fill an area
answer
fill series
Unlock the answer
question
auto fill option that fills destination area with contentes without formatting
answer
fill without formatting
Unlock the answer
question
used to quickly copy a cell's format to another cell
answer
format painter
Unlock the answer
question
symbols that assign a format to numbers as they are entered
answer
format symbol
Unlock the answer
question
to determine the value of a cell on which the formula depends
answer
goal seeking
Unlock the answer
question
bar going across the middle of a split screen
answer
horizontal split bar
Unlock the answer
question
used when you want to assign a value to a cell based on a logical test
answer
IF function
Unlock the answer
question
button used to move the contents of a cell to the right two spaces
answer
increase indent
Unlock the answer
question
cell with only one dollar sign before the column or row
answer
mixed cell reference
Unlock the answer
question
IF function within an IF function
answer
nested IF
Unlock the answer
question
function that will display the current system date and time
answer
NOW function
Unlock the answer
question
formula error messages always begin with this
answer
number sign
Unlock the answer
question
button used to paste a copy of the Office clipboard contents
answer
Paste button
Unlock the answer
question
immediately display when you click the paste button
answer
paste options button
Unlock the answer
question
instructs excel to adjust cell references as it copies to destination area.
answer
relative cell reference
Unlock the answer
question
scrutinizing the impact of changing values referenced by a formula in a celll
answer
sensitivity analysis
Unlock the answer
question
shows trends and variations in a range of data within a single cell.
answer
sparkline chart
Unlock the answer
question
breaking the excel window into four panes
answer
splitting (chapter 3)
Unlock the answer
question
format that underlines only the characters in a cell , not the entire cell.
answer
underline
Unlock the answer
question
bar going up and down the middle of a split screen
answer
vertical split bar
Unlock the answer
question
number that the function returns is not constant
answer
volatile function
Unlock the answer
question
to magnify the appearance of a worksheet or chart
answer
zoom in
Unlock the answer
question
to shrink the appearance of a worksheet or chart.
answer
zoom out
Unlock the answer
question
cell references with dollar signs
answer
absolute cell reference chapter 4
Unlock the answer
question
shows beginning/ending loan balances and amount that is principal/interest
answer
amortization schedule
Unlock the answer
question
payments made at end of each of a fixed number of periods at fixed interest rate
answer
annuity
Unlock the answer
question
when excel continually will review the workbook for errors
answer
background formula checking
Unlock the answer
question
often created from column and row titles
answer
cell name
Unlock the answer
question
ensures that users do not change values critical to a worksheet
answer
cell protection
Unlock the answer
question
unused column with a significantly reduced width
answer
column border
Unlock the answer
question
print option that indicates where comments are to be displayed on a printout
answer
comments box
Unlock the answer
question
used to automate data analyses and organize the answers returned by excel
answer
data table
Unlock the answer
question
button used to invoke the formula checker
answer
error checking button
Unlock the answer
question
can be dragged to create a series
answer
fill handle chapter 4
Unlock the answer
question
checks formulas in a worksheet for rule violations
answer
formula checker
Unlock the answer
question
function that returns future value of an investment
answer
FV function
Unlock the answer
question
assigning a format to all the cells in all the worksheets in a workbook
answer
global formatting
Unlock the answer
question
print option that instructs excel to print Gridlines when selected
answer
Gridlines check box
Unlock the answer
question
shows only the parts of a workbook that user needs to see
answer
hiding
Unlock the answer
question
adds clarity to your formulas by allowing you to assign names to cells
answer
Name Manager
Unlock the answer
question
print option that determines the order in which multipage worksheets print
answer
page order area
Unlock the answer
question
used to protect a worksheet
answer
password
Unlock the answer
question
calculates loan payment based on loan amount and constant payments/interest
answer
PMT
Unlock the answer
question
rate
answer
function chapter 4
Unlock the answer
question
cells that you cannot change
answer
protected cells
Unlock the answer
question
function that returns the present value of an investment
answer
PV function
Unlock the answer
question
used to highlight cells that provide data for a formula
answer
range finder chapter 4
Unlock the answer
question
function used to round values
answer
ROUND function
Unlock the answer
question
used to display a menu that identifies errors
answer
Trace error button Chapter 4
Unlock the answer
question
cells that you can change
answer
unprotected cells
Unlock the answer
question
a series like : 1, 1, 1, 1, etc
answer
auto fill series
Unlock the answer
question
formula that depends on its own value
answer
circular reference
Unlock the answer
question
process of summarizing data included on multiple worksheets onto one worksheet
answer
consolidation
Unlock the answer
question
allow you specify how a cell entry assigned a format will appear
answer
custom format codes
Unlock the answer
question
a series like Jan , Feb, Mar, etc
answer
date series
Unlock the answer
question
allows you to enter a number once and copy it through other worksheet
answer
drilling an entry
Unlock the answer
question
used to grad thorough cells to create a series
answer
fill handle
Unlock the answer
question
format in which dollar sign appears in same position in a cell
answer
fixed
Unlock the answer
question
appears at the bottom of every printed page
answer
footer chapter 5
Unlock the answer
question
a series that multiples values by a constant factor
answer
growth series
Unlock the answer
question
appears at the top of every printed page
answer
header
Unlock the answer
question
a series like 1,2,3,4 etc
answer
linear series
Unlock the answer
question
reference to a cell or range of cells in another workbook
answer
link chapter 5
Unlock the answer
question
white space surrounding the printed worksheet or chart
answer
margin
Unlock the answer
question
allows you to merge styles from other workbooks
answer
merge style button
Unlock the answer
question
format style that excel initially assigns to all cells in a workbook
answer
Normal style
Unlock the answer
question
show the boundaries of what will print on each page
answer
page breaks
Unlock the answer
question
used to round numbers to a specified number of decimal places
answer
Round function chapter 5
Unlock the answer
question
a linked workbook
answer
source workbook
Unlock the answer
question
group of format specifications that are assigned to a style name
answer
style
Unlock the answer
question
used to reference cells in other sheets in a workbook
answer
worksheet chapter 5
Unlock the answer
question
worksheet name
answer
worksheet reference
Unlock the answer
