Benefits of excel is ability to use formulas and functions

Assignment Help Other Subject
Reference no: EM13174797

One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets. Using the following scenarios, discuss how you would apply the Excel functions or create a formula to solve the scenario.

You wish to calculate the commission on sales. The commission is 6% on all sales that are at least 20% above cost. 
You wish to calculate the total pay for an employee who receives regular time for 40 hours, time and a half for 40-50 hours, and double time for hours over 50. 
You have a list of contracts and due dates for annual maintenance fees. You wish to determine when you have a contract due in the next 45 days and provide a note that warns you that the payment is due. 
Please feel free to add other, unique mathematical challenge questions to the discussion, and let us work together to figure out how you might calculate it.

Reference no: EM13174797

Questions Cloud

An ideal gas : An ideal gas at 1 bar and 273.15K is allowed to expand adiabatically against a constant pressure of 0.315 bar until it doubles its volume.
State the potential energy of the gasoline and oxygen : When gasoline burns, it reacts with oxygen in the air and forms hot gases consisting of carbon dioxide and water vapor. How does the potential energy of the gasoline and oxygen compare with the potential energy of the carbon dioxide and water vapo..
According to the text-communication controls motivate : According to the text, communication controls motivate, provide release, and facilitate decision-making. What happens in an organization when communication is limited? How does downward and upward communication affect the functions mentioned above?
State what is the composition of a sample of a mixed alpha : Pure alpha-D-glucose has a specific rotation=+112.2 degrees and pure beta-D-glucose has a specific rotation=+18.7 degrees. What is the composition of a sample of a mixed alpha and beta-D-glucose that has a specific rotation=+83.0 degrees?
Benefits of excel is ability to use formulas and functions : One of the benefits of Excel is the ability to use formulas and functions. Discuss the differences between formulas and functions. Pick a function in Excel and discuss how that function is used to calculate results in your worksheets.
What is the firms optimal markup : the fully allocated cost of a product is $10. If the price elasticity of demand for the product is -2, then the firms optimal markup is: 10%, 100%, 200%or 300%.
What is the mass change accompanying the formation of co : What is the mass change (in grams) accompanying the formation of CO and H2 in the water gas reaction?
State and draw the structural formula of val-ala-leu : Draw the structural formula of Val-Ala-Leu. Draw the molecule by placing atoms on the grid and connecting them with bonds. Include all hydrogen atoms
The solution ph to calculate the concentration of hydronium : Use the solution pH to calculate the concentration of hydronium ion present

Reviews

Write a Review

Other Subject Questions & Answers

  Technology for global business success

How can technology support a manager in making employees a vital element of the value chain? Critically discuss the trends in use of technology for global business success?

  Greed is good speech from wall street

In Gordon Gekko's "Greed is Good" speech from Wall Street, identify any remarks that make either of the two forms of Ethical Appeals from Aristotle's theory.

  Locke and knowledge

How does Locke differentiate between knowledge of substance and general ideas? In particular, why does he think that knowledge of nature, like Newtonian physics, is really belief, while mathematics

  Mobile device explosion

How has the proliferation of smartphones, tables, and other connected devices changed the networking landscape? Is this explosion just a matter for cellular carriers, or should those managing WiFi networks be aware of challenges as well?

  Anorexia or bulimia fundamentals

Give a comparison (similarities and differences) of either anorexia or bulimia, and one other eating disorder.

  Discussing the legal actions against breaching an agreement

If Monarch contracts with another company to provide services for both its facilities, would Quinn be successful in a legal action against Monarch for breaching their agreement as to the Cortland facility? Explain fully.

  Hume view of soul

Two people are debating on weather souls exist or not one person says they do and the other says they dont. Someone walks up who holds a Humean view and reads the last sentence of Hume's Inquiry:

  Health care laws or regulations

What are ways that health care laws or regulations influencing your health care organization or a healthcare organization with which you arewell known?

  Monumental egos

What do you think of this article called Monumental Egos? At least one critic of the Denver museum thought that the building distracted from its purpose of displaying the artwork with all the strange angles.

  Private organizations

Should the government be able to give up its responsibility for the custody of an individual and engage in contracts with private organizations to provide privatization of prisons and jails?

  Explaining the discrimation act

Mary owns a 6-person beauty salon. One day an African American customer comes in and wants a wash and set. Mary has a cold and does not wish to give it to the customer,

  Partial explanations for sustainable consumer behavior

Which three schools of academic thinking provide partial explanations for sustainable consumer behavior? Should consumers be expected to take responsibility for the social and environmental impacts of their consumption behaviors, or should that be th..

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