How can you identify one or more circular references in an Excel spreadsheet where a formula causes them?
a) Use the Formula Auditing tools under the Formulas tab.
b) Check the cell references in each formula manually.
c) Use the Data Validation feature.
d) Use the Conditional Formatting option.