|
Module 4 - Spreadsheets
Module Goals
Module 4 Spreadsheets requires the candidate to understand the concept of spreadsheets and to demonstrate the ability to use a spreadsheet application on a computer. The candidate shall understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet8 of limited scope ready for distribution. He or she shall also be able to generate and apply
standard mathematical and logical formulas using standard formulas and functions. The candidate shall demonstrate competence in creating and formatting graphs/charts.
Module 4 Sample Part-Test 4.1
This is a sample test only.
The following test for Module 4, Spreadsheets, 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.
- Open the spreadsheet application. (1 Mark)
- 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. (4 Marks)
- Select the title, Revenues, cell A1, and make the cell contents bold. (1 Mark)
- Add the correct formula to calculate the sum of cells B4 : B6 in cell B7. (1 Mark)
- Replicate the formula in cell B7 to cell C7 and cell D7. (1 Mark)
- Format the number styles to display a pound sign in row 7 (Widen columns as appropriate.) (1 Mark)
- Add the header Tax to the right hand corner of the spreadsheet. (1 Mark)
- 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. (1 Mark)
- Create a column chart on this worksheet, from the data contained within the cell range A3 to E6. (1 Mark)
- Add Revenue Forecast as the title for the column chart. (1 Mark)
- Adjust the chart so that the chart appears below the total row when printed. (You are not going to print the document.) (1 Mark)
- Save your spreadsheet and close the spreadsheet program. (1 Mark)
Module 4 Sample Part-Test 4.2
This is a sample test only.
The following test for Module 4, Spreadsheets, 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.
- Open the spreadsheet application. (1 Mark)
- 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. (4 Marks)
- Select cell A1 and make the cell contents bold. (1 Mark)
- Add the correct formula to calculate the sum of cells B4 : B8 in cell B9. (1 Mark)
- 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.) (1 Mark)
- Replicate the formula in cell C4 down through the cells marked formula finishing at cell C8. (1 Mark)
- Format the cell range C4 : C8 with 2 decimal places. (1 Mark)
- Add a blue top and bottom border in cell A9 and cell B9. (1 Mark)
- Insert an image with a 'travel' theme from an image library below row 9. (1 Mark)
- Re-size the image so that the school budget and the image appear on the same page when printed. (1 Mark)
- 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. (1 Mark)
- Save your spreadsheet and close the spreadsheet program. (1 Mark)
|
[RETURN] |
