Home
Class 12
GEOGRAPHY
How do we solve arithmetic expressions i...

How do we solve arithmetic expressions in MS Excel?

Text Solution

Verified by Experts

We solve arithmetic expression in the following sequence. First of all, brackets are solved. Thereafter division and then multiplication is doen. There after addition and subtraction is done. In short the rule of BODMAS is followed. It cann be understood by an example.
`=20xx2//4+(1-8+2)^(2)`
`=20xx2//4+(4)^(2)`
`=20xx2//4+16`
`=40/4+16`
`=10+16=26`
In MS Excel, it will be expressed as `Fx="SUM" (A1xxB1/C1+D1)xxE1`
Promotional Banner

Topper's Solved these Questions

  • USE OF COMPUTER IN DATA PROCESSING AND MAPPING

    FULL MARKS|Exercise ADDITIONAL QUESTIONS SOLVED (LONG ANSWER QUESTIONS)|1 Videos
  • USE OF COMPUTER IN DATA PROCESSING AND MAPPING

    FULL MARKS|Exercise ADDITIONAL QUESTIONS SOLVED (VIVA VOCE QUESTIONS)|6 Videos
  • USE OF COMPUTER IN DATA PROCESSING AND MAPPING

    FULL MARKS|Exercise ADDITIONAL QUESTIONS SOLVED ( SHORT ANSWER QUESTIONS)|1 Videos
  • TRANSPORT AND COMMUNICATION

    FULL MARKS|Exercise WORKSHEET|9 Videos
  • WATER RESOURCES

    FULL MARKS|Exercise WORKSHEET|9 Videos

Similar Questions

Explore conceptually related problems

How do we see objects?

How do we hear sound?

How Do We Periodise

How do we compute the age of a fossils ?

How do we compute the age of a rock ?

How do we get pure N_(2) gas