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

Knowledge management, 1. Discuss the extent to which knowledge building thr...

1. Discuss the extent to which knowledge building through research, development and innovation can generate benefits to both firms and the economy. 2. Why do firms find it necessar

Analyze and discuss the suitable resource management, Waste generation is p...

Waste generation is probably the most visible effect that the hotel industry has on the environment. A typical hotel guest is estimated to produce at least 1 kg of waste per day (C

Explain any five seam class along with illustration, Question 1 What is sa...

Question 1 What is sampling? Explain types of the samples Question 2 Write short notes on following The main elements of a computer-controlled cutting system Round k

Impacting upon intercultural communication, QUESTION 1 Distinguish betw...

QUESTION 1 Distinguish between the three broad theoretical frameworks that attempt to provide an explanation and understanding of communication and culture. QUESTION 2

Bureaucratic management, nestle is an orgnization wether bureacratic approa...

nestle is an orgnization wether bureacratic approach approperiate for the organizational performance or not?

What are the restrictions of budget, What are the restrictions of budget? ...

What are the restrictions of budget? Restrictions of budget: a. As budget is based onto estimates, which is, estimated sales, costs, business circumstances, many more. it

HRM, Ways to measure the success of a selection

Ways to measure the success of a selection

What is video-conferencing and what are its requirements, QUESTION An a...

QUESTION An area where telecommunication is gaining ground among businesses and academics is video-conferencing. However Video-Phone systems have existed for years, but have no

Distinguish between oracy and literacy, QUESTION 1 In deciding on means...

QUESTION 1 In deciding on means of communication, there are several factors to be considered. What are they and how important and determinant are they in producing the expected

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