• 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

    In conclusion for the cons, why fix something that isn't broken? The Closing Report Task 4 CONTENT * Limitations * Possible Improvements and how to improve it. Limitations I) I believe the limitations of the databases to be the lack of reports in my database; reports would make everything easier.

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

    This then showed all the border options. I chose the border which showed all the lines coloured black; the reason I chose to put a black box around each cell in the table is because it made the table stand out more and made it easily recognisable, especially once I had included the other 2 tables.

  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

    * Sony Vegas As they are both very god programs and have many good things going for them in comparison I have noticed that they are both very easy to understand, both compatible with Windows Vista Ultimate and Premium. Both of the packages give you the chance to learn and

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

    The manager has to sometimes has to take the files home because he has no space for them in the shop. This means that there is a very high chance that files will be lost, making it very disorderly.

  2. GNVQ intermediate ict unit 4

    You will indicate if records have been broken alongside each event in each Results Grid by using the function: =IF(First Place Time<Event Record,"New Record","") For the Totals grid I have used a SUM function to total up the scores for each team.

  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. ICT PROJECT PRESENTATION

    ID Auto number Title Text Surname Text Other names Text Gender Text = Male or Female Date of Birth Date/Time Table 2 Records Validation Validation Key ID Auto number Address - 1st Line Text Address - 2nd Line Text Surname Text Table 3 Records Validation Validation Key ID Auto number

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