Best site for GRE, LSAT, SAT, GMAT, TOEFL, CCNA, CCSA and interview sample questions

# ECDL Sample Questions : Spreadsheets

ECDL Spreadsheet sample questions is based on developing a budget for a school trip this summer. You are asked to develop a budget for the trip; to carry out various formatting actions, and to make some calculations in the spreadsheet in preparation for the trip.

2. Open a new spreadsheet and create the following budget plan using the cell references as indicated in the table below. Leave the cells marked formula empty. No other formatting is required at this stage.

3. Select cell A1 and make the cell contents bold.
4. Add the correct formula to calculate the sum of cells B4 : B8 in cell B9.
5. Add a formula in cell C4 that calculates flights costs in cell B4 as a percentage of total costs in cell B9. (Ensure cell B9 is made absolute in the formula.)
6. Replicate the formula in cell C4 down through the cells marked formula finishing at cell C8.
7. Format the cell range C4 : C8 with 2 decimal places.
8. Add a blue top and bottom border in cell A9 and cell B9.
9. Insert an image with a 'travel' theme from an image library below row 9.
10. Re-size the image so that the school budget and the image appear on the same page when printed.
11. Save the spreadsheet as budget on your Candidate Disk and print 2 copies to an output printer if available, or as a print file to your Candidate Disk.

Previous

ECDL Sample Question Number : 1-12| 13-24
Sample Test Questions
GRE Sample Questions
CAT Sample Questions
GMAT Sample Questions
TOEFL Sample Questions
ACT Sample Questions
SAT Sample Questions
LSAT Sample Questions
PSAT Sample Questions
MCAT Sample Questions
PMP Sample Questions
GED Sample Questions
ECDL Sample Questions
DMV Sample Questions
CCNA Sample Questions
MCSE Sample Questions
Network+ Sample Questions
A+ Sample Questions
Technical Sample Questions
WASL Sample Questions
CISA Sample Questions