Complex Formulas In Excel

  • 4th Grade,
  • 5th Grade,
  • 6th Grade
  • ISO/IEC 29500
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 | Questions: 5 | Updated: Oct 11, 2025
Quiz Flashcard
Please wait...
Question 1 / 5
0 %
0/100
Score 0/100
1. (4+4)/(4+4)

Explanation

Parenthesis first so 4+4=8 and 4+4=8. 8/8=1

Submit
Please wait...
About This Quiz
Complex Formulas In Excel - Quiz

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

2. 5+2*3

Explanation

Multiplation comes first. So 2*3=6 and 6+5=11

Submit
3. (4+4)/4+4

Explanation

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

Submit
4. 4+4/4+4

Explanation

Division comes first so 4/4=1 then 4+1=5 and 5+4=9

Submit
5. 5+4*2/4*3-6

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

Submit
×
Saved
Thank you for your feedback!
View My Results
Cancel
  • All
    All (5)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
(4+4)/(4+4)
5+2*3
(4+4)/4+4
4+4/4+4
5+4*2/4*3-6
Alert!

Advertisement