Question

What will be the result of the following MS Excel formula?

= FACT(5-4)

1. 120
2. 1
3. 96
4. 24

Answer 1

Correct Answer - Option 2 : 1

The correct answer is 1.

• = FACT(5-4) = FACT(1) = 1

• The Excel Fact function returns the factorial of a given number.
• The FACT function is a built-in function in Excel that is categorized as a Math/Trig Function.
• It can be used as a worksheet function in Excel.
• As a worksheet function, the FACT function can be entered as part of a formula in a cell of a worksheet.
• The factorial of a number is equal to 1*2*3*....*number.
• The syntax of the function is FACT(number).
• FACT(3) returns the value 6 which is equivalent to 3*2*1.
• The nonnegative number for which you want the factorial. If the number is not an integer, it is truncated.
• The number cannot be negative or FACT will return the #NUM error.
• = FACT(-4) → factorial of a negative number returns an error value #NUM!.
• = FACT(1.9) → factorial of the integer 1.9 is equal to 1.

​

• Microsoft Excel
  • Microsoft Excel is part of the Microsoft Office suite of programs and developed by Microsoft in 1987.
  • Microsoft Excel is a spreadsheet program used to record and analyze numerical and statistical data.
  • Microsoft Excel provides multiple features to perform various operations like calculations, pivot tables, graph tools, macro programming, etc.
  • An Excel spreadsheet can be understood as a collection of columns and rows that form a table.
  • Alphabetical letters are usually assigned to columns, and numbers are usually assigned to rows.
  • The point where a column and a row meet is called a cell.
  • The address of a cell is given by the letter representing the column and the number representing a row.

• The founder of Microsoft - Bill Gates and Paul Allen.
• The CEO of Microsoft - Satya Nadella.