Question
Download Solution PDFWhich of the following is Math and trigonometric functions available in MS-Excel 365?
Answer (Detailed Solution Below)
Detailed Solution
Download Solution PDFThe Math and Trigonometric functions available in MS-Excel 365 include:
- ABS function: Returns the absolute value of a number.
- Trigonometric functions: These include SIN, COS, TAN, ASIN, ACOS, and ATAN, which are used to calculate the sine, cosine, tangent, arcsine, arccosine, and arctangent of an angle.
- LOG function: Returns the natural logarithm of a number.
- EXP function: Returns e raised to the power of a given number.
- SQRT function: Returns the square root of a number.
- RAND function: Returns a random number between 0 and 1.
- INT function: Rounds a number down to the nearest integer.
- ROUND function: Rounds a number to a specified number of decimal places.
- CEILING and FLOOR functions: Round numbers up or down to the nearest integer or multiple of a given value.
- POWER function: Raises a number to a specified power.
- MOD function: Returns the remainder when one number is divided by another.
- SUM, AVERAGE, MAX, and MIN functions: These are basic statistical functions used to calculate the sum, average, maximum, and minimum of a range of numbers.
Note: The text function and logical function are not considered Math and Trigonometric functions, but rather fall under the categories of Text and Logical functions, respectively. Financial functions are also not classified as Math and Trigonometric functions, but rather as Financial functions.
Hence, the correct answer is option 2.
Last updated on Jun 30, 2025
-> The Institute of Banking Personnel Selection (IBPS) has officially released the Provisional Allotment under the Reserve List on 30th June 2025.
-> According to the official notice, the Prelims Examination is scheduled to be conducted on 6th, 7th, 13th and 14th December 2025.
-> The Mains Examination is scheduled for 1st February 2026.
-> IBPS RRB Clerk 2025 Notification is expected to be released soon.
-> Candidates with a Graduation degree in any discipline are eligible for the recruitment process.
-> The selection process includes Prelims and Mains examinations.
-> Prepare for the Exam with IBPS RRB Clerk Previous Year Papers. Check IBPS RRB Clerk Exam Analysis.
-> Attempt Free Banking Current Affairs Mock Test here