ACCA MA · Chapter 2 · Question 12 of 12
Cell B5 of a spreadsheet contains the formula =B2*(1+$C$1). If this cell is copied to cell C5, what formula will C5 contain?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: A) =C2*(1+$C$1)
Explanation
B2 is a relative reference, so when the formula is copied one column to the right it becomes C2. $C$1 is an absolute reference (both column and row are fixed with $ signs), so it does not change. The copied formula is therefore =C2*(1+$C$1).
More Data analysis and statistical techniques MCQs
- Q2Which of the following sampling methods is a non-random sampling method?
- Q3A cost index (base Year 1 = 100) stood at 160 in Year 4 and 184 in Year 6. What was the percentage increase in costs between Year 4 and…
- Q4Prices and quantities for two items are as follows: Base year: Item X price $2, quantity 15; Item Y price $5, quantity 4 Current year…
- Q5The correlation coefficient between monthly output and total production cost has been calculated as 0.8. What proportion of the variation…
- Q6A company has the following data for five periods, where x is output (000 units) and y is total cost ($000): Sum of x = 50, Sum of y =…