5. What is the interest charged for the first month? Chileant Evcel Es.0 FORMULAS PAGE LAYOUT DX DATA R HOME Calibri REVIEW INSERT NIEW Eric Gate 5conditional Formatting Accounting $.% A M Format as Table W 6 Cell Styles Cells Editing Number Allgnment Font Styles Oioe -D4 C D G HO Principal: $ 1,000.00 1 Buying a Flat Screen TV APR: 12% Month Double-click on the fill handle of the highlighted cells to quickly fill down to month 12 (you must have months 1-12 already filled in) Interest New Balance Balance 1 $1,000.00 $ 10.00 $ 1,010.00 2 $1,010.00 $ 10.10 $ 1,020.10 Period: 3 Month No. of periods in tyear: 12 Periodic Rate: 1.0% Sheets Car Loan Credit Card AVERAGE S60.07 COUNTS SUM: S2040.20 130 READY Screenshots from Microsoft Excel. Used by permission of Microsoft Corporation. Cell Reference Handbook Changes the row number when you fill up/down and changes the column letter when you fill left/right. SA4 Changes the row number when you fill up/down and fixes the column letter when you fill left/right. A$4 Fixes the row number when you fill up/down and changes the column letter when you fill left/right. SA$4 Fixes the row number when you fill up/down and fixes the column A4 Relative Mixed Mixed Absolute letter when you fill left/right. 6. What formula is in cell C4? D4? 7. Which formula involves an absolute cell reference? Copyright 2017 Pearson Education, Inc. 7 n