Need Help…
Navigate multiple worksheets in an Excel workbook |
Write formulas that can |
Subtract a number from a cell value |
Divide the values for two cells |
Sum a column |
Count the number of cells in a range |
Use absolute references in a formula (that is, $ as in $D6 or D$6 or $D$6) to allow for the “Fill Down†and “Fill Right†functions |
Subtract two cells and then Fill Down to populate a column with formulas |
Raise a cell to an exponent and Fill Down to populate a column with formulas |
Take a square root |
Average a column |
Calculate the standard deviation of the values in a column |
Compare the following Excel functions with the underlying calculations |
=AVERAGE( ) |
=STDEV( ) |
See Excel Attachment