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

  Explain how pristine are foragers

Mel konner and Marjorie shostak Mother infant bonds submissive to babies Male and female roles in hunting Explain how pristine are foragers. Are modern humans still evolving.

  Interpret the stated numbers

A 6% six-year government bond yields 12% and 10% six-year bond yields 8%. Calculate the 6 year spot rate. Part of the question is understanding how to interpret the stated numbers.

  Strategies to implement with clients-employees-learners

Would you search for up-to-date scientific evidence that supports strategies to implement with clients, employees, or learners?

  Process of language acquisition

An explanation of how nature and nurture interact in the process of language acquisition.

  Apa position on repressed childhood memories

Write down a summary of the article regarding recovering memories.

  Determine the design hourly volume for the road

Determine the design hourly volume for the road below, recommend the K factor first. a. For a two lane highway in a national park with AADT of 10,000 vpd.

  Social change perspectives

Write down the main cause of social change, according to the Function list perspective and according to Conflict theoretical perspective?

  Marx and c wright mills conflict theory

The current economic crisis in the United States is affecting a majority of the population. Explain how the many factors such as layoffs, financial market failures and family stress are affecting you and others.

  Ethical decision-making in public sector

Discuss ethical decision-making in the public sector. It includes Cooper's five steps for ethical decision-making. It offers a very brief overview of ethical decision-making by the public administrator.

  Preventing the plagiarism

How can a movie studio prevent plagiarism? (Plagiarism among studios within and/or outside a country).

  Compare and distinction logistics management

Discuss the sociological factor that relate to the belief that a couple will stay together in a long term relationship over many decades since they want to maintain a consistent need for each other.

  Termination of relationship

What is a divorce process and what can be done to help couples from avoiding extreme steps such as the termination of a relationship?

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