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

Practices of management.., HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGL...

HOW WILL YOU INFLUENCE PEOPLE TO STRIVE WILLINGLY FOR GROUP OBJECTIVES IN YOUR ORGANISATION (TARGET BASED INDUSTRY ) APPLY YOUR INTERPERSONAL INFLUENCE THROUGH COMMUNICATION PROCES

Explain integrated management of integration, Question 1 i) Consider tw...

Question 1 i) Consider two organisational environment in which one of the organisation is having no or little communication between departments and the other organisation where

Organisation decision to invest in a new enterprise system, (a) When measur...

(a) When measuring the returns on technology investments, Douglas Hubbard (2007) argues that "Everything Is Measurable". Discuss this statement in relation to an organisation's dec

BSHS 382 Version 3 Research and Statistics for the S, What are the basic pr...

What are the basic principles for humane treatment of human subjects in research?

Major types of information systems, QUESTION The Swoosh Ltd (SW Ltd) is...

QUESTION The Swoosh Ltd (SW Ltd) is a company engaged in the manufacture of t-shirts for the local market and for exports. SG Ltd is still using manual procedures across all it

What do you mean by performance appraisal, What do you mean by Performance ...

What do you mean by Performance Appraisal? Performance Appraisal: This appraisal is an impartial and systematic assessment of an employee’s performance onto the job, alon

Factors - decision on proposed strategy change, Factors to Consider Before ...

Factors to Consider Before Taking a Decision on the Proposed Strategy Change Although most of the striking and important questions have been considered or highlighted which

Explain how can man be exposed to mercury, Question: a) (i) What are ...

Question: a) (i) What are the main physical properties of mercury? (ii) Explain how can man be exposed to mercury? (iii) State four health effects of exposure to merc

Affects of packaging and sales promotion in marketing, How is packaging and...

How is packaging and sales promotion affected in marketing management? Packaging: Packaging is a significant activity of a sales promotion department since an attractive

Applied theory, what are the drawbacks in classical and neo classical theor...

what are the drawbacks in classical and neo classical theories of management

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