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

Transactional leadership, Transactional leadership: The transactional ...

Transactional leadership: The transactional leadership is one more category of leadership style at which point the leader accepts certain tasks to perform and provide rewards

Marketing environment, How to find what the marketing environment is for a ...

How to find what the marketing environment is for a company

Case of flex bump, Case of Flex bump Becker and Fagen are two observer...

Case of Flex bump Becker and Fagen are two observers of organizations. They are attempting to understand organizational dynamics, developments, and strategies in the firm FLEX

Determine the inter-arrival time distribution, The events of 9/11 and the s...

The events of 9/11 and the subsequent implementation of a number of unilateral and joint border security policies have resulted in an increase in cost of cross border trade between

Assess the future of outsourcing, Assess the future of outsourcing with reg...

Assess the future of outsourcing with regard to its impact on employees, executives. Future of outsourcing - Employees as Specialists, Specialised companies and specialized emp

Modes of strategic management are the approaches adopted, QUESTION 1 Or...

QUESTION 1 Organisations resist change for many of the same reasons as individuals do. There are also many forces inside an organization that create resistance to changes initi

Compare e-commerce to e-business, Question: a) Decribe e-commerce from ...

Question: a) Decribe e-commerce from a communication and a commercial perspectives. b) Compare e-commerce to e-business. c) Distinguish between Click-and-mortar and Brick

Ethics & business, First, think about your own upbringing and values when f...

First, think about your own upbringing and values when faced with an ethical decision, whether it is in a business environment or not. How are your beliefs the same as or differe

Describe advantages and disadvantages of holding inventory, Describe advant...

Describe advantages and disadvantages of holding inventory You are the Logistics Manager for a Spanish retailer of sports clothing and equipment (shirts, shorts, swimwear, train

Problem based on exquisite flowers, Normal 0 false false fa...

Normal 0 false false false EN-US X-NONE X-NONE a) The benefits to Natalie in operating as a soli

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