Based on the instructions and my excel worksheet can you let me know my mistakes
Based on the instructions and my excel worksheet can you let me know my mistakes or fix them as well as do the
quiz. the quiz is pasted into the section below and the lab will be attached as well the instructions.
| 1. (TCO 2) An absolute cell reference (Points : 2) causes a potential error. indicates a cell’s specific location and the reference does not change when you copy the formula. occurs when a formula directly or indirectly refers to the cell containing the formula. contains both an absolute and a relative cell reference. |
| Question 2. 2. (TCO 2) In Excel, a function can be defined as a _____. (Points : 2) predefined formula that performs a calculation cell reference or a value list of values and defined names as you enter data into a spreadsheet set of rules that govern the structure and components for a formula |
| Question 3. 3. (TCO 2) =$E2-G$4 contains examples of _____ cell references. (Points : 2) absolute mixed relative constant |
| Question 4. 4. (TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function. (Points : 2) PRESENT TODAY CURRENT SET |
| Question 5. 5. (TCO 2) The _____ function returns a result based on a condition. (Points : 2) MAX TODAY FIND IF |
| Question 6. 6. (TCO 2) The MIN function would identify the _____. (Points : 2) highest value in a range Tallies of the number of blank cells in a range lowest value in a range midpoint value in a range |
| Question 7. 7. (TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____. (Points : 2) logical test lookup value breakpoint table array action |
| Question 8. 8. (TCO 2) A(n) _____ is tested in an IF function to determine if it is true or false. (Points : 2) feature formula condition option |
| Question 9. 9. (TCO 2) Arithmetic operations, cell references, and _____ can be used in Excel formulas. (Points : 2) constants macros programs procedures |
| Question 10. 10. (TCO 2) To simplify entering ranges in formulas, you can use _____. (Points : 2) range names a cell’s relative location both an absolute and a relative cell reference a cell’s specific location |
| Question 11. 11. (TCO 2) The PMT function is best described by which of the following? (Points : 2) It is the periodic interest rate, such as a monthly interest rate. It is the total number of payment periods. It is the present value of a loan. It calculates the periodic payment for a loan with a fixed interest rate and a fixed term. |
| Question 12. 12. (TCO 7) A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose. (Points : 2) theme style template macro |
| Question 13. 13. (TCO 7) Before protecting a worksheet, you should _____ the cells that you want users to be able to edit. (Points : 2) format hide lock unlock |
| Question 14. 14. (TCO 7) Which of the following file formats can store macros? (Points : 2) xlsm csv xml xlsx |
| Question 15.15. (TCO 7) To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette. (Points : 2) ATTACHMENT PREVIEW Download attachmentFirst NaTonal Bank New Loan ReportAuthorAkaria BabbsDate1/15/2016PurposeMonthly “New Loan Report” for the Board of Directors tolist and summarize all new loans for residential housingin the past month.View the AnswerFirst National Bank – New LoansCustomerSelling PriceLoan TermInterest Rate Down Payment Amount to be Financed Monthly PaymentAllen$265,354.00306.25%$66,338.50$199,015.50$1,219.02Arnold$328,788.00155.75%$49,318.20$279,469.80$2,309.68Barber$500,000.00155.75%$75,000.00$425,000.00$3,512.41Bollis$112,485.00306.25%$28,121.25$84,363.75$516.75George$350,000.00306.25%$87,500.00$262,500.00$1,607.88Hood$761,978.00206.00%$152,395.60$609,582.40$4,345.51Morgan$192,940.00155.75%$28,941.00$163,999.00$1,355.37Paul$606,563.00206.00%$121,312.60$485,250.40$3,459.19Pinder$319,765.00306.25%$79,941.25$239,823.75$1,468.99Loan TermInterest Rate155.75%15%206.00%20%306.25%25%Loan StatisticsNumber of Loans9$609,582.40$84,363.75$2,749,004.60% Required forDown PaymentHighest AmountFinancedLowest AmountFinancedTotal AmountFinancedShow entire document |
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
