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?

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

Which Excel term refers to a selection of cells?

Which Excel feature keeps track of defined ranges and cell addresses?

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?

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

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?

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?

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

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?

Which financial function allows Robyn to determine the amount she must pay each month on her car loan?

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?

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

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

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

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2024 Review Game Zone | About | Privacy | Contact | Terms | Site Map