ACCA Applied Knowledge · Management Accounting · Spreadsheets
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 P507 even if the list is unsorted?
Use =VLOOKUP(E2,A2:B9,2,FALSE). The FALSE argument forces an exact match, which is required for unsorted data, and column index 2 returns the unit cost rather than the product code.
- A=VLOOKUP(E2,A2:B9,2,TRUE)
- B=VLOOKUP(E2,A2:B9,2,FALSE)Correct
- C=VLOOKUP(E2,A2:B9,1,FALSE)
- D=HLOOKUP(E2,A2:B9,2,FALSE)
Explanation
An exact match (FALSE) is needed for unsorted data, and column index 2 returns the cost column. TRUE assumes sorted data and may return a wrong value. Index 1 would return the code itself, and HLOOKUP searches across a top row, not down a column.
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 cost accountant has monthly sales units in cells B2:B13. She wants the average monthly sales volume, ignoring any blank cells. Which formu…
- In a spreadsheet, the finance team of Harbor plc has a table of cost data with 20 rows. They want to display only the rows where the cost ce…
- A budget model has quarterly sales in B2:E2 (Q1 to Q4: 200, 240, 260, 300 units) and a unit price in cell G1 ($50). In B3 a formula =B2*G1 i…
- Cells A1 to A5 contain the values 10, 20, 30, 40 and 50. Cell B1 contains the formula =SUMIF(A1:A5,">25") and cell B2 contains =AVERAGEIF(A1…
- A company records sales of 40, 55 and 75 units for three products in a table and wants a component bar chart in a spreadsheet showing each p…
- Which of the following is the main advantage of using a spreadsheet model for a cash budget rather than preparing it manually?