ACCA Applied Knowledge · Management Accounting · Spreadsheets
A cell contains the formula =IF(AND(B2>100,C2<50),B2*0.1,IF(B2>100,B2*0.05,0)). What value will it return when B2 = 200 and C2 = 50?
The formula returns 10. The first condition fails because C2 equals 50, which is not less than 50, so the nested test applies; as B2 exceeds 100, the result is 5% of 200, which is 10.
- A20
- B0
- C10Correct
- D5
Explanation
The AND test fails because C2 is not less than 50 (it equals 50). The formula moves to the nested IF, where B2 > 100 is true, so it returns 200 x 0.05 = 10. The answer of 20 wrongly treats the AND test as satisfied.
Did you get it right without looking?
One question tells you little. A timed set on Spreadsheets shows your real accuracy, how long you take and where you lose marks.
More Spreadsheets questions
- A spreadsheet computes contribution as =B3*(C3-D3), where B3 is units sold, C3 is selling price and D3 is variable cost per unit. Test data …
- Which of the following is the main advantage of using a spreadsheet for 'what-if' analysis in budgeting?
- A company's budget workbook is used by five managers. Which combination of controls best reduces the risk of unauthorised or accidental chan…
- Cell C5 contains units sold (800). Cell C6 contains the selling price per unit ($15). Cell C7 contains variable cost per unit ($9). Fixed co…
- Cell A1 contains 200, B1 contains 50 and C1 contains 4. What is the result of the formula =A1-B1*C1/2+(A1-B1)/3 ?
- A spreadsheet holds monthly sales in cells C5:C16 (in $). Cell E1 should show total sales only for months where sales exceed $10,000. Which …