Excel flashcards: What's going wrong here?
36 cards. Practise the mistakes that keep coming up in Excel. Think about it, flip the card and say whether you knew it.
What's going wrong here?Loading…
A few questions from this set
- What's going wrong here?=COUNTIF(B2:B9,>500)
- What's going wrong here?=VLOOKUP(E2,A2:C5,3)
- What's going wrong here?=SUMM(A1:A5)
- What's going wrong here?=SUM(A1;A5), copied from a European spreadsheet
- What's going wrong here?=A2+B2/2 to work out the average
- What's going wrong here?=IF(A2>10,High,Low)