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

Differentiate between the internet and the world wide web, QUESTION The...

QUESTION The advent of the internet in the 1960s and the World Wide Web in the 1990s has revolutionised global communications. (a) Differentiate between the Internet as well

Electronic surveillance of employees, 1. Explain where an employee can reas...

1. Explain where an employee can reasonably expect to have privacy in the workplace. Employees can reasonably expect to have privacy in the workplace as it pertains to issues su

How would you define such type of hazard, A large, 100+ seat inbound call c...

A large, 100+ seat inbound call centre has been getting feedback from the Australian Services Union that their members are dissatisfied with working conditions. The most recent ma

E-bussness, Assuming that you are running the e-business department of an o...

Assuming that you are running the e-business department of an organization, reference to the elements of the Micro and Macro environments of e-business, how are you going to deal w

The major characteristics of physical development, QUESTION Based on wh...

QUESTION Based on what was discussed during your lectures on how children learn, answer the following questions. (a) Explain 4 strategies that you would use to enhance the l

Problem based on olympic games 2012, Olympic Games 2012 a) Revenue ex...

Olympic Games 2012 a) Revenue expenditure is spending on the daily running of a business, such as materials and wages used in the preparation for the 2012 Olympic Games. Ca

Cost context induction, Cost Context Induction : Good maintenance manage...

Cost Context Induction : Good maintenance management is important for the company cost control. As companies go in for automation to become more competitive they increasing

Enumerate five key functions of management, QUESTION (a) Enumerate five...

QUESTION (a) Enumerate five obstacles to effective time management (b) Enumerate five key functions of management (c) Explain briefly Maslow's Hierarchy of Needs (d) W

Compare e-commerce to e-business, Question: a) Decribe e-commerce from ...

Question: a) Decribe e-commerce from a communication and a commercial perspectives. b) Compare e-commerce to e-business. c) Distinguish between Click-and-mortar and Brick

Explain the concept of market efficiency and its importance, QUESTION (...

QUESTION (a) Explain the concept of market efficiency and its importance (b) (i) Discuss the evidence in relation to weak form market efficiency with reference to the empiri

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