computers

Using the operator precedence that excel 2007 follows,which calculation wuld be perfomed first from the following equation?119+7*3/(8-6)-4/2
a)119+7
b)7*3
c)8-6
d)4/2
is a) correct answer thank you

  1. 👍 0
  2. 👎 0
  3. 👁 170
  1. A simplified order of precedence in Excel is:
    ()
    * and /
    + and -

    * and / have the same precedence, so the formula will be evaluated from left to right if one follows the other.

    To check the order, you would look for parentheses, the enclosed content of which will be executed first.

    Then you would look for * and /.
    They would be executed next, from left to right.

    Then you would look for + and -, again they would be from left to right.

    If you follow the above rules, you will have no problem finding the right answer, which is not (a) 119+7 because there are other operators that have a higher precedence than "+".

    Post your answer for a check if you are not sure.

    Also, see the following article from Microsoft:
    http://office.microsoft.com/en-us/excel-help/calculation-operators-and-precedence-HP010078886.aspx

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. english

    . Identify the sentence that is correctly punctuated. a. Word Processing and Excel: those are the technology job requirements. b. Word Processing, PowerPoint, and Excel, those are the technology job requirements. c. Word

    asked by steve on October 12, 2017
  2. Economics

    Suppose that the residents of Vegopia spend all of their income on cauliflower, broccoli, and carrots. In 2006 they buy 100 heads of cauliflower for $200, 50 bunches of broccoli for $75, and 500 carrots for $50. In 2007, they buy

    asked by Sarah on April 2, 2007
  3. Math

    Find the discount (ordinary interest) and proceeds on a promissory note for $2,000 made by Barbara Jones on February 10, 2007, and payable to First State Bank on August 10, 2007, with a discount rate of 9%.

    asked by Peter on July 4, 2014
  4. history

    what enent set precedence that alleviated the problem of having no law of succession in the empire

    asked by Barbara on January 8, 2012
  5. Computer Applications

    An Excel workbook can contain more than one workshet. Give two examples of a spreadsheet application where it would be necessary to have more than one worksheet and explain your answer. Please help. I am lost when it comes to

    asked by Angel on November 30, 2008
  1. Excel

    You are trying to decide between flat or beveled columns for a chart you are creating within Excel 2007. What tool do you access to select each of these alternatives to see how they look? A. Styles gallery b. Chart gallery The

    asked by Billy on January 5, 2012
  2. accounting

    In 2007, Paul who is single has a comfortable salary from his job as well as income from his investment portfolio. However, he is habitually late in filing his federal income tax return. He did not file his 2007 income tax return

    asked by Mikki on February 8, 2009
  3. Physics

    PLEASE HELP, I'm trying to study for a quiz >.< and I don't understand this one question! A fellow student reports his measurements of time for a speed calculation in minutes. How could he express that calculation using SI base

    asked by Abby on October 17, 2012
  4. algebra

    The United States Department of Agriculture reported in Vegetables and Melons Outlook in 2007 that the average America consumes about 7.4 x 10^3 potato chips in a year. Since Idaho had about 1.5 x 10^6 people in 2007, how many

    asked by Isabella on October 8, 2016
  5. operation management

    A firm is planning to set up an assembly line to assemble 40 units per hour. Assume that 57 minutes per hour are productive. The time to perform each task and the tasks preceding each task are as follows: Task Preceding Task Time

    asked by monica on August 1, 2010
  6. Information Science

    ABC Company has 50,000 employees at it headquarters. The company wants to increase employee productivity by setting up internal software application training program for it employees. The training program will teach employees how

    asked by Chris on June 1, 2010

You can view more similar questions or ask a new question.