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

Fundamental budgets essential for manufacturing budget, What fundamental bu...

What fundamental budgets are essential for manufacturing budget? Manufacturing budget requires the given fundamental budgets or estimates to meet the plans as follows: 1. Pr

Describe the basic control process, Problem 1: (i) Describe the basic ...

Problem 1: (i) Describe the basic control process. (ii) Show whether control is always possible and necessary in an organization. Problem 2: (i) Using appropriate

Explain the difference between countries with high context, QUESTION (...

QUESTION (a) Explain the difference between countries with high context and low context cultures. Also describe what managers operating in international environments need to p

Performance appraisal and career progression of individual, Define the perf...

Define the performance appraisal and career progression of individual. Performance Appraisal and Individual’s Career Progression: Performance appraisal assists in unearth

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

International business from the organizations perspective, Question: (a...

Question: (a) Developing appropriate selection criteria has become a critical IHRM issue. Factors involved in expatriate selection can be both in terms of the individual and

Describe breaking geographic business barriers, Q. Describe Breaking Geogra...

Q. Describe Breaking Geographic Business Barriers? Several companies today operate from several locations and have customers or suppliers at distant locations and do business i

Economic feasibility analysis, Q. Economic feasibility analysis? Feasib...

Q. Economic feasibility analysis? Feasibility Analysis: - The feasibility analysis carefully examine economic, operational, technical, scheduling, legal and strategic factors o

Describe the concept of the value chain, Question 1: a) Explain how a b...

Question 1: a) Explain how a business could carry out market research. b) Describe the difference between selling and marketing. c) Describe the 4 main international mark

Critically discuss how to make effective group decisions, QUESTION 1 Cr...

QUESTION 1 Critically discuss the different common decision making traps. Support your answers with relevant examples QUESTION 2 Critically discuss how to make effectiv

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