Shared Flashcard Set

Details

advanced spreadsheet
excel
80
Other
Undergraduate 3
09/24/2012

Additional Other Flashcards

 


 

Cards

Term
formula prefix
Definition
Equal sign preceding a formula
Term
Normal view
Definition
default view in excel
Term
Name box
Definition
part of the excel program window that displays the active cell address
Term
Cell
Definition
intersection of a column and a row
Term
orientation
Definition
direction in which contenets of page will print
Term
workbook
Definition
file consisting of one or more worksheets
Term
255
Definition
maximum number of worksheets you can include in a workbook
Term
cell referencing
Definition
using a cell address in a formula is known as this
Term
scale to fit
Definition
feature used to print a very long worksheet on a single sheet of paper
Term
range
Definition
a selection of multiple cells
Term
page layout
Definition
the worksheet view that shows how your worksheet will look when printed
Term
[F2]
Definition
key you press to switch to Edit mode
Term
Page Break Preview
Definition
view that shows you a reduced view of each page of your worksheet
Term
backstage view
Definition
area where you see a preview of your worksheet
Term
Page layout view
Definition
view where you can see the header and footer areas of a worksheet
Term
Fill handle
Definition
lets you copy cell contents or continue a series of data into a range of selected cells
Term
Fill handle
Definition
lets you copy cell contents or continue a series of data into a range of selected cells
Term
dialog box launcher
Definition
item on the ribbon that opens a dialog box or task pane
Term
drag and drop method
Definition
lets you move or copy data from one cell to another without using the clipboard
Term
[Delete]
Definition
clears the contents of selected cells
Term
Formula Auto Complete
Definition
displays an alphabetical list of functions from which you can choose
Term
[Ctrl]
Definition
key to press to copy while dragging and dropping selected cells
Term
Mixed cell reference
Definition
C$19
Term
Relative
Definition
type of cell reference that changes when it is copied
Term
[F4]
Definition
key to convert a relative cell reference to an absolute cell reference
Term
clipboard
Definition
a temporary window storage area that holds the selections you copy or cut. can not enter a function here
Term
conditional formatting
Definition
chages formatting of a cell that meets a certain rule
Term
button with arrow each way and center line
Definition
centers cell contents over multiple cells
Term
spelling button
Definition
checks for apparent misspellings in a worksheet
Term
[Ctl][Home]
Definition
moves cell pointer back to cellA1
Term
paint bucket button
Definition
displays background color options in a cell
Term
$button
Definition
adds dollar signs and 2 decimal places to selected data
Term
example of accounting number format
Definition
$5,555.55
Term
Conditional Formatting Rules Manager
Definition
feature used to delete a conditional formatting rule
Term
dark italic I button
Definition
button uses to remove the italic font style from selected cells
Term
AutoFit
Definition
the feature used to resize a column to accommodate its widest entry
Term
button with arrow.0 first row and .00 in second row. arrow points left
Definition
button that increases the number of decimal places in selected cells
Term
paint brush
Definition
button that copies multiple formats from selected cells to other cells
Term
column
Definition
compares data using columns
Term
line
Definition
compares trends over even time intervals
Term
combination
Definition
displays a column and line chart using different scales of measurement
Term
pie
Definition
compares data as parts of a whole
Term
pie
Definition
compares data as parts of a whole
Term
area
Definition
shows how volume changes over time
Term
2 point arrow going up down
Definition
pointer used to resize a chart
Term
legend
Definition
object in a chart that identifies the colors used for each data series
Term
chart tools format
Definition
the tab that appears only when a chart is selected
Term
how to move an embedded chart to a chart sheet
Definition
click a button on the Charts Tools Design tab
Term
insert
Definition
tab on ribbon used to create a chart
Term
data series
Definition
a collection of related data points in a chart
Term
FV future value
Definition
function used to determine the future amount of an investment
Term
PV present value
Definition
part of the PMT function that represents the loan amount
Term
SUMIF
Definition
function used to conditionally total cells
Term
PROPER
Definition
function used to change the first letter of a string to uppercase
Term
test_cond
Definition
part of the IF function that the conditions are stated in
Term
required when you enter rate & nper arguments in a PMT function
Definition
consistency in the units used
Term
comparison operator
Definition
used to express conditions such as less than or equal to
Term
dynamic page breaks
Definition
adjusted automatically when rows and columns are inserted or deleted
Term
HTML
Definition
web page format hypertext markup language
Term
watermark
Definition
translucent background design on a printed worksheet
Term
hyerlink
Definition
an object that when clicked displays another worksheet or a web page
Term
data entry area
Definition
portion of a worksheet that can be changed
Term
digital signature
Definition
when added it is used to establish the validity of a workbook
Term
workspace
Definition
used to group several workbooks so that they can be opened together rather than individually
Term
sort
Definition
arrange records in a particular sequence
Term
field
Definition
column in a excel table
Term
table
Definition
organized collection of related information in excel
Term
record
Definition
row in an excel table
Term
header row
Definition
first row of a table containing field names
Term
descending
Definition
the sorting options you use to sort a table of employee names in order from z to a
Term
C,B,A,6,5,4
Definition
a series in descending order
Term
table styles
Definition
way to add formatting to a table
Term
to print on multiple pages, you can define a print title to:
Definition
include field names at the top of each printed page
Term
extracted table
Definition
cell range when advanced filter results are copied to another location
Term
Table_array
Definition
name of the table searced in a VLOOKUP function
Term
Criteria range
Definition
range in which search conditions are set
Term
Data validation
Definition
restricts table entries to specified options
Term
DSUM
Definition
function used to total table values that meet specified criteria
Term
and
Definition
the logical condition finds records matching both listed criteria
Term
Or option
Definition
either criterion can be true to find a match
Supporting users have an ad free experience!