Excel Final Exam Review

Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range of data where the lookup value is located?

• lookup_value

• table_array

• range_lookup

• array_table

Jordan needs to evaluate a formula in his worksheet for accuracy. He wants to use a function that returns a statement that he specifies in the event that an error is found. Which function should he use?

• ERROR

• ERROR.TYPE

• IFERROR

• INCORRECT

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

Which Excel term refers to a selection of cells?

• group

• name box

• range

• table

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

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

• DATE

• NOW

• TODAY

• YEAR

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

• Hyperlink

• Web link

• Linkup

• Text link

Carl notices that the data in cell E4 reads ###. What command could Carl choose to correct this problem?

• AutoFit

• Special Formatting

• Subscript Formatting

• Wrap Text

What type of formatting appears only when the value in a cell meets conditions specified by a user?

• Criterion

• Conditional

• Logical

• Restrictive

What command is used to apply a background color to cells in a worksheet?

• Drawing

• Fill Color

• Borders & Shading

• Highlight