• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency at the bookshop.

Extracts from this document...

Introduction

D1: Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve efficiency Excel offers many faciliets, one of them being shortcut keys. A shortcut key makes it easier for a user to move among large or multiple worksheets. 1: shortcut - key 2: effect For moving around a worksheet: 1: Ctrl + End 2: This moves the cell pointer back to the last cell used in the worksheet 1: Ctrl + Home 2: This moves the cell pointer Moves to cell A1 1: Home 2: This moves to the beginning of a current row e.g. column A1 1: Page Down 2: This moves the screen one down 1: Page up 2: This moves the screen one up Selecting Cells 1: Ctrl + A 2: This selects the current data region in the worksheet 1: Ctrl 2: This allows you to select regions that are not next or close to each other Moving between worksheets 1: Ctrl + Page Up 2: This moves to the next worksheet 1: Ctrl + Page Up 2: This ...read more.

Middle

To edit them, you can double click on them, spreadsheet will open and you can make your changes there. Advantages of using spreadsheet to JEM bookshop - Spreadsheet is very flexible If JEM Bookshop uses spreadsheet, it would be very flexible, as you are able to open there data anywhere-as long as they computer has spreadsheet, which most computers do- or save it on the USB, and bring it to meetings outside their firm. This shows that spreadsheet it used by many people and can be used by many software's or technologies. - It can be used for all types of applications As I said previously, JEM Bookshop can Use their Spreadsheet on many applications, such as: Microsoft office for mail merge. The applications that spreadsheet can used for, are widely know, and used around the world. - The structure of table allows it to store values that represent sales figures, profit, number etc. This would help JEM Bookshop with their finance, as they could create their Break even chart; Profit and Loss account; Balance sheet; Gross Profit Margin etc. ...read more.

Conclusion

it would be more efficient easily to use, it saves time for the business thus, allowing JEM Bookshop to spend more time on their business. In reality JEM bookshop could use spreadsheet for a lot of things, rather than by doing it paper based. It provides better security, accuracy and reliability. A lot of successful business use spreadsheet in order to produce chart or graphs for a presentation or just using it to solve financial matters. Not only is it easier, but it provides many tools such us, filtering, sorting, calculating etc. Refining your solution to make it easier for users to use: Step 1: lock cells Step 2: Highlight required cells that needs to be locked Step 3: Select format and the cell selection Step 4: Drop down list appears Step 5: click lock cell. You could use this method to lock important cells, like the cells in the diagram below which, you don't want other staff or public to touch or change. ?? ?? ?? ?? Huriya Nazari D1- Unit 10 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Database Review of Document

    Windows has search engines to find lost programmes and files, provided you are using Windows.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    In order to do that I must make a nested IF function to say how many merits the child will get depending on percentage gained. So, I followed the steps shown previously and wrote a formula which said, if the child exceeded their target they got 2 merits, if they

  1. Research, collect and describe graphics

    Size: Small - does not restrain bandwidth. Pos.: Noticeable, yet not annoying to users as it is small and located at the top; it does not interrupt the user. Neg.: Isolated from the rest of the website; takes up too much space: less turgid impact. Source: www.aol.com Date: 12th Sep 08 Navigation Bars Source https://www.paypal.com/ http://www.google.co.uk/ (Personale)

  2. ICT BTEC UNIT 2 - REPORT

    do things for yourself where as other programs do everything for you and you don't really have a great deal of control over them and don't really get the chance to have your say. The one thing that all of the packages have in common are that they are all

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    Another problem he faces is modelling his finances. He is not able to predict what kind of difference making a change to the retail price will have on the income and the profit. If he wants to do this he has to calculate and re-calculate, he also needs to re-check

  2. GNVQ intermediate ict unit 4

    You can use cell formats to determine what data will be entered into the cell. The cells I have used in my spreadsheet have text in them, so I have used text format for the cells that have numbers in them I have used number format.

  1. implementation report

    Appendix 13 Appendix 13 shows that the wizard then asked me what layout I wanted the form to be, so I clicked on columnar as this would make the form easier to understand for the user Appendix 14 Appendix 14 shows that when I clicked next the wizard asked me

  2. Database Techniques and Applications Report

    in the customer ID and prevent me from doing the same action for each customer. For the Surname, Forename, Postcode, and Flower ID I decided that the most appropriate selection was Text. For the Gender I decided to do 'Lookup Wizard' and then request to type in my own values,

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work