ACCA Applied Knowledge · Management Accounting · Spreadsheets
In a spreadsheet, cell B2 contains the formula =A2*$D$1 and is copied down to cell B3. Which formula will appear in B3?
The formula in B3 will be =A3*$D$1. When copied down, the relative reference A2 adjusts to A3, while the absolute reference $D$1 stays unchanged because both its column and row are fixed with dollar signs.
- A=A3*$D$1Correct
- B=A3*D2
- C=A2*$D$2
- D=A3*$D$2
Explanation
The relative reference A2 moves down one row to A3 when copied. The absolute reference $D$1 is fixed in both column and row, so it does not change. Option =A3*$D$2 wrongly treats the row of D as relative.
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 management accountant builds a budget model in a spreadsheet. Selling price per unit, variable cost per unit and annual fixed costs are ty…
- A management accountant wants to show how total monthly production cost of Lakeside Ltd is split between direct materials, direct labour and…
- A product table has product codes in A2:A5 (P1, P2, P3, P4) and unit costs in B2:B5 ($4, $7, $9, $12). Which formula returns the unit cost f…
- A management accountant wants to show how total monthly production cost of 100% is divided between direct materials, direct labour and overh…
- Monthly sales in cells B2:B7 are 12, 15, 9, 18, 15 and 11 (in $000). Which of the following correctly gives the result of =MEDIAN(B2:B7) and…
- A cost schedule lists product codes in A2:A9 and unit costs in B2:B9. Cell E2 holds the code P507. Which formula returns the unit cost for P…