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

Q: How many milligrams of metal containing 20% silver must be combined it with a milligrams a pure…

A: We have to use use ratio and proportion method to solve the problem

Q: Suppose that the students in your class want to have a party at which they will serve punch to…

A: The objective of the question is to find out how many half-gallon containers of punch are needed for…

Q: How many litres of a 10% alcohol solution must be mixed with 10 litres of a 34% alcohol solution to…

A: Given that  10% alcohol solution must be mixed with 10 litres of a 34% alcohol solution to get a 13%…

Q: How many gallons of a 57% salt solution do we need to mix with 120 gallons of a 30% salt solution so…

A:

Q: A farmer owns 100 pigs, and each pig weighs 90 kilograms. One pig costs 20 pesos per day to keep. A…

A:

Q: A real estate company bought a parcel of land containing 282 acres and plans to divide it into lots…

A: Here, total area=282 acres One third of the land must be used for streets. Then, the area used for…

Q: An inlet faucet can fill a small pond in 60 minutes. The pond can be emptied by an outlet pipe in 80…

A: Consider the provided information, How long will it take the pond to fill? Let x- rate of inlet pipe…

Q: y car can travel 150 miles with a full gas tank. Now the deposit has 2/6 of the total. How many…

A: We can cover a total of 150 miles with full tank, miles in kilometer = 150×1.6=240 kilometers Now,…

Q: How much of pure (100%) orange juice must be added to 35 gallons of a 21% orange juice solution to…

A:

Q: a tank is filled to capacity 30% .if we add 35 liters it goes to capacity 80% .what is the capacity…

A: It is given that the tank is filled to 30% capacity. Later, 35 litres added to the tank which…

Q: While three soldiers guarding an orchard, a theif came in and stole come apples. On his way out, he…

A: Given that While three soldiers guarding an orchard, a theif came in and stole come apples. On his…