MS Excel Honors #10

Match it! Select the correct answer from the pull down...Good luck!

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

Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?

Kash is working with a large, complex worksheet and would like to to see what is going on in different cells in different parts of the workbook. What built-in tool would Kash use to make monitoring various cell values much simpler?

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?

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

Doug wants to know how many gadgets he would have to sell to make $1,000,0000. Which Excel tool will help Doug find the answer?

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

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