|
admin submitted, made popular 126 days ago
( www.usd.edu)
Likewise, we can also insert...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Sometimes we (all) make mistakes or things change
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
We often need to format the numbers to display the appropriate number of decimals, dollar signs,...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Spreadsheets can be pretty dry, so we need some tools to dress them up a little
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
We can also fill right. We must select the original cell (and the cells to the right) and select...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Sometimes it is necessary to keep a certain position that is not relative to the new cell location
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Often we have several cells that need the same formula (in relationship) to the location it is to...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
In Excel there is a help tool for functions called the Function Wizard
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Excel has most of the math and trig functions built into it
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The IF function will check the logical condition of a statement and return one value if true and a...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The CountA function in Excel will return the number of entries (actually counts each cell that...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The Count function in Excel will return the number of entries (actually counts each cell that...
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The MIN function in Excel will return the smallest (Min) value in the selected range of cells
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The MAX function in Excel will return the largest (max) value in the selected range of cells
More...
|
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
The average function finds the average of the specified data
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Probably the most popular function in any spreadsheet is the SUM function
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
Formulas are entries that have an equation that calculates the value to display
More...
|
|
|
admin submitted, made popular 126 days ago
( www.usd.edu)
In a spreadsheet there are three basic types of data that can be entered
More...
|
|
|