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 bitwise-and operator, Bitwise-AND Operator: & AND-expression : ...

Bitwise-AND Operator: & AND-expression : relational-expression AND-expression & equality-expression The bitwise-AND operator (&) compares each bit of its first operand t

Explain briefly the function of layers, Explain briefly the function of dif...

Explain briefly the function of different layers which are covered under end to end layer connectivity. Different layer are as follows: 1. Transport Layer:  This is res

Constraint satisfaction problems, Constraint Satisfaction Problems: Fu...

Constraint Satisfaction Problems: Furthermore I was perhaps most proud of AI on a Sunday. However this particular Sunday, a friend of mine found an article in the Observer reg

Give difference between assembler and compiler, Give difference between ass...

Give difference between assembler and compiler. Assembler: It is the translator for an assembly language of computer. An assembly language is a low-level programming language

Define about abstraction- object oriented systems, Define about Abstractio...

Define about Abstraction-  object oriented systems Abstraction is one of the most important ideas of object oriented systems Abstraction focus on the necessary, inherent aspec

Register organisation, The number and nature of registers is a major factor...

The number and nature of registers is a major factor which distinguishes among computers. For illustration, Intel Pentium has about 32 registers. A number of these registers are sp

Determine about the information centres, Determine about the Information ce...

Determine about the Information centres Airports, supermarkets and any application where information needs to be relayed to customers, gain advantage from having automatic inf

What is generalization, What is generalization? Generalization is a rel...

What is generalization? Generalization is a relationship among a class (super class) and one or more variations of the class (sub classes).It arrange classes by similarities an

How and what data is gathered- simulation, How and what data is gathered- S...

How and what data is gathered- Simulation To make this as realistic as possible, data is required to be gathered over a long period of time. This can be done by sensors near/i

Draw the logic circuit of a 3 line to 8 line decoder, What is a decoder? Dr...

What is a decoder? Draw the logic circuit of a 3 line to 8 line decoder and explain its working. Ans. Decoder: it is a combinational logic circuit which converts Binary words

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