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

Emulkey

Community Contributor

Quizzes Created: 2 | Total Attempts: 160

Questions: 5 | Attempts: 98 | Updated: Dec 11, 2023

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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

Complex Formulas In Excel

5+2*3

4+4/4+4

(4+4)/(4+4)

(4+4)/4+4

5+4*2/4*3-6

5+42/43-6