• 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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Step 11 Following that, I copied and pasted the two tables and pasted them next to the "reading" table; these two new tables were for "Writing." I then changed the scores for each term; fortunately all my functions were correct so they changed the values automatically.

  1. Research, collect and describe graphics

    http://www.aria.co.uk/ http://www.comet.co.uk/ Target Audience People who want to navigate around help sites within the Paypal website easily People who want to navigate to other options within the Google website more easily. People who want to navigate through all of Aria's product areas in one quick place.


    very easy to use and most of them are very quick, they will be quicker depending on the computer. All of the programs have their own system requirements however if your computer specs are higher than the requirements of the program than it's bound to be faster, more efficient and less tedious.

  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

    B13 maybe easier to just fill in data by using the fill option in the edits menu. By doing this it will automatically increments the cell reference number. To get around this I had to use absolute cell referencing where I told the spreadsheet to look at a specific place that would not change.

  1. implementation report

    writing as the main page so that the system would look professional; I also added the same pictures as the main page to make it look even more professional Now that the layout of the form had been created I had to add command buttons to do specific jobs to


    I have used a blue line and also blue font for when I put a title there. The font looks rather presentable as well so looks more professional. However a disadvantage would be that there is not enough information about the customers. And there is no title for the report.

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