1. Complex formula has only one mathematical operation. 2. The DATEDIF function calculates the difference between two dates. 3. Relative reference do not use the $ sign in cell references. 4. Cell references do not update the values dynamically. Identify the answer based on the clues.
Answers
Answer:
Microsoft Excel formulas - the basics
In MS Excel, formulas are equations that perform various calculations in your worksheets. Though Microsoft has introduced a handful of new functions over the years, the concept of Excel spreadsheet formulas is the same in all versions of Excel 2016, Excel 2013, Excel 2010, Excel 2007 and lower.
All Excel formulas begin with an equal sign (=).
After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either:
Type the entire equation: =B1+B2+B3+B4+B5
Use the SUM function: =SUM(B1:B5)
Press the Enter key to complete the formula. Done!
Microsoft Excel formulas
Elements of Microsoft Excel formulas
When you make a formula in Excel, you can use different elements to supply the source data to the formula and indicate what operators should be performed on those data. Depending on the formula type that you create, it can include any or all of the following parts:
Constants - numbers or text values that you enter directly in a formula, like =2*3.
Cell references - reference to a cell containing the value you want to use in your Excel formula, e.g. =SUM(A1, A2, B5).
To refer to data in two or more contiguous cells, use a range reference like A1:A5. For example, to sum values in all cell between A1 and A5, inclusive, use this formula:
=SUM(A1:A5).
Names - defined name for a cell range, constant, table, or function, for example =SUM(my_name).
Functions - predefined formulas in Excel that perform calculations using the values supplied in their arguments.
Operators - special symbols that specify the type of operation or calculation to be performed.