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 is meant by planning, QUESTION 1 i) Explain what you understand by...

QUESTION 1 i) Explain what you understand by the term internal environment of an organisation ii) Discuss how managers can reduce the influence of the specific external envi

Snap inc., how to start with assignment for stakeholder analysis and strate...

how to start with assignment for stakeholder analysis and strategy program report

Explain about the term lead time, Explain about the term Lead Time. L...

Explain about the term Lead Time. Lead Time: It is the time which takes the stock to reach through Re-order point to minimum stock level. This may be also described as th

Explain the different roles that managers must play, QUESTION Managers ...

QUESTION Managers are directly responsible for the success or failure of any organization. Their main responsibility is to help the organization to achieve its objectives in an

Thought it was safer than starting his own business, is fred ill suited to ...

is fred ill suited to be a franchisee or perhaps dis he just not understand what he was getting into at the contact signing

Explain the main types of legal systems, QUESTION 1 (a) Explain the fol...

QUESTION 1 (a) Explain the following terms relating to culture; power distance, individualism versus collectivism dimension, masculinity versus femininity dimension (b) Explai

Adequate storage facilities, Adequate and well organized warehouse facil...

Adequate and well organized warehouse facilities with went equipped proper handling facilities must be there. It need not necessarily be elaborate and expensive. Such

International business, VK Ltd a multi product company, furnishes you the f...

VK Ltd a multi product company, furnishes you the following data relating to the year 2000. First half sales Second half sales Sales Rs.45000 Rs.50000 Total cost Rs.40000 Rs.4

Homework, i just need the questions at the end of all the chapters to be an...

i just need the questions at the end of all the chapters to be answered

Define the term quality, Quality Management Principle 1. Define the ter...

Quality Management Principle 1. Define the term Quality. 2. What is the objective of Reliability? Discuss various issues involved in ensuring Reliability. 3. What are the

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