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

Using an evaluation framework, QUESTION 1 Using an Evaluation Framework...

QUESTION 1 Using an Evaluation Framework, assess the past and ongoing contribution of foreign firms in the Mauritian Export Processing Zone QUESTION 2 Protectionism is

Mergers and acquistions, • Discuss how the successful mergers (the 2 merger...

• Discuss how the successful mergers (the 2 mergers you identified earlier) affects the following areas of HR; • HR planning • Selection • Compensation • Performance Appraisal • Tr

Push factors in diversity, The 1990s saw the development of a new trend in ...

The 1990s saw the development of a new trend in the form of workforce diversity mainly because of the liberalisation and globalisation of markets (Henry and Evans, 2007). As the bu

Test markiting, various approches in test marketing.

various approches in test marketing.

What are the strong retention strategies, Question : "Strong retention ...

Question : "Strong retention practices may reduce turnover, but they limit the introduction of new talent, knowledge and perspectives, leading organisations to become stale an

“’Confessions of a Microfinance Heretic’: Talks at G, dear team i need to m...

dear team i need to make a case analysis of 1500 woeds on the following topic, video is also provided with the instructions from university. please contact me asap.

Organising behaviour, what could you do to make Rajinder?s transition easie...

what could you do to make Rajinder?s transition easier?

What pricing strategies would you recommend, Question: Price is the onl...

Question: Price is the only element of the marketing mix which generates revenue, the other elements being all associated with costs. Hence its determination is crucial for any

Different types of communication, Explain the different types of communicat...

Explain the different types of communication with relevant examples.

Technology uses, what is use of technology in banking sector

what is use of technology in banking sector

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