Complex Formulas In Excel

  • 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: Dec 11, 2023
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.
We’ll put your name on your report, certificate, and leaderboard.
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
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!

Back to Top Back to top
Advertisement