Question Bank - Computer Awareness

Here's the question bank on all the computer awareness topics.

Which of the following is a valid MS-Excel function?

A.
ADD()
B.
MINUS()
C.
SUM()
D.
SUBTRACT()

Solution:

The correct answer is SUM()?.The SUM function in excel is an inbuilt function that is used to sum numerical values present in a range of cells.It is a mathematical formula in excel which can be used by typing =SUM( keyword in the cell where we want the sum to be calculated and then we select the range of cells that are to be added.The Excel Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents, etc.It is used to calculate values based on what is in cells, perform operations on a cell content, fetch values after an operation based on your search criteria, and much more.Mathematical Formulas in Excel are used to perform various arithmetic operations like sum, average, count, max, min, etc.Additional InformationOther functions in Excel.CommandsFunctionsIFIF function in Excel checks whether a condition is met and returns one value if true and another value if false.SUMExcel automatically enters a formula (that uses the SUM function) to sum the numbers.COUNTCOUNT Function to get the number of entries in a number field that is in a range or array of numbers.AVERAGETo perform the average formula in Excel, enter the values, cells, or range of cells of which you're calculating the average in the format, =AVERAGE (number1, number2, etc.)ANDIt is used to check more than one condition at the same time. AND function returns either TRUE or FALSE.

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.