Chapter 3, Problem 10RA

Use the _____________ function to calculate cumulative interest paid for a loan with 5 year period. CUMIPMT()   PMT   CUMFREQ()   none of the choices   CUMPRIN()

Ss.227. In cell D5, construct a formula to calculate the % of Total Projected Investments for Pooled Investments by dividing the Projected Investments for Next Fiscal Year for Pooled Investments by the Total Projected Investments for Next Fiscal Year. Use absolute cell references as necessary, format the result in Percent Style, and Center the percentage. Fill the formula down through cell D9.

An auto mobile company manufacture both a two wheeler and a four wheeler.A company manager wants to make the production of both types of vehicle according to the given data below . 1st data , total no of vehicle (two-wheeler+four-wheeler)=v The task is to find how many two wheelers as well as four wheelers need to manufacture as per the given data.

Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee.    Status              Vacation Time Earned Full TIme                       10 Part Time                        7 Contract                          0   Employees              Status                   Vacation TIme Earned John                        Contract Jane                        Part Time Al                            Full TIme

Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below.   Sales ($)                       Commission 1–5,999.99                   10% of sales 6,000–29,999.99          $600 plus 13% of the sales over 6,000 30,000 and over           $3,720 plus 14% of the sales over 30,000   Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000.   $700 if the salesperson travels.   Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due

Problem 21 Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21. SELECTMIN(CUSTOMER.CUS_BALANCE) AS 'Minimum Balance',MAX(CUSTOMER.CUS_BALANCE) AS 'Maximum Balance',ROUND(AVG(CUSTOMER.CUS_BALANCE),2) AS 'Average Balance' FROM CUSTOMER WHERE CUS_CODE IN(SELECT CUS_CODE FROM INVOICE);    This does not work, what am i missing it is suppose to be    Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30

Which function to be used to calculate the total customers who are above 35 years of age and earning more than 10 lacs per year. a. countif() b. sumifs() c. sumif() d. countifs()

In cell C19, insert a formula that will calculate the projected advertising spending after the forecasted increase in cell A18 is added to the 2019 total. Ensure that the reference to cell A18 is an absolute cell reference.

Question 4 show work