Which of the following is Math and trigonometric functions available in MS-Excel 365? 

This question was previously asked in
RRB Clerk Mains Memory Based Paper (Held On: 6 October 2024 Shift 1)
View all RRB Office Assistant Papers >
  1. Text function
  2. ABS function
  3. Logical function
  4. Financial function
  5. SUM Function

Answer (Detailed Solution Below)

Option 2 : ABS function
Free
IBPS RRB Clerk Reasoning (Mock Test)
13.4 K Users
20 Questions 20 Marks 11 Mins

Detailed Solution

Download Solution PDF

The 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.

Latest RRB Office Assistant Updates

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 

Get Free Access Now
Hot Links: teen patti noble teen patti earning app teen patti cash