Question
Download Solution PDFThe Excel function to remove decimal or fractional part of the number is:
This question was previously asked in
OSSC TGT Official Paper (Held On: 10 Mar, 2023 Shift 3)
Answer (Detailed Solution Below)
Option 3 : TRUNC
Free Tests
View all Free tests >
OSSC TGT: Full Test 1
5.2 K Users
100 Questions
100 Marks
90 Mins
Detailed Solution
Download Solution PDFThe correct answer is TRUNC.
Key Points
- TRUNC function is used to remove the fractional part of a number, effectively truncating it to an integer.
- It does not perform any rounding, it simply cuts off the decimal part.
- The syntax for the TRUNC function is TRUNC(number, [num_digits]).
- It can also truncate the number to a specified number of decimal places if the num_digits argument is provided.
Important Points
- The TRUNC function is different from the ROUND function, as ROUND performs rounding based on the decimal part, while TRUNC simply cuts it off.
- Using TRUNC can be useful in scenarios where only the integer part of a number is needed without any rounding.
- It is a useful function in data analysis, financial calculations, and other areas where precision control is required.
- TRUNC can be combined with other functions to achieve more complex calculations.
Additional Information
- AVG: The AVG function calculates the average (mean) of a group of numbers. It is commonly used in data analysis to determine the central tendency of a data set.
- REPLACE: The REPLACE function is used to replace part of a text string with a different text string. It is useful for text manipulation and formatting.
- ABS: The ABS function returns the absolute value of a number, which is the number without its sign. It is useful in mathematical calculations where negative values are not desired.
Last updated on Oct 28, 2023
OSSC TGT selects list Out! OSSC TGA Mains results were out on 20th October 2023. The Mains Exam was held on 15th, 21st, 22nd, and 25th September 2023. The Odisha Staff Selection Commission had earlier released the notification for the recruitment of Trained Graduate Teachers (TGT) and Language Teachers in Government schools of Odisha. A total of 6699 vacancies were available. The OSSC TGT selection process will include the Prelims, Mains, and Certificate Verification stages. This is an excellent opportunity for candidates to be part of Government Teaching Jobs in Odisha. Candidates must attempt the OSSC TGT mock tests to check their performance.