Shared Flashcard Set

Details

Chapter 2
Inserting Formulas in a Worksheet
20
Other
12th Grade
02/05/2009

Additional Other Flashcards

 


 

Cards

Term
Hint
Definition
after typing a formula in a cell, press the Enter key, the Tab key, Shift + Tab, or click the Enter button on the Formula bar
Term
Relative Cell Reference
Definition
where a formula is copied to other locations in a worksheet
Term
Hint
Definition
Use the fill handle to copy a relative version of a formula
Term
Creating a formula
Definition
is more accurate than typing the cell reference since a mistake can happen when typing the cell reference
Term
Smart tag
Definition
if something goes wrong then the tract error button appears
Term
Trace error
Definition
trace your errors that were recently done on excel worksheet
Term
function
Definition
a shortcut to enter a function
Term
argument
Definition
may consist of a constant, a cell reference, or another funtion.
Term
nested function
Definition
if a funstion is included in an argument within a function is it called this
Term
returning the result
Definition
the term returning refers to the process of calculation the formula and then term result means instering the value in the cell
Term
insert function
Definition
button which you press to enter a function
Term
hint
Definition
you can also display the inster function dialog box by clicking the down-pointing arrow at the right side of the sum button and then clicking more functions
Term
hint
Definition
click the downpointing arrow at the eight side of the sum button the formulas tab and common funtions display in a dropdown list
Term
select a function
Definition
displays a function argument palette
Term
finding averages
Definition
easily manupulate data to answer questions by adding together a range of cells and divied by the number of cells added together
Term
max
Definition
max value in a cell range
Term
min
Definition
min value in a cell range
Term
displaying formulas
Definition
ctrl+` to display and turn off display of formula
Term
pmt function
Definition
payment function
Term
hint
Definition
ctrl+; is the keyboard shortcut to insert the current date in the active cell
Supporting users have an ad free experience!