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,

Convert the binary number to gray code, Convert the binary number 10110 to ...

Convert the binary number 10110 to Gray code ? Ans. For changing binary number 10110 in its equivalent Gray code the rules are as, the left most bit that is MSB in Gray code is 1

Conversion of decimal number to binary number, Conversion of Decimal Number...

Conversion of Decimal Number to Binary Number: For converting a decimal number to binary integer part and fractional part are handled separately. Let's describe it with help of

Explain working of digital versatile disk, Q. Explain working of Digital Ve...

Q. Explain working of Digital Versatile Disk? With the capacious digital versatile disk (DVD) electronics industry has ultimately found an acceptable replacement for videotape

What is the size of the variant data type, The Variant data type has a nume...

The Variant data type has a numeric storage size of 16 bytes and can have data up to the range of a Decimal, or a character storage size of 22 bytes (plus string length),and can ke

Poor technology or system requirements definition, Poor Technology or Syste...

Poor Technology or System Requirements Definition - Information System Previously we looked at product design and specifically the importance of requirements capture as part o

Fundamental functional units of a computer, Fundamental functional units of...

Fundamental functional units of a computer: QUE. What are the fundamental functional units of a computer? Ans: A computer consists of 5 functionally independent major parts

Information system and information technology, (a) Explain the following te...

(a) Explain the following terms: Information System and Information Technology. (b) Describe the main components of a computer. Illustrate your answer by a block diagram. (c)

What is swimlane, What is swimlane? In business model, it is often help...

What is swimlane? In business model, it is often helpful to know which human organization is responsible for activity. Show the partition of activities into columns and lines.

Convert a JK flipflop to T type flipflop, With the help of a suitable diagr...

With the help of a suitable diagram, explain how do you convert a JK flipflop to T type flipflop. Ans. As here flip flop is JK flip flop and it is required to convert JK in T.

Stata about the magnetic stripes, Stata about the Magnetic stripes  Th...

Stata about the Magnetic stripes  These comprise information/data stored on magnetic material often on the back of a credit/debit card; the information is automatically read b

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