If a quiz question asks about a formula error, remember that Excel errors are clues. #NAME? usually means a function name is misspelled, while #REF! means a cell reference is no longer valid.
Best for showing trends over time (months, quarters, years). work smarter with microsoft excel coursera quiz answers
#VALUE! : Occurs when a formula contains the wrong type of argument (e.g., trying to add text to a number). If a quiz question asks about a formula
Answer: a) To add notes to a worksheet