Complex Formulas In Excel

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Emulkey
E
Emulkey
Community Contributor
Quizzes Created: 2 | Total Attempts: 172
| Attempts: 99
SettingsSettings
Please wait...
  • 1/5 Questions

    (4+4)/(4+4)

    • 6
    • 9
    • 1
Please wait...
About This Quiz


This will be dealing wiith the order of operations Please Excuse My Dear Aunt Sally (P. E. M. D. A. S).

Complex Formulas In Excel - Quiz

Quiz Preview

  • 2. 

    5+2*3

    • 21

    • 11

    Correct Answer
    A. 11
    Explanation
    Multiplation comes first. So 2*3=6 and 6+5=11

    Rate this question:

  • 3. 

    4+4/4+4

    • 6

    • 9

    • 1

    Correct Answer
    A. 9
    Explanation
    Division comes first so 4/4=1 then 4+1=5 and 5+4=9

    Rate this question:

  • 4. 

    (4+4)/4+4

    • 6

    • 9

    • 1

    Correct Answer
    A. 6
    Explanation
    Parenthesis first so 4+4=8 divide by 4 to get 2. Add 4 and you get 6

    Rate this question:

  • 5. 

    5+4*2/4*3-6

    • 3

    • 4

    • 5

    • 6

    • 7

    Correct Answer
    A. 5
    Explanation
    Multiplication and division first so 4*2=8. divide by 4 and get 2. Multiply by 3 and get six so equation reads 5+6-6=5

    Rate this question:

Quiz Review Timeline (Updated): Dec 11, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 11, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 28, 2009
    Quiz Created by
    Emulkey
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.