NEW
Font size
WorksheetsIntermediate Excel
Total questions: 10
Worksheet time: 3mins
These are predefined formulas that are already available in Excel.
Formulas
Functions
Operators
What part of a formula identifies a cell or a range of cells on a worksheet and tells Excel where to look for the value or data you want to use in the formula?
Constants
Functions
References
These are numbers or text entered directly into a formula. These values are not calculated.
Constants
Operators
Functions
These specify the calculation you want to perform on the elements of the formula.
Functions
Operators
References
This type of cell referencing is indicated by a "$".
Absolute
Arithmetic
Relative
These operators perform basic mathematical operations.
Comparison
Arithmetic
Formulas
VLOOKUP is an example of a ______________.
Formula
Cell Reference
Function
Which is an example of a Relative Cell Reference?
$A$4
A4
None of the above.
Which is an example of a Comparison Operator?
>
*
/
Which cell reference is best used if you want the reference to remain at cell D56 even if you extend the formula?
D56
$D56
$D$56
