What is the difference between a function and a formula? - Microsoft Excel MCQs

Home / Programming MCQs / Microsoft Excel MCQs / Question

V

Vishal Gupta • 7.73K Points
Tutor III

Q. What is the difference between a function and a formula?

(A) A function is a commonly used, preset formula

(B) A formula is basic math while a function is more advanced math

(C) You have to create the formula but a function is like an "auto formula" in Excel

(D) Functions are used in statistics

Correct answer: Option(A)

Microsoft Excel Share

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on Microsoft Excel

To insert three columns between columns D and E you would

Which of the following is not a worksheet design criterion?

Which elements of worksheet can be protected from accidental modification

You can copy data or formulas

How can you show or hide the gridlines in Excel Worksheet?

In Excel the cell labeled F5 refers to

To view a cell comment

You can auto fit the width of column by

Which of the following is not an MS-Excel term?

In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

Learn All Microsoft Excel MCQs