Complex Formulas In Excel

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Emulkey
E
Emulkey
Community Contributor
Quizzes Created: 2 | Total Attempts: 158
Questions: 5 | Attempts: 97

Settings

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

Questions and Answers
• 1.

5+2*3

• A.

21

• B.

11

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

Rate this question:

• 2.

4+4/4+4

• A.

6

• B.

9

• C.

1

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

Rate this question:

• 3.

(4+4)/(4+4)

• A.

6

• B.

9

• C.

1

Correct Answer
C. 1
Explanation
Parenthesis first so 4+4=8 and 4+4=8. 8/8=1

Rate this question:

• 4.

(4+4)/4+4

• A.

6

• B.

9

• C.

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

• A.

3

• B.

4

• C.

5

• D.

6

• E.

7

Correct Answer
C. 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 +

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

Related Topics

Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.