• 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...


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.


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.


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

    There is unnecessary stress when computers go wrong. If you drop a laptop, laptops break before you can make a backup. You need to employ IT technicians. The scores are not named as "floor scores" and "vault scores" - you could get confused as to which one is A and which is B.

  2. Research, collect and describe graphics

    Suitable since everything is located on the homepage. All the user has to do is navigate through the options to go anywhere around the site. Suitable since the nav.bar is located on the homepage. All the user has to do it scroll over whichever option they want and sub-options linking to every location on the website are displayed.


    When using these programs there are certain things that you must remember for example each of them will require a lot of patients. This could be seen as a disadvantage or a bad thing however some times taking a lot of time can result in a great finished product and

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

    it to various companies, asking questions like 'How would you rate your filing system', or 'How would you like your filing system, computerised or manual', this is to see the efficiency of their filing system. Later then, I can update the present filing system of my organisation (CNE)

  1. GNVQ intermediate ict unit 4

    The background is striking and the information is clear to read. Consequently it might have been more accurate but not easy to read quickly by the scorer. For my system graph I will choose a variation of the bar chart used in the first graph.

  2. implementation report

    Appendix 24 Appendix 24 shows the wizard for creating a command button which allows you to preview reports, as Mr Patel wanted to know the overdue videos and this would pick out for him which members have overdue videos. Appendix 25 Appendix 25 shows that I chose the overdue videos report, because I am creating a command button for this.


    However the disadvantages of this design are that is quite basic and unprofessional. Design Two Here is my second design is similar to my first design, but with a few slight changes. One of the advantages of this design is the new font which looks nice and attractive.

  2. computerised spreadsheet for pupil attendance data

    My friends teacher asked for a number of requirements to be met, they are as follows: * Dave needs to use a spreadsheet to keep a record of the attendance of all of the students in the class. * At the end of each half term he needs to be

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