Excel 2010: How do i answer these questions with SUMIF/VLOOKUP?

HI,

I have questions to answer on a excel 2010 finance spreadsheet:

- Complete "Expense Type” column with:
(a) "Income" for account codes beginning with "4"
(b) "Pay" for account codes beginning with "51"
(c) "Non Pay" for all other account codes5. Forecast the outturn on a straight line basis rounded to the nearest £

- Forecast the outturn on a straight line basis rounded to the nearest £

- Calculate the variance between Annual Budget and Forecast Outturn. Denote an adverse variance as a negative number.

- Using a formula, complete the table in worksheet labelled Table 2.


what formulas/functions would you use for each question?

here is a screen shot of the spreadsheet, there are 1000 rows

Untitled.jpg

thanks