Mathematical Functions (Sum, Sub, Mul, Div, Min, Max)

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 15,757
| Attempts: 326
SettingsSettings
Please wait...
  • 1/10 Questions

    What does SUMIFS function do?

    • Add up cell values based on a condition
    • Add all the numbers in a range of cells
    • Returns a subtotal in a list or database
    • All of Above
Please wait...
About This Quiz

This quiz assesses knowledge on basic mathematical functions in Excel, including SUM, SUMIF, SUMIFS, multiplication, and rounding. It tests the ability to apply these functions to solve practical problems, enhancing spreadsheet management skills.

Excel Functions Quizzes & Trivia

Quiz Preview

  • 2. 

    In Excel, what is the correct way to multiply the numbers?

    • =15*3

    • 15*3

    • None of Above

    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.

    Rate this question:

  • 3. 

    What is the correct formula of sum?

    • =sum(F9;F1)

    • =sum(F9:F1)

    • -sum(f9,F1)

    Correct Answer
    A. =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:

  • 4. 

    Cell A5 shows a figure of 645123.875. Which of the following functions will display to the number is thousand?

    • =Round(A5,-3)

    • =Round(A5,-2)

    • =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:

  • 5. 

    What does SUMIF function do?

    • Adds up cell values based on a condition

    • Adds all the numbers in a range of cells

    • Returns a subtotal in a list or database

    • All of Above

    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.

    Rate this question:

  • 6. 

    (range , criteria, [sum_range]) In which formula  these aurguments work?

    • Sum

    • Sumif

    • Countif

    Correct Answer
    A. 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.

    Rate this question:

  • 7. 

    A Text can be sum with the sum funciton.

    • True

    • False

    Correct Answer
    A. 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.

    Rate this question:

  • 8. 

    Which is the correct way to take out the percentage?

    • =450*550/100

    • =550/450*100

    • =450/550*100

    Correct Answer
    A. =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.

    Rate this question:

  • 9. 

    what will be the answer of =2+3*5

    • 30

    • 25

    • 17

    Correct Answer
    A. 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.

    Rate this question:

  • 10. 

    "<>" Why we use this operator

    • This is not an operator

    • When we want to compare the Greater than and Less Then value together

    • Not Equal to

    Correct Answer
    A. 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.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 07, 2011
    Quiz Created by
    Nsurani
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.