# 5. What is the interest charged for the first month?Chileant EvcelEs.0FORMULASPAGE LAYOUTDXDATAR HOMECalibriREVIEWINSERTNIEWEric Gate5conditional FormattingAccounting\$.%AMFormat as TableW6Cell StylesCells EditingNumberAllgnmentFontStylesOioe-D4CDGHOPrincipal:\$ 1,000.001 Buying a Flat Screen TVAPR:12%MonthDouble-click on the fill handle ofthe highlighted cells to quickly filldown to month 12 (you must havemonths 1-12 already filled in)Interest New BalanceBalance1 \$1,000.00 \$ 10.00 \$ 1,010.002 \$1,010.00 \$ 10.10 \$ 1,020.10Period:3 MonthNo. of periodsin tyear:12Periodic Rate:1.0%SheetsCar LoanCredit CardAVERAGE S60.07 COUNTS SUM: S2040.20130READYScreenshots from Microsoft Excel. Used by permission of Microsoft Corporation.Cell Reference HandbookChanges the row number when you fill up/down and changes thecolumn letter when you fill left/right.SA4 Changes the row number when you fill up/down and fixes thecolumn letter when you fill left/right.A\$4 Fixes the row number when you fill up/down and changes thecolumn letter when you fill left/right.SA\$4 Fixes the row number when you fill up/down and fixes the columnA4RelativeMixedMixedAbsoluteletter 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.7n

Question

Why do we need to fill in the second row before we fill the formula down?

Step 1

In any question which demand the excel sheet the first step is to be all the data as the formulas work on data.

if we donot put data and directly...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in