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

What are the useful methods of the job evaluation, What are the useful meth...

What are the useful methods of the job evaluation? Method of job Evaluation: Given are the methods wherein job evaluation is completed: 1. Ranking method. 2. Classi

Explain a maslows theory of motivation, "No organisation can succeed witho...

"No organisation can succeed without a certain level of commitment and effort from its members. For that reason .... cholars have always formed theories about Motivation." (a)

What is the ath decision, Do you know What is the ATH decision, and what is...

Do you know What is the ATH decision, and what is it used for? Ans) Most of the investment world worships the bottom line market value of portfolios, and like as focus (without

Contributing factors for aspect of individual behaviour, What are the contr...

What are the contributing factors for specified aspect of individual behaviour? For any specified aspect of individual behaviour, here may be several contributing factors. The

What are the steps in management planning process, What are the Steps in Ma...

What are the Steps in Management Planning Process? Main Steps in Management Planning Process as follows: Planning can be described as deciding in advance what is to be complete

Explain engineering business functions, Identify and explain engineering bu...

Identify and explain engineering business functions. Draw out an organisation chart for an organisation of your choice and explain the roles and functions of an engineering bus

Process management, Process Management: Answer the following questions a...

Process Management: Answer the following questions as related to the process management: 1- What is race condition? Explain how can the semaphore be used to prevent it? 2-

Develop a complete remuneration plan, Most people do not have any comprehen...

Most people do not have any comprehension of the magnitude of the total costs to the firm resulting from a new hire. This assignment will provide the student with an understanding

Principles of management, state and explain the fact every manager needs a ...

state and explain the fact every manager needs a basic knowledge in the principles 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