• 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

    You could do this by making a query to find the top three scores in place order (first, second, third) and whether the contestant is not late. Another query is to have a winner regardless of lateness or address (outside the North West).

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

    This feature was used here to allow the various employee numbers to be selected from a list and when the employee numbers are selected, all the relevant data to that employee is also automatically filled in. The combo box was created from the 'Forms' toolbar which was displayed by selecting the 'View' menu, 'Toolbars' and 'Forms'.

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

    change the pricing of any show, all the user must do it click on the square which contains the previous amount and change it to the new amount, this will then do so without any other changes and should not result in anything becoming non-functional. Also the spreadsheet allows Mr.

  1. computerised spreadsheet for pupil attendance data

    I will need to know the subject or area that they are going to be marked in. My minimum hardware requirements are follows: Pentium II 266 MHz or higher 64 MB RAM 100 MB Free Hard Drive Space 15 Inch Colour Monitor supporting 800 x 600 VGA Monitor Resolution (1024 x 768 highly recommended)

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

    My first task was to rename the first worksheet so that I knew what that worksheet was going to be used for, I did this by: 1) Right clicking the tab where it says "Sheet 1" and then clicking on "Rename" 2)

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