MS Excel Honors #10 Question Preview (ID: 54183)


Review.

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?
a) absolute cell reference
b) constants
c) FieldName
d) TableName

Which symbol refers to a field name in a table that has already been named?
a)
b) =
c) \
d) #

Which Excel term refers to a selection of cells?
a) group
b) name box
c) range
d) table

Which Excel feature keeps track of defined ranges and cell addresses?
a) Group Locator
b) Name Manager
c) Content Finder
d) Table Index

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?
a) Data Validation
b) Existing Connections
c) Goal Seek
d) Scenario Manager

PMT, PV, and FV are functions found in which Function Library category?
a) Financial
b) Logical
c) Math and Trig
d) Statistical

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?
a) Consolidating Data
b) Error Checking
c) Evaluate Formula
d) Watch Window

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?
a) Consolidate Data
b) Error Checking
c) Evaluate Formula
d) Watch Window

Mrs. Perry is troubleshooting formulas and functions in her Excel workbook. Which feature would she use to check for common mistakes in formulas?
a) Consolidate Data
b) Error Checking
c) Evaluate Errors
d) Watch Window

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?
a) Error Checking
b) Evaluate Formula
c) Trace Dependents
d) Trace Precedents

Which financial function allows Robyn to determine the amount she must pay each month on her car loan?
a) PV
b) PMT
c) NPER
d) RATE

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?
a) Error Checking
b) Evaluate Formula
c) Trace Dependents
d) Trace Precedents

Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range of data where the lookup value is located?
a) lookup_value
b) table_array
c) range_lookup
d) array_table

An Excel formula that is placed within another formula is referred to as:
a) named
b) consolidated
c) nested
d) name ranged

Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
a) TODAY
b) WEEKDAY
c) DATE
d) CURRENTDATE

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 54183 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register