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

ECDL Sample Questions ›› Spreadsheets

ECDL Sample Questions : Spreadsheets

ECDL Spreadsheet sample question is based on creating a spreadsheet for a fundraising appeal for a local charity. You are asked to develop an outline revenue plan for three events coming up over the year, to carry out various formatting actions, and to make some calculations before presenting the spreadsheet to your committee.

  1. Open the spreadsheet application.
  2. Open a new spreadsheet and create the following revenue 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 the title, Revenues, cell A1, and make the cell contents bold.
  4. Add the correct formula to calculate the sum of cells B4 : B6 in cell B7.(1 Mark)
  5. Replicate the formula in cell B7 to cell C7 and cell D7.
  6. Format the number styles to display a pound sign in row 7 (Widen columns as appropriate.)
  7. Add the header Tax to the right hand corner of the spreadsheet.
  8. Save the spreadsheet as charity to your Candidate Disk and print 2 copies of the table to an output printer if available, or as a print file to your Candidate Disk.
  9. Create a column chart on this worksheet, from the data contained within the cell range A3 to E6.
  10. Add Revenue Forecast as the title for the column chart.
  11. Adjust the chart so that the chart appears below the total row when printed. (You are not going to print the document.)
  12. Save your spreadsheet and close the spreadsheet program.

Next »

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

Other Sample Questions
Sample Interview Questions
Sample Teacher Interview Questions
Sample Citizenship Questions
Accuplacer Sample Questions
Science Bowl sample Questions
Driving Test Sample Questions
Sample Survey Questions Sample Essay Questions
Sample Behavioral Interview Questions

Copyright © 2004-2013, Best BSQ. All Rights Reserved.