Mathematical Functions (Sum, Sub, Mul, Div, Min, Max)
10 Questions
| Total Attempts: 186
Questions and Answers
- 1.What is the correct formula of sum?
- A.
=sum(F9;F1)
- B.
=sum(F9:F1)
- C.
-sum(f9,F1)
- 2.What does SUMIFS function do?
- A.
Add up cell values based on a condition
- B.
Add all the numbers in a range of cells
- C.
Returns a subtotal in a list or database
- D.
All of Above
- 3.Cell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?
- A.
=Round(A5,-3)
- B.
=Round(A5,-2)
- C.
=Round(A5,-1)
- 4.What does SUMIF function do?
- A.
Adds up cell values based on a condition
- B.
Adds all the numbers in a range of cells
- C.
Returns a subtotal in a list or database
- D.
All of Above
- 5.In Excel, what is the correct way to multiply the numbers?
- A.
=15*3
- B.
15*3
- C.
None of Above
- 6.A Text can be sum with the sum funciton.
- A.
True
- B.
False
- 7.Which is the correct way to take out the percentage?
- A.
=450*550/100
- B.
=550/450*100
- C.
=450/550*100
- 8.(range , criteria, [sum_range]) In which formula these aurguments work?
- A.
Sum
- B.
Sumif
- C.
Countif
- 9.what will be the answer of =2+3*5
- A.
30
- B.
25
- C.
17
- 10."<>" Why we use this operator
- A.
This is not an operator
- B.
When we want to compare the Greater than and Less Then value together
- C.
Not Equal to
Questions: 10 | Attempts: 664 | Last updated: Mar 21, 2022
-
Sample QuestionDFA stands for?
Mathability
Questions: 5 | Attempts: 388 | Last updated: Mar 22, 2022
-
Sample QuestionVikaram chand has 2 chilldren,and at least one of them is a girl.what is the probability that both children are children?
You can check here if you are good at math.
Questions: 7 | Attempts: 124 | Last updated: Mar 19, 2022
-
Sample QuestionChange into a common fraction. 0.125
Back to top