Complex Formulas In Excel
(48).webp "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).
Questions and Answers
- 1.
5+2*3
- A.
21
- B.
11
Correct Answer
B. 11Explanation
Multiplation comes first. So 2*3=6 and 6+5=11Rate this question:
-
- 2.
4+4/4+4
- A.
6
- B.
9
- C.
1
Correct Answer
B. 9Explanation
Division comes first so 4/4=1 then 4+1=5 and 5+4=9Rate this question:
-
- 3.
(4+4)/(4+4)
- A.
6
- B.
9
- C.
1
Correct Answer
C. 1Explanation
Parenthesis first so 4+4=8 and 4+4=8. 8/8=1Rate this question:
-
- 4.
(4+4)/4+4
- A.
6
- B.
9
- C.
1
Correct Answer
A. 6Explanation
Parenthesis first so 4+4=8 divide by 4 to get 2. Add 4 and you get 6Rate this question:
-
- 5.
5+4*2/4*3-6
- A.
3
- B.
4
- C.
5
- D.
6
- E.
7
Correct Answer
C. 5Explanation
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=5Rate 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, 2023Quiz Edited by
ProProfs Editorial Team -
Dec 28, 2009Quiz Created by
Emulkey
Back to top