Including the titles, column headings,, Computer Engineering

Assignment Help:

Your company is planning a party for employees, and you have been asked to set up a spreadsheet to track the attendees and to measure the associated cost. Every employee is permitted to bring one guest to the party. There are 50 employees in your company. The spreadsheet requires to be set up when the invitations are distributed so that you can begin recording the reservations as soon as they come in.
 
The costs of the party are the similar for each attendee. When the employees respond, you want to add their names to the list. If they are not coming, you want this recorded. If they are coming alone, the cost is $45. If they are bringing a guest, the cost is $45 X 2. Respond fully to the following questions regarding this task:
 
A - Describe how you will structure your worksheet, including the titles, column headings, the formulas to measure the cost for every employee (which may include cost for a guest), and to measure the total cost of the party.

B - The facility where the party is to be held will give the company a reduction in price if more than 75 people attend. The price per person will then be $40. Describe how you will set up your worksheet to reflect a change when the total number of attendees hits 75. 
C - You want the employees who are going to attend to show up on the list with a yellow background. Explain the method you would use to have this automatically occur when you indicate the employee's response.

D -  You know your management team will want to periodically check to see who is attending. They are not concerned with those who have responded but are not attending. Explain how you might generate this list as requested using your knowledge of Excel.


Related Discussions:- Including the titles, column headings,

Explain 100 line exchange with selector finder, Explain 100 line exchange w...

Explain 100 line exchange with selector finder. Design: In place of 100 two-motion selectors as in the case of Design 3, suppose we consider only 24 two-motion selectors. Whe

Describe collective communications, Q. Collective Communications? A num...

Q. Collective Communications? A number of message-passing systems allow communication involving more than two processors. Such type of communication can be known as collective

No class can derive, Make a console application. Add class 'Account' having...

Make a console application. Add class 'Account' having variables as num (integer) name (String), bal (double), ac_code (byte). Describe four different constructors to initialize th

Microprocesseor, In8085 are of the following statements is not true.A) Co-p...

In8085 are of the following statements is not true.A) Co-processor is interfaced in max mode. B) Co-processor is interfaced in MIN mode C )Co-processor is interfaced in max/min mod

Determine the computer arithmetic operations, Computer Arithmetic Data ...

Computer Arithmetic Data is manipulated with the help of arithmetic instructions in digital computers. Data is manipulated to  produce the results  necessary  to  provide solut

Minimax algorithm - artificial intelligence, Minimax algorithm - artificial...

Minimax algorithm - artificial intelligence: The minimax algorithm is so called because it assumes that you and your opponent are going to act rationally, so that if you will

List out the evaluation order for the expression tree, Draw an expression t...

Draw an expression tree for the string. f + (x+y) *((a+b)/(c-d)). Indicate the register requirement for each node and list out the evaluation order for the expression tree. For

Explain common sub expression elimination, Explain briefly Common sub ex...

Explain briefly Common sub expression elimination of the commonly used code optimization techniques. Common sub expression elimination: In given expression as "(a+b)-(

What are the uses of ramps, What are the uses of Ramps? Ramps: I...

What are the uses of Ramps? Ramps: It is a network planning method which makes the most efficient use of manpower, cash resources and materials among various projects go

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