Question

Read the following statements about Excel

1. It supports many arithmetic functions like SUM, ABS, EXP, INT, MOD etc.
2. It supports many trigonometric functions.
3. It supports IRR function to calculate interest rate.
4. It supports PV function to calculate the present value of future receipts.

Which of the above are correct?

a.

All

b.

1, 2 and 3 only

c.

1, and 2 only

d.

1 only

Answer: (a).All

Interact with the Community - Share Your Thoughts

Uncertain About the Answer? Seek Clarification Here.

Understand the Explanation? Include it Here.

Q. Read the following statements about Excel 1. It supports many arithmetic functions like SUM, ABS, EXP, INT, MOD etc. 2. It supports many trigonometric functions. 3. It...

Similar Questions

Explore Relevant Multiple Choice Questions (MCQs)

Q. Which of the following is not a key word in C?

Q. If PRIN = 200.0 and BINT = 0.0525 the result of expression INCOME = PRIN * (1 + BINT) will be

Q. If INT = 50 and LOOT = 30, the result of assignment statement SAL = INT + LOOT is

Q. Consider the following in C

1. Arithmetic operations can be performed on ints.
2. Arithmetic operations can be performed on floats.
3. Arithmetic operation can be performed on chars.

Which of the above are correct?

Q. Which of the following is the software for financial accounting?

Q. 8085 needs + 10 V supply.

Q. Which of the following is not valid integer variable in FORTRAN 77?

Q. Which of the following is not an integer constant?

Q. Assertion (A): To add 8 bit words, two 1C 74181 can be cascaded.

Reason (R): In 1C 74181 a sum greater than 15 leads to high carry out.

Q. Consider the following tasks in a micro computer

1. Receiving data and instruction
2. Performing arithmetic computation
3. Performing logical computations
4. Storing data and instructions

Which of the above are performed by ALU?

Q. Consider the following DO statement in FORTRAN 77

DO 25 J = 1, 7

The number of DO loop executions in the above statement is

Q. Which of the following is not a data base function?

Q. Consider the following statements about Infix and Post fix notations in Pascal

1. In Infix notation operators appear between the operands on which they operate.
2. In Post fix notation operators appear after the operand.
3. The Infix expression A + B - C + D will appear as AB + C - D + in post fix notation.

Which of the above are correct?

Q. Which of the following statement number is not valid in Basic

Q. Consider the following in object oriented programming

1. An object is a self contained element of a computer program which represents a related group of interests.
2. Each object has a specific role in a program.
3. All objects can work with other objects in defined ways.
4. Objects are also called instances.

Which of the above are correct?

Q. Assertion (A): In C a character constant is either a single alphabet or digit or special symbol enclosed within single inverted commas.

Reason (R): In C the maximum length of a character constant can be 2 characters.

Q. Which of the following is not a valid real variable in FORTRAN 77?

Q. Let JCOKE = 3 and LPEPSI = 5. Consider the statement

IF (3 * JCOKE. EQ. LPESPSI)
JCOKE = JCOKE + 2
JCOKE = JCOKE + 5

What will be the final value of JCOKE after the above statement is executed?

Q. Diskette can be used for primary storage as well as secondary storage in a computer.

Q. Read the following statements

1. Magnetic tape is a sequential device.
2. Magnetic disc is a direct access device.
3. Magnetic tape and disc are both sequential devices.
4. Magnetic tape and disc are both direct access devices.

Which of the above statements are correct?

Recommended Subjects

Are you eager to expand your knowledge beyond Electronics and Communication Engineering? We've handpicked a range of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of various subjects. Happy exploring!