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,

What is artificial intelligence fuzzy logic, Fuzzy logic is a form of vario...

Fuzzy logic is a form of various-valued logic; it deals with reasoning that is approximate rather than fixed & exact. In contrast with traditional logic theory, where binary sets h

Difference between external and global variables, Global variables are acce...

Global variables are accessible only to the batch program while external variables can be referenced from any batch program residing in the similar system library.

What are the aspects of security policy, What are the aspects of security p...

What are the aspects of security policy The security policy should cover aspects such as network service access, physical access, limits of acceptable behaviour, company's pro

Determine condition how the output changed of JK flipflop, The output of a ...

The output of a JK flipflop with asynchronous preset and clear inputs is '1'. The output can be changed to '0' with which conditions ? Ans. Through applying J = 1, K = 1 and u

Important steps of the boot process, Question: Computer forensic examin...

Question: Computer forensic examiners should be concerned with at least two important settings stored in RTC/NVRAM, which is accessed by the BIOS software most often called Set

Explain about the voice recognition device, Explain about the Voice recogni...

Explain about the Voice recognition device Blind and partially-sighted people can communicate with a computer using microphone and software (keyboard and touch screens can't be

How can i execute a php script using command line, Just run the PHP CLI (Co...

Just run the PHP CLI (Command Line Interface) program and give the PHP script file name as the command line argument. For instance, "php myScript.php", assuming "PHP" is the comman

Io devices and i/o subsystem and direct memory access, Why IO devices canno...

Why IO devices cannot be connected directly to the system bus? Ans: The IO devices can't be directly connected to the system bus because the following reason A) The data tra

What is a pointer, What is a pointer? The register or memory location t...

What is a pointer? The register or memory location that having the address of an operand is known as a pointer.

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