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

Briefly describe the role of business intelligence, (a) Briefly describe th...

(a) Briefly describe the role of Business Intelligence (BI) in the modern organization. (b) Discuss the organisational decision making process and identify how various Busine

Business environment-specific and general environment , Required: Resea...

Required: Research the external and internal business environments for the business you have chosen.  You should use your text book or another reputable Management text book to

Describe how an organization can assess its service quality, Question 1: ...

Question 1: (a) Total Quality Management (TQM) is an approach to improving the effectiveness and flexibility of a business as a whole (Oakland, 1989). Discuss three of the co

USA Civil Law versus Criminal Law, What is the difference between Criminal ...

What is the difference between Criminal and Civil Law? Provide a real-world example of a dispute that would classified as civil law and one that could be classified as criminal la

Point easticity, calculate point elasticity of demand for demand functionq=...

calculate point elasticity of demand for demand functionq=10-2p for decrease in price from rs 3 to 2

Philosophical Ethics & Business, First, think about your own upbringing and...

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

Age diversity, Research indicates that older employees are more satisfied w...

Research indicates that older employees are more satisfied with their jobs, are more committed to the organisation and possess more internal work motivation than their younger coho

#title.public procurement, what are the main objectives of the procurementA...

what are the main objectives of the procurementAct 2006

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