• 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. ICT BTEC UNIT 2 - REPORT

    From what I have observed both "Magix Website Maker" and "First Page V3 Final" are very basic and have some issues, although small can become very annoying when you put the program into action. Although I don't like Magix Website Maker I must admit that it has one good thing

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

  1. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    From the toolbar, I selected the combo box icon (shown below) and dragged it across the desired position. I then right-clicked on the box and selected 'Format Control' to display a dialogue box and in the 'Input Range', I highlighted the list of employee numbers.

  2. The aim of my project is to make the task of the allocation of ...

    It will also allow detailed reference of how many children were there, the amount of adults and concessions, and allow their prices to be changed in an easy way. The spreadsheet permits Mr. Brown to easily change the values of each calculation by changing the appropriate square, for example to

  1. computerised spreadsheet for pupil attendance data

    Windows XP professional) Internet Access Microsoft Internet Explorer 5.0 or above The various hardware, which I have chosen is mainly to cope with the powerful programs that I will be using and to be able to multi task so that I can switch between different files and programs for an easy spreadsheet build up.

  2. 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)

  1. GNVQ intermediate ict unit 4

    I clicked on the stop button to stop the macro recording. I then did the same and created another button for the graph that printed a graph of the results and the spreadsheet looked like this (shown below). I right clicked on the buttons and edited the text to show the user what buttons to what.

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

    Once I had clicked on "Rename", the tab turned black and allowed you to type in your preferred name. The tab then turned back to white, once I had finished typing the name "menu" and had pressed enter. Step 5 Next, I decided I wanted three tables which included the headings I required, in worksheet 2.

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