• 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

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

  2. ICT BTEC UNIT 2 - REPORT

    The only disadvantage to this package is the minimal consideration paid to Video Studio's wizard-driven DVD authoring capabilities.

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

    Auto Filters Above is the 'Staff Finance' sheet which shows the used of auto filters. Filtering is a quick and easy way to find and work with a subset of data in a list. A filtered list displays only the rows that meet the criteria that have been specified for a column.

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

    a glance what the lowest and highest score was, and the class average; from seeing this data she can then tell if the class is doing well or if extra work is required. To calculate the max, min and average, I completed the following steps: 2)

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

    We will change the selection and see whether or not the grand total changes according to the cost of the show. OK. The drop down menus were used with the previous test. See pictures on page 17. It will solve the problem of the requirement of a calculator, which would

  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

    "What if"............Queries In this exercise I am going to change the scores of the points for the "Athletic Championship".

  2. computerised spreadsheet for pupil attendance data

    * The spreadsheet must calculate details relating to each student's performance (results/marks) and how their performance relates to others in the class. * The spreadsheet must calculate the total number of marks for each student each time a new set of marks is entered.

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