If sales taxes are equal to 5% of total quarterly sales, and they are paid at the end of each calendar quarter, which formula could be entered into F16 and copied to every cell in row 16 to get the correct value in each cell?
a) =0.05*SUM(D2:F2)
b) =IF(MONTH(F1)=12,0.05*SUM(D2:F2),0)
c) =IF(MOD(MONTH(F1),3)=0,0.05*SUM(D2:F2),0)
d) =IF(MOD(MONTH(F1),2)=0,0.05*SUM(D2:F2),0)
c) =IF(MOD(MONTH(F1),3)=0,0.05*SUM(D2:F2),0)
You might also like to view...
Which of the following is true of the product life cycle (PLC)?
A) All products generally go through all five stages of the PLC. B) All products pass through the stages of PLC in the same order. C) It is generally difficult to forecast the sales level at each PLC stage. D) The PLC concept can be applied to styles but not to fashions and fads. E) Product forms have longer life cycles than product classes.
Increased interconnectedness of people and nations worldwide is a major reason for increased emphasis on international public relations
Indicate whether the statement is true or false
Which of the following is an incorrect statement regarding an economic strike?
A) An economic strike is a protected activity. B) As a general rule, once an economic strike is over, strikers are entitled to return to their jobs. C) Employers are not allowed to fill economic strikers' jobs while the strike is taking place. D) If permanent replacement workers are hired, strikers are not entitled to return to their jobs.
Ralph is a candidate for public office. Ten years earlier, Ralph went through an ugly divorce and the filings made by his ex-wife accused him of theft, child abuse, and distribution of pornography. The allegations were never addressed by the court or proven. The clerk of the court is from a different political party and checked on Ralph by running his name through the docket. When she found the
divorce filings, she fed the information to a reporter. Which of the following statements is true? A) ?The clerk has violated the Privacy Act. B) ?The clerk has not violated the Privacy Act unless the filings were not public. C) ?The clerk is entitled to view and release public records as part of her administrative duties. D) ?State and local agencies are not subject to privacy restrictions on their release of documents.