Excel EXPERT Lesson 3 Quiz

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

• DATE

• NOW

• TODAY

• YEAR

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

• Financial

• Logical

• Math & Trig

• Statistical

Michelle is trying to correct a formula error in cell B7. Which command will help her identify the cells that affect the value of B7?

• Error Checking

• Evaluate Formula

• Trace Dependents

• Trace Precedents

As the manager of a furniture store, Sally is using an Excel spreadsheet to keep track of the store sales goals. She wants to use a function that will return "TRUE" if at least one of the two goals is reached. Which function should she use?

• AND

• IF

• NOT

• OR

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

Which Excel term, denoted with [square brackets], can be found in the header row of a table and refers to the set of all cells that comprise the named column in the table?

• absolute cell reference

• constants

• FieldName

• TableName

Which is an example of a correctly written nested function?

• =PROPER(RIGHT(B4,LEN(B4)-FIND(" ",B4)))

• =PROPER[RIGHT(B4,LEN,B4)-FIND(" ",B4))]

• =PROPER((RIGHT(B4,LEN(B4-FIND(" ",B4)))

• =(PROPER(RIGHT(B4,LEN(B4)-FIND(" ",B4)))

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

In order to change the name of a range of cells, the user must first click the Formulas tab. What feature should the user click next?

• Define Name

• Name Manager

• Name Selector

• Trace Dependents

Naming ranges or an individual cell is a time-saving technique. Range names may include a letter, an underscore, and:

• a backslash.

• an exclamation point.

• a forward slash.

• a question mark.