LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
362 views
in Computer by (117k points)
closed by

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

= FACT(0) + FACT(3) + FACT(5)


1. 126
2. 9
3. 127
4. 8

1 Answer

0 votes
by (59.8k points)
selected by
 
Best answer
Correct Answer - Option 3 : 127

The correct answer is 127.

  • The Excel FACT function returns the factorial of a given number. For example, = FACT(3) returns 6, equivalent to 3 x 2 x 1.
  • FACT(0) + FACT(3) + FACT(5) = 1 + 3 x 2 x 1 + 5 x 4 x 3 x 2 x 1
  • FACT(0) + FACT(3) + FACT(5) = 1 + 6 + 120
  • FACT(0) + FACT(3) + FACT(5) = 127

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...