1.
What is the correct formula of sum?
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.
2.
What does SUMIFS function do?
Correct Answer
A. Add up cell values based on a condition
Explanation
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.
3.
Cell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?
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.
4.
What does SUMIF function do?
Correct Answer
A. Adds up cell values based on a condition
Explanation
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.
5.
In Excel, what is the correct way to multiply the numbers?
Correct Answer
A. =15*3
Explanation
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.
6.
A Text can be sum with the sum funciton.
Correct Answer
B. False
Explanation
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.
7.
Which is the correct way to take out the percentage?
Correct Answer
C. =450/550*100
Explanation
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.
8.
(range , criteria, [sum_range])
In which formula these aurguments work?
Correct Answer
B. Sumif
Explanation
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.
9.
what will be the answer of
=2+3*5
Correct Answer
C. 17
Explanation
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.
10.
"<>"
Why we use this operator
Correct Answer
C. Not Equal to
Explanation
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.