Complex spreadsheet model, Business Management

Assignment Help:

Refine your complex spreadsheet model to improve efficiency.

a) The user needs to enter at least one of the following contact details: Home Phone, Mobile or E-mail address. If all of these have been left blank, then the user needs to receive feedback to ensure that they enter one value.

The maximum garden length, width and radius, Gareth can cater for are:

Length 1000m

Width 750m

Radius 200m

Implement validation to ensure that user entry does not exceed these values.

b) Implement password protection into you workbook to ensure that no unauthorised persons can access the data.
P5

c) Add two additional sheets to your workbook - one named Invoice and the other named Menu.

d) Add macro buttons to each of the four worksheets to enable the user to fully navigate around the workbook. Include a Quit button on the menu.


Related Discussions:- Complex spreadsheet model

Workplace Stress, AsSeek out at least three individuals within your sphere ...

AsSeek out at least three individuals within your sphere of influence and ask the following: What does workplace stress feel like to you? What activities or actions do you or your

What do you mean by line and staff organisation, What do you mean by Line a...

What do you mean by Line and Staff Organisation? Line and Staff Organisation: When the industry grew within size and complexity, the line executives could not carry

Organizations corporate structure, Select an organization of your choice. T...

Select an organization of your choice. The organisation could be one where you work or one where a close family member, or friend, works. It is important that you have access to a

Staff training and production of documentation, QUESTION 1 (a) Rational...

QUESTION 1 (a) Rationalising procedures and redesigning business processes are limited to specific parts of a business. New information systems can ultimately affect the design

Telecommunication networks helps educational administrators, QUESTION P...

QUESTION Problem solving lies at the heart of educational administration. Daily, problematic situations, emerging from the complex and unpredictable nature of the school enviro

Develop a spreadsheet solution for project, Start a new workbook and develo...

Start a new workbook and develop a spreadsheet solution for Gareth's Gardens in order for him to efficiently record his garden orders and produce his customer invoices. The soluti

Business plan and ratio analysis, MK Robe-Stones (MK-R-S) is a large manufa...

MK Robe-Stones (MK-R-S) is a large manufacturing firm which was set up as a Limited company 6 years ago, in 2009, by a family organisation. The firm was originally started as a bus

Explain the recruitment and selection process, QUESTION 1 People are on...

QUESTION 1 People are one of the most important resources in an organization. Consequently, one of the main functions of the human resource manager is to ensure that the organi

International business of ernst & young, International Business of Ernst & ...

International Business of Ernst & Young Ernst & Young is one of the largest global leaders in the professional service provider. As per the changing demand of the customers,

Innovation in business management, I have an assignment as a report writing...

I have an assignment as a report writing and ppt in which I need to present new idea and write report on same. Can you make that assignment for me ? you need to develop a new busin

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd