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 the difference between fixed and standard effect, Question: (a)...

Question: (a) There are several camera angles that can be used to make a sequence more interesting for a video production project. Explain clearly, using diagrams where appro

What do you understand by a file system, Problem (a) What do you mean...

Problem (a) What do you meant by a file system? (b) Mention the five categories of data for a basic file system reference model. What is the use of such a reference model

Major problems associated in writing with cache memories, Q. Major problems...

Q. Major problems associated in writing with cache memories? The data in main and cache memory can be written by processors or I/O devices. The major problems associated in wri

Device drivers in assembly, Device drivers are special programs installed b...

Device drivers are special programs installed by config.sys file to control installable devices.  So personal computers can be expanded at some future time by installation of new d

Propositional logic, Propositional Logic: This is a fairly restrictive...

Propositional Logic: This is a fairly restrictive logic, that allows us to be write sentences about ¬propositions - statements about the world - that can either be true or

..binary tree, draw a binary tree from its inorder and preorder traversal s...

draw a binary tree from its inorder and preorder traversal sequences given as follows: inorder: d b g e h a c n f preorder: a b d e g h c f n

Java, A string S is said to be "Super ASCII", if it contains the character ...

A string S is said to be "Super ASCII", if it contains the character frequency equal to their ascii values. String will contain only lower case alphabets (''a''-''z'') and the asci

Where telephone traffic is measured, Telephone Traffic is measured in ...

Telephone Traffic is measured in (A)  Seconds.  (B)  Hours. (C)  Erlang       (D)  Pulses per minute. Ans: Telephone Traffic is measured in Erlang.

Important part of process - canonical genetic algorithm, Important part of ...

Important part of Process - canonical genetic algorithm: In such a scenario evolution or random mutations are often highly deleterious or can say harmful to the organism it me

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