Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #10
Test Description: Review
Instructions: Answer all questions to get your test result.
1) 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
FieldName
B
constants
C
TableName
D
absolute cell reference
2) Which symbol refers to a field name in a table that has already been named?
A
\
B
=
C
#
3) Which Excel term refers to a selection of cells?
A
range
B
table
C
group
D
name box
4) Which Excel feature keeps track of defined ranges and cell addresses?
A
Name Manager
B
Content Finder
C
Group Locator
D
Table Index
5) 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
Scenario Manager
B
Data Validation
C
Goal Seek
D
Existing Connections
6) PMT, PV, and FV are functions found in which Function Library category?
A
Math and Trig
B
Financial
C
Logical
D
Statistical
7) 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
Watch Window
B
Evaluate Formula
C
Consolidating Data
D
Error Checking
8) 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
Evaluate Formula
B
Error Checking
C
Consolidate Data
D
Watch Window
9) Mrs. Perry is troubleshooting formulas and functions in her Excel workbook. Which feature would she use to check for common mistakes in formulas?
A
Error Checking
B
Consolidate Data
C
Evaluate Errors
D
Watch Window
10) 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 Precedents
D
Trace Dependents
11) Which financial function allows Robyn to determine the amount she must pay each month on her car loan?
A
NPER
B
PMT
C
PV
D
RATE
12) 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
Trace Dependents
B
Trace Precedents
C
Evaluate Formula
D
Error Checking
13) Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range of data where the lookup value is located?
A
range_lookup
B
table_array
C
lookup_value
D
array_table
14) An Excel formula that is placed within another formula is referred to as:
A
nested
B
named
C
name ranged
D
consolidated
15) 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
DATE
B
CURRENTDATE
C
TODAY
D
WEEKDAY
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?