WGU C268 INTRODUCTION TO SPREAD SHEET EXAM SUMMARISED NOTES 2023

WGU C268 INTRODUCTION TO SPREAD SHEET EXAM SUMMARISED NOTES 2023 Functions and Formulas Relative Cell References: when the references cells in a formal are automatically updated to the new column when the formula is copy/pasted into a new column. Example: D3=C1+C3 changes to F3=E1+E3 when copied from cell D3 to cell F3 Absolute Cell References: when the referenced cell used in a formula is constant. Example: D4=C$1+C4 will only update C4. The C1 cell reference remains constant. 4 types of Absolute Cell References:  A1: both the column and the row are relative and WILL change as pasted  $A1: the column is absolute (constant), the row is relative and WILL change  A$1: the column is relative (will change) and the row is absolute (constant)  $A$1: the column and the row are absolute (constant) Basic Functions:  Sum  Count: count the number cells within a range that contain numbers (and ONLY numbers)  Counta: count the number of cells within a range that not blank (any input)  Average:  Max:  Min:  Sumif: criteria range, criteria, summed values range NOTE: Autoum automatically does these 5 functions: count, sum, average, max, and min Pivot Tables Financial Functions almost always require multiple arguments  Rate=(nper, pmt, pv, [fv], [type], [guess]) Calculates the interest rate earned for an investment given the number of payments, the payment amount, and the current value. NPER is number of payments, pmt is the payment amount, pv is the present value.  Effect=(nominal_rate, npery) Calculates the annual percentag