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

  What open-invoicing and which types businesses use

What is open-invoicing and which types of businesses would use it? Compare it with the balance-forward method. Why wouldn't one or the other suffice for all companies?

  Principles and parameters theory

Considering language acquisition only, what is one crucial difference between the notion of transformational grammars and the newer principles and parameters theory?

  Possible future consequences to individuals

Critically discuss the possible future consequences to individuals and society as a whole if Generation Y / Millennials cannot live better than previous generations?

  Demographic transition

Most developed nations are in what phase of the demographic transition?

  The collapse of the soviet union

Choose one of these theories and explain how it relates to the collapse of the USSR, and assess and justify whether it relates to its internal or external foreign policy.

  Examine the term modelling as applied in education

Examine the term modelling as applied in education. To what extent is the rational model of policy-making (Clay and Schaffer) a normative institutional engineering approach. Give examples to illustrate your answer

  Psychology or anthropology

What is sociology? How does it differ from the other social sciences such as psychology or anthropology?

  Why is affirmative action necessary now

Why is affirmative action necessary now? No minimum word count. Need a reference in APA format

  Erikson stages influence personality development

How does movement through Erikson's stages influence personality development? Again, be specific.

  How does the chest of tutankhamen exemplify

Select an Egyptian building from the Old, Middle, and New Kingdom. Describe them and evaluate their importance to their period and to the history of ancient Egyptian architecture.

  Why marital satisfaction declines

Discuss one problem that could occur later in a marriage. Why does this happen in a marriage? Who or what might be the contributing factor to your example?

  Series of essays for high school english class

Imagine that you are teaching English in a local high school. Imagine that you are the parent or friend of a student having to write a series of essays for a high school English class.

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