Multiple calculations can be made in a single formula using
A. standard formulas
B. array formula
C. complex formulas
D. smart formula
B. array formula
Show Your Love! Share this page!
This question "Multiple calculations can be made in a single formula using ... A. standard formulas B. array formula C. complex formulas D. smart formula" is asked from MS Excel topic and more specifically, it is from MS Excel Funcations & Formula.
It is one of the important question and appeared frequently in many of the computer jobs exams. It is equally probable for Computer Operator Examination as well. The question aims to test candidate's familiarity to different kinds of Excel formula and functions.
Multiple calculations can be made in a single formula using ...
The question Multiple calculations can be made in a single formula using ... A. standard formulas B. array formula C. complex formulas D. smart formula is more of tricky rather than requiring reasoning. It offers four options pretending to presenting four different kinds of Excel formula.
Essentially there no types of Excel formula as such standard, complex or smart formula. However, there's an array formula.
In excel, either we have simple formula or complex formula based on the level of complexity involved in the formula entered. There's not different method to create these two kind of formula.
Whether you are aware of other three options or not, if you know array formula, this question fails to trick you.
An array formula is a formula that can perform multiple calculations on one or more of the items in an array .
You can think of an array as a row of values, a column of values, or a combination of rows and columns of values.
Array formulas can return either multiple results or a single result. For example, you can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. You can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.
Array formulas are powerful formulas that enable you to perform complex calculations that often can’t be done with standard worksheet functions. They are also referred to as "Ctrl-Shift-Enter" or "CSE" formulas, because you need to press Ctrl+Shift+Enter to enter them. [Source]
Reference: Pearson Software Consulting