Question 1 – 6 marks
Spreadsheet Methods - 2013 Exam Mark Scheme
Student Name: ______________________ Total Mark divided by 2 to get %: _________________
|Assessment Criteria |Question Number |Marks |Question |Mark Commentary |
| | |Awarded | | |
| |2 |4 |Merge and centre cells D2 to H2, add the title Furniture Sales Monaghan. Set | |
| | | |the font to Calibri size 14 bold with a shaded background and a thick box | |
| | | |border. | |
| |3 |2 |In cell A4 add the title Today format to bold with a shaded background and a | |
| | | |normal border. | |
| |Mark | |4 |4 |Add each of the headings as shown (back page) from cells A6 to H6, make them | | |
| | | | | |bold with a shaded background, left alignment and add all borders. | | |
|Creating 60 Marks |5 |3 |From cell A7 to C16, E7 to E16 and A21 to B27 add text as shown (back page). | |
| |6 |4 |In cells D7 to D16, G7 to G16, H7 to H19 and B22 to B27 set the format of the | |
| | | |cells currency format, with two decimal places and enter the numeric values as | |
| | | |shown from B22 to B27 (back page). | |
| |7 |3 |Add all borders add shading as shown (back page) | |
| |8 |4 |Insert the date into cell B4 using a function. | |
| |9 |8 |Enter a VLOOKUP formula in cell D7 to add the Gross Price of the Product listed| |
| | | |in C7 (use a named group of cells or absolute cell referencing). Use auto fill| |
| | | |to drag the formula for this column. | |
| |10 |8 |Use a S IMPLE IF to calculate Free Gifts in cell F7 as follows, if a customer | |
| | | |buys more than one product in Quantity they receive a Door Stopper, otherwise | |
| | | |they receive nothing. Use auto fill to drag the formula for this column. | |
| |11 |8 |Use a NESTED IF formula in cell G7 to show the price of the delivery use the | |
| | | |following rules: | |
| | | |If the Gross Price is over €250 charge 0, | |
| | | |If the Gross Price is over €150 charge €10, | |
| | | |Otherwise charge €15. | |
| | | |Use auto fill to copy this formula to cell G16. | |
| |12 |4 |In cell H17 add a SUM formula to find the Total Sales. | |
| |13 |4 |In cell H18 add a formula to find the AVERAGE Sales. | |
| |14 |4 |In cell H19 add a MAX formula to find the maximum Sales. | |
| |Mark/2 | |21 |4 |Delete the row for Declan Treanor. | |
| | | |22 |10 |Add a row above Kay Kelleher and add the following details: | |
| | | | | |Tom First Name, Treanor Surname, Nested Table Product and 2 Quantity | |
| | | | | |Ensure all the formulas are auto filled where needed. | |
|Edit 10 Marks | | | | |
| |23 |6 |Delete column F with the Free Gift. | |
| |Mark | |24 |3 |Name the worksheet ‘Furniture Sales’. | |
|Organise 10 Marks | | | | |
| |25 |7 |Sort the spreadsheet with a two-key sort by the Product and the Total Price. | |
| |Mark/2 | |26 |8 |Create a column chart based on the First Names of the Customers and the Total | |
| | | | | |Price of all people who bought Bunk Beds. | |
|Chart 10 Marks |27 |2 |Save the column chart to a new worksheet and rename the worksheet as ‘Bunk Bed | |
| | | |Sales’. | |
| |28 |2 |Add your name as a chart title e.g. Mary Smith. | |
| |29 |2 |Turn off the Legend. | |
| |30 |2 |Turn on the Data Labels. | |
| |31 |4 |Add appropriate titles to the X and Y axis of the chart. | |
| |Mark | |1 |1 |Save a Spreadsheet as Your Name to the USB provided. | |
| | | |15 |1 |Set the print area of the worksheet to A1 to H27. | |
|Save & |16 |1 |Set the page to landscape and scale to print 1 page wide by 1 page tall. | |
|Print 10 Marks | | | | |
| |17 |1 |Turn on the Row and Column headings. | |
| |18 |1 |Add a Custom Header to include your name and your class group. | |
| |19 |1 |Turn on the formula and print the worksheet ‘Furniture Sales’. | |
| |20 |1 |Turn off the formula and print the worksheet ‘Furniture Sales’ showing the | |
| | | |values. | |
| |32 |1 |Print the Column Chart on landscape orientation. | |
| |33 |1 |Print your worksheet ‘Furniture Sales’ after all editing has been completed. | |
| |34 |1 |Save the spreadsheet as Your Name to the USB memory device provided. | |
| |Total |100 |Comments: |Total Mark: |
| |Marks | | | |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- 1 6 ratio calculator
- 1 6 repeating as a fraction
- jre 1 6 for windows 10
- java 1 6 download for windows 10
- java jre 1 6 32 bit
- java 1 6 download 64 bit
- java runtime environment 1 6 0 for windows 10
- java plugin java 1 6 0 29 download
- jdk 1 6 download 32 bit
- how tall is 1 6 m in feet
- 1 6 m in height
- how tall is 1 6 meters