Mathematical Functions (Sum, Sub, Mul, Div, Min, Max)
Questions and Answers
- 1.
What is the correct formula of sum?
- A.
=sum(F9;F1)
- B.
=sum(F9:F1)
- C.
-sum(f9,F1)
Correct Answer
B. =sum(F9:F1)Explanation
The correct formula for summing a range of cells in Excel is "=sum(F9:F1)". This formula uses the "sum" function, which adds up the values in the specified range of cells (from F9 to F1 in this case). The ":" between F9 and F1 indicates a range of cells to be included in the sum. The other options provided, "=sum(F9;F1)" and "-sum(f9,F1)", do not follow the correct syntax for the sum function in Excel.Rate this question:
-
- 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
Correct Answer
A. Add up cell values based on a conditionExplanation
The SUMIFS function in Excel allows you to add up cell values based on certain conditions. It is used when you want to sum values in a range that meet multiple criteria. By specifying the range to sum, as well as the criteria range and criteria, you can calculate the sum of values that meet the specified conditions. This function is useful for performing calculations on large data sets and extracting specific information based on given criteria.Rate this question:
-
- 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)
Correct Answer
A. =Round(A5,-3)Explanation
The function =Round(A5,-3) will display the number in thousands. The -3 as the second argument in the Round function indicates that the number should be rounded to the nearest thousand. Therefore, the function will round 645123.875 to 645000, displaying the number in thousands.Rate this question:
-
- 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
Correct Answer
A. Adds up cell values based on a conditionExplanation
The SUMIF function is used to add up cell values based on a condition. It allows you to specify a range of cells to evaluate, and a condition to determine which cells should be included in the sum. Only the values that meet the specified condition will be added together. This function is commonly used in data analysis and reporting to calculate totals based on specific criteria.Rate this question:
-
- 5.
In Excel, what is the correct way to multiply the numbers?
- A.
=15*3
- B.
15*3
- C.
None of Above
Correct Answer
A. =15*3Explanation
The correct way to multiply numbers in Excel is by using the formula "=15*3". This formula instructs Excel to multiply the value 15 by the value 3 and display the result. This is the standard syntax for performing multiplication calculations in Excel.Rate this question:
-
- 6.
A Text can be sum with the sum funciton.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The given statement is incorrect. The correct answer is False. The sum function in Python is used to add up the elements in an iterable (such as a list or tuple), not to concatenate strings. To concatenate strings, the "+" operator or the string concatenation method should be used instead.Rate this question:
-
- 7.
Which is the correct way to take out the percentage?
- A.
=450*550/100
- B.
=550/450*100
- C.
=450/550*100
Correct Answer
C. =450/550*100Explanation
To calculate the percentage, you need to divide the part (450) by the whole (550) and then multiply the result by 100. This formula gives you the proportion of the part in relation to the whole, expressed as a percentage. Therefore, the correct way to take out the percentage is =450/550*100.Rate this question:
-
- 8.
(range , criteria, [sum_range]) In which formula these aurguments work?
- A.
Sum
- B.
Sumif
- C.
Countif
Correct Answer
B. SumifExplanation
The arguments "range", "criteria", and "[sum_range]" work in the formula "Sumif". In this formula, the "range" refers to the range of cells that will be evaluated against the given criteria. The "criteria" specifies the condition that needs to be met for the cells to be included in the sum. And the optional "[sum_range]" indicates the range of cells that will be summed if they meet the criteria.Rate this question:
-
- 9.
what will be the answer of =2+3*5
- A.
30
- B.
25
- C.
17
Correct Answer
C. 17Explanation
The correct answer is 17 because according to the order of operations in mathematics, multiplication should be done before addition. So, first, we multiply 3 and 5 which gives us 15, and then we add 2 to it, resulting in 17.Rate this question:
-
- 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
Correct Answer
C. Not Equal toExplanation
The given correct answer for this question is "Not Equal to". The "!=" operator is used to compare two values and check if they are not equal to each other. This operator is commonly used in programming languages to perform inequality comparisons.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
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 07, 2011Quiz Created by
Nsurani
Back to top