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 | Questions: 5
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

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

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

Explanation

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

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

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
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