Excel Expert Lesson 3 Review

An Excel table of text, numbers, or values that can be used in a formula is referred to as a/an:

• argument

• criterion

• table

• table array.

Mrs. Perry is troubleshooting formulas and functions in her Excel workbook. Which feature would she use to check for common mistakes in formulas?

• Consolidate Data

• Error Checking

• Evaluate Errors

• Watch Window

PMT, PV, and FV are functions found in which Function Library category?

• Financial

• Logical

• Math & Trig

• Statistical

Which symbol refers to a field name in a table that has already been named?

• [

• =

• \

• #

Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?

• COUNT

• IF

• NOW

• TODAY

Perry is using multiple worksheets and would like to total the numbers into one summary worksheet. Which built-in Excel tool should Perry use to accomplish his goal quickly?

• Consolidate Data

• Error Checking

• Evaluate Formula

• Watch Window

Michelle is trying to review all formulas in her worksheet for accuracy. If the active cell is A2, which command will help identify the cells that are affected by A2?

• Error Checking

• Evaluate Formula

• Trace Dependents

• Trace Precedents

Which function takes three separate values and combines them to form a date-time code?

• DATE

• NOW

• TODAY

• YEAR

Tyrone would like to use a function that returns a value that meets criteria in the second row of a table in his spreadsheet. Which function should he use?

• INDEX

• HLOOKUP

• MATCH

• VLOOKUP

An Excel formula that is placed within another formula is referred to as:

• named

• consolidated

• name ranged.

• nested